@Ken_Qrious... Doesn't matter: it reminds me my last position in adobe: I was hating to beg for a survey :)))))) If I think I can help and that it doesn't take too much time it's always a pleasure to share information... And be sure this kind of knowledge base is also huge for me in order to see how...

Adobe Campaign, when tracking is enable in the delivery, places automatically the pixel tracking at the end of the email.This has been implement this way in order to avoid "false positive" when emails are scan by some specific anti-virus / spam filters...Unfortunately, today we have more & more clie...

@Ken_Qrious: my bad, when I was in Adobe Support (until early 6.1 versions), the default value of this option was 50... But no Hypothesis feature was available for example

Hi @Ken_Qrious, I didn't see your last updates. I'm glad that you've been able to narrow the issue. I don't know why your option is set to "15" as normally it's set to "50" by default. It means that someone downsized the value and it could be interesting to understand why. Managing DB perf? I think ...

@CedricRey You're right about specifying it in general (so using a work table).But in my specific example, not needed: as this is a schema integer PK, the "order by" doesn't need to be used as it will automatically use the default index (ASC order by default) @Jonathon_wodnicki , after several searc...

This is because you have to add internalName attribute in the additonal data of the query.

@Ofattah, frequency has nothing to do here... technical workflows such as operationMgt are querying the DB every 30 sec... You should involve your DBA and someone from network team in order to know from where the problem lies

Hi @Jonathon_wodnicki Didn't know for this syntax on most RDBMS.But carefull: there is no index on WKF worktables, even PK, (checked on PostGres & msSQL RDBMS). Reason is that AC assume that there is no other columns than the PK columns and having an index on a single column table doesn't help

Hi, I do not have ACC on this laptop unfortunately so I cannot develop it with you. But no, that's not the code at all I'm describing: you can inspire yourself about this code I've just wrote in notepad: var wkf2restart = NLWS.xtkQueryDef.create(<queryDef schema={vars.targetSchema} operation="select...

In the documentation, a bad practice for developper is unwantedly suggested:https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/api/data-oriented-apis.html?lang=enTo limit the number of records returned by the query to 100:<queryDef schema="nms:recipient" oper...