Is there a recent change to the length of a query in Query Service?

[stefanm38281801]

Hi,

since a week, I'm not able to load a previously created query template in Query Service. I must admit that the query is pretty large, since it has to test on multiple product codes with a 'ilike' statement (with equal or in, the number would even be significant larger).

If I strip down the query, at a certain point it starts loading again. At the moment the query is about 5,5K char size.

Does anyone know if there was a recent limitation introduced into platform?

Stefan

[gkalyan · Accepted solution]

@stefanm38281801 

There is no explicit character limit for query templates in the Query Service AFAIK

But you check out the Guardrails document. This should be helpful

https://experienceleague.adobe.com/en/docs/experience-platform/query/guardrails

And best practices document 

https://experienceleague.adobe.com/en/docs/experience-platform/query/best-practices/writing-queries

[kautuk_sahni]

@stefanm38281801 Did you find the suggestion helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!