This fails: [upl-image-preview uuid=be3086c0-0ac3-47ee-a4aa-ae4119e8d959 url=https://www.awareim.com/forum/assets/files/2025-11-11/1762824959-428529-image.png alt={TEXT?}] Usually, I use a Session var to build the string then use that in the FIND. Is there a way to re-write this so it will work without the extra step?

Element AS_STRING in query cannot be converted to theinstalled version of SQL

Jaymer

This fails:

Usually, I use a Session var to build the string then use that in the FIND.
Is there a way to re-write this so it will work without the extra step?

Shadow_XV

Jaymer
Try saving the 'KP_' + AS_STRING part into a text attribute on RegularUser or SystemSettings that will always in context.

You can do something like
IF SystemSettings.KPBatchID<>AS_STRING( CURRENT_DATE, 'yy-MM-dd') THEN
SystemSettings.KPBatchID=AS_STRING( CURRENT_DATE, 'yy-MM-dd')

Put this before your FIND rule so that it BatchID is updated if it is not todays date and it will skip the update if it is.

nhofkes

Have you tried EXEC_STRING ?