Passa al contenuto principale

My custom report with a lot of fields is failing - Knowledgebase / Developer & Reporting / Creating Reports - Deskpro Support

My custom report with a lot of fields is failing

Elenco degli autori

Question:

I'm trying to run a custom report I made that retrieves a lot of different fields including custom fields I've created. Once I add more than a certain number of fields, my query fails with a “There is something wrong with your query” message. What's happening?

 

Answer:

DPQL queries with more than about 55 fields will fail due to a limitation in the underlying MySQL technology. If you need to retrieve a large number of fields, you will need to use the Deskpro API.

Note that you can retrieve all fields in a table with a wildcard, e.g.

 

 SELECT tickets.*

 

but this will not work if you have added so many custom fields that you're running into the above issue.

 

Utile Inutile

42 su 79 persone hanno trovato utile questa pagina

Aggiungi un commento

Accedi o registrati per inviare un commento.

Hai dimenticato la password?