Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
How to make a sql query in BPM worklist

Hugo Cortijo Navascues
Member Posts: 1 Red Ribbon
Hello,
I don't know if is possible to make a query in a rule in bpm worklist. I would like to make a query inside a rule in bpm approval or any way to consult a database table.
Regards,
Hugo.
Answers
-
Was this ever answered?
-
I would like to use a SQL Query in a Cloud ERP BPM Worklist rule also. I tried, but it says the oraext identifier is not valid. Is there a way to do this?
-
Ok. If Oraext is not a valid identifier then use the ORCL. Either of the one should work. Below is the same for PO document
orcl:query-database(concat("Select '100013' usernameval from po_headers_all where po_header_id = ", /task:task/task:payload/ns0:findPurchasingDocumentHeaderResponse/ns0:result/ns7:PoHeaderId, " AND 1=1 "),false(),false(),"jdbc/ApplicationDBDS")