automatically fill of TicketFreeText

hello otrs-gurus, I have following problem: I add TicketFreeText at Ticket. Now, I want that this TicketFreeText gets a value from my databyse automatically. This value is a unique value in database (number of contract). I tried to found some documetation but without success. *there is TicketFreeFieldDefault.pm in /opt/otrs/Kernel/System/Ticket/Event, wich has two subs (funktions) but that doesn´t help me, i can´t understand it. thanks for your answers!

a small addition to my post... created ticket should be searched by 'customer_id' and 'number of contract' (should be in TicketFreeText)

a small addition to my post... created ticket should be searched by 'customer_id' and 'number of contract' (should be in TicketFreeText)

I add TicketFreeText at Ticket. Now, I want that this TicketFreeText gets a value from my databyse automatically. This value is a unique value in database (number of contract).
Don't think that TicketFreeText is correct. I'd think you'd want to add a new field to hold the contract number data - Customize the customer_user table(http://doc.otrs.org/2.4/en/html/x1936.html).

I think I described my problem not precise, Thank you for your answer, you sent the configuration of mapping/backend (customer information at the side of ticket) I have done it I configured unique customer_id there (in customer backend) and I can search for created ticket when I type his cusotmer_id. but I need second unique id, wich I can search for. in my case it is contract of customer. thx ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of LQ Marshall Sent: Monday, November 30, 2009 4:39 PM To: 'User questions and discussions about OTRS.' Subject: Re: [otrs] automatically fill of TicketFreeText > I add TicketFreeText at Ticket. Now, I want that this TicketFreeText gets a value from > my databyse automatically. This value is a unique value in database (number of contract). Don't think that TicketFreeText is correct. I'd think you'd want to add a new field to hold the contract number data - Customize the customer_user table(http://doc.otrs.org/2.4/en/html/x1936.html).

Igor Cherepanov wrote: I think I described my problem not precise, Thank you for your answer, you sent the configuration of mapping/backend (customer information at the side of ticket) I have done it I configured unique customer_id there (in customer backend) and I can search for created ticket when I type his cusotmer_id. but I need second unique id, wich I can search for. in my case it is contract of customer. thx Pretty sure the solution is included at the URL. It describes the steps needed to customize the table, in this case add a field to hold and display your customer data. The field can be searched against. There maybe other solutions... Just my 2¢ - Sent from my mobile device
participants (2)
-
Igor Cherepanov
-
LQ Marshall