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

Question

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 Answer

@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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded