Expand my Community achievements bar.

SOLVED

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

Avatar

Level 5

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

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

@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

Avatar

Administrator

@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!



Kautuk Sahni