Hi,The Iif() sql expression? It's documented in its call:List of functions This is analogous to decode() in Oracle:DECODE Thanks,-Jon

Hi,For operators with the createProcess right, it's execCommand() in workflow js.Script should be executable by the neolane user.You can also read the file in js with loadFile() or similar, then it's just iterating and setting fileT[col][row] = file[row][col];Thanks,-Jon

Hi,Assuming 'dynamic subjects' are materialized subject lines ('Hello <%= recipient.firstName %>' => 'Hello Mustafa'), they can be stored to broadlog by extending nms:broadLogRcp (assuming recipient target) and altering its target mapping's storage parameters to include the data in the delivery's su...

Hi,The xpath is from the join element of the primary table, assuming that's where you're referencing it from, e.g. nms:seedMember/extendedTableLinkName/@id. If you're accessing it directly, it's just cus:extendedTableName/@id.Thanks,-Jon

Hi,Set referential integrity in the schema, on the seed table's join element to your table:<element type="link" .. integrity="own"/>Or from your table to the seed table:<element type="link" .. revIntegrity="own"/>Thanks,-Jon

If the user has all rights except ADMINISTRATION, it must be a folder issue. The ootb delivery operator group is granted access to the folders above along with a couple other ones. Perhaps create a user in the ootb group, test that it can send deliveries, then match up the new group's folders with t...

Hi,MS Dynamics connector uses a variety of URL's, which can be found in crm:mscrmConnector.js, and partially in your config above. If you're debugging the calls, the easy approach is to put a mitm proxy between the wfserver and the internet and capture what's triggering the 500 response. More diffic...

Yes 1 workflow per delivery is clearest.

*Filtering dimension has to be nms:recipient to do this.

It’s the same, and’ed to this query, though with ‘not exists’ instead of ‘exists’ and with the second delivery instead of the first. You don’t need to do it here if the workflow runs on a daily cadence, since it’s implied by the 7 day check on first delivery. Might come up later on a variant though.