How to make a sql query in BPM worklist

Hugo Cortijo Navascues

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.

bla-Oracle

Hi Hugo,

I moved your question from space to space. You should have a better chance of getting a response here.

Regards,

- Burkhard

erp_expert03

Was this ever answered?

user4931071

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?

Vishal P-Oracle

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")