Coming soon: Your brand new Help Center & Community! Get a sneak-peek here

Where are all list items saved to ejTicket x_feld with List Value

Hi,

I have a x_feld with List to ejTicket. In which Table are all list items saved?

Thanks!

RE: Where are all list items saved to ejTicket x_feld with List Value

Hi,

This depends on definition of this x_field, is this a Text(short) field with values or Extra table relation?

If this is Text(short) field, value is stored in ticket.x_field
If this is Extra table relation, actual value is stored in Extra table and only reference to which row is stored in ticket.x_field.

Hopefully this is clear :)

Von: Michel Krohn-Dale 24. Aug 2020

RE: Where are all list items saved to ejTicket x_feld with List Value

Hi Michel,

Thanks.

the x_field is short text.

I mean, where is all items of List stored?

I create a reporting tools via Data Mirror Database, wher i create a dropdown list for user to get all list items for this x-field?

Thanks!

Von: Jianchun You 24. Aug 2020

RE: Where are all list items saved to ejTicket x_feld with List Value

Hi,

In this case you have to look to extra_fields.params column;
My simple field with 3 options

defaultNow=0
defaultActiveUser=0
option=Value 1
option=Value 2
option=Value 3
Von: Michel Krohn-Dale 24. Aug 2020

RE: Where are all list items saved to ejTicket x_feld with List Value

Hi Michel,

 

yes i got it, you are right, Thanks!!

Von: Jianchun You 24. Aug 2020