주 콘텐츠로 건너뛰기

My custom report with a lot of fields is failing - 지식 베이스 / Developer & Reporting / Creating Reports - Deskpro Support

My custom report with a lot of fields is failing

저자 리스트

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.

 

도움이 되었습니다 도움이 되지 않음

이 페이지가 도움이 된다고 생각하는 사람들의 수 42 / 79