Hello, Just trying to understand...@Shruti1 asked about the delivery's working tables (wkDlv_*) but @Denis_Bozonnet replied about workflow's working tables (wkf_*).My question is: Is the "Keep interim result" workflow's setting affect some how the delivery's working tables? We have the same issue bu...

This peace of code is useful. I will try. Thank you, @david--garcia !

I tried but no success SCM-120008 Unable to find key values for element 'TestKey' (document with schema 'TestKey') XSV-350023 Unable to save document of type 'ef:TestKey'. SOP-330011 Error while executing the method 'Write' of service 'xtk:persist|xtk:session'.

@david--garcia, Thinking more I see that sqlExec is better than xtk.session.Write approach. However, Is there a way to parametrize the DELETE query? If I try to delete like this: var sql = "DELETE FROM Marketing.dbo.TestKey WHERE col2 = $(l);" sqlExec(sql, 2000); I get this exception: JST-310000 Er...

@david--garcia, Thank you for the response.   Yeah, I know this approach. But it looks like a workaround and it does not use TestKey data schema.   Actually, my TestKey data schema is created using External Account, so, table TestKey is not in Neolane database. Having this, and assuming that the ext...

Hello All, ACC 7.2.2 build 9349@e319b6d of 02/28/2022MSSQL is an external database<srcSchema> is (some values are masked/dotted): <srcSchema ... entitySchema="xtk:srcSchema" img="xtk:schema.png" label="TestKey" ... name="TestKey" ... view="true" xtkschema="xtk:srcSchema"> <createdBy _cs="..."/> ...

Hello Parvesh,Thank you for detecting extra symbol, but actually I don't have it in my code. Not sure what's the problem on my end but this is what I am seeing. On front is a Javascript code window. On back is a browser where I see the exception.Any ideas? Thanks!

Dear Community, I am trying to use DBEngine query() command to select data from MSSQL database and I need to pass parameter/s to my query. I am following this tech spec - DBEngine.query() documentation.There is an example showing how to pass a param - to do this use $(l), $(sz) as a param-holder/s (...