Can anyone point me in the right direction to create from the advanced SQL list of functions:
...a substring of Substr(MKTG_PROMO_CELL_KEY) from character 13 to 6 as "source_id" (field)?
So the function formula is "Substring (<String>, <Offset>, <Length>)", how can I select from the above field ("MKTG_PROMO_CELL_KEY") the characters 13 to 6 within that field (to create a new field ,"source_id")?
Finally, can anyone point me to a good online resource that teaches or lists all of these SQL functions. They're are a lot of SQL sites that lists SQL functions, but anyone know a good site that lists all of them found in Adobe Campaign?
These SQL functions are written in the database underlying language code, and you can find them all in the Adobe Campaign folder node:
Select your own Database system (mySql, Postgres, SQL Server, Oracle, etc) to see how the functions listed are written in the underlying DB engine language (T-SQL for SQL Server, PL/SQL for Oracle, etc).
And one very efficient way to learn quickly is to display the generated SQL query (SQL query link, at the bottom of the form) when you define the Query through the UI, especially for date manipulation, it is easier.
florentlb, Can you close/merge the duplicate threads in one, similar to this question?
You can follow the instructions given above and extend xtk:funcList schema, Use this custom schema to enable your namespace in the default function list. The default supported names space are 'xtk','nl','nms','ncm', 'crm' and you can extend this list for your use case.