query tickets by City or other customer information

[girishmungra]

Hi,

is it possible to obtain a list of tickets raised from a particular city?

[crythias]

Short answer: No.
Longer answer: It's really not that simple unless customer information is in the database.
If the customer information is in the database, you could query with a join.
If the customer information is in, for instance, ldap, you will best be served creating an export module that uses the API to get the City.

It's not built-in to do that.

The other possibility would be to use dynamic fields to store this.

"Can I auto-copy from the customer?"
No.

[girishmungra]

Hi,
Was indeed able to do that using sql query.
One thing I haven't figured out though is how to join the table dynamic_field to the ticket table.

[crythias]

You can use the DynamicFieldValue API to get your information...
dynamic_field_value.value_text, value_date, or value_int hold the value of dynamic_field_value.field_id=dynamic_field.id
dynamic_field.name is the short name (fieldname)
dynamic_field.label is the display name
dynamic_field_value.object_id is the article.id or ticket.id (based upon dynamic_field.object_type)

The ticket table doesn't know of dynamic fields.

[girishmungra]

how can I for instance extract ticket details from the database where dynamic_field_eg1's value text is equal to 'test'

[crythias]

read the post you replied to.

[girishmungra]

How can I use the DynamicFieldValue API to perform an extract on 'dynamic_field_value.value_text' specific?

[crythias]

What do you want to accomplish? Explain it in English.