BPM Notification SQL Query Issue
Summary:
Trying to add dff value in AP notification title using SQL but facing issue when data is having single quote (')
Content (please ensure you mask any confidential information):
Trying to add dff value in AP notification title using SQL but facing issue when data is having single quote (')
Please let me know how we can replace the single quote
currently trying query as below
oraext:query-database(concat('SELECT attribute1 from ap_invoices_all where invoice_num = q'''(/task:task/task:payload/task:invoiceNum)'''') ,true(),true(),'jdbc/ApplicationDBDS')
Version (include the version you are using, if applicable):
0