Question

Dynamic OQL

0

Hi Team, Is it possible to write a dynamic OQL query? My requirement is to get details from an entity using OQL query, but the entity will be selected by the user at run time. I have to pass the entity name selected by the user to the OQL query and return the corresponding results. I s it possible? Regards, Megha

asked 2021-11-02

Megha George

3 answers

Jeffrey Draaijer · Answer 1 · 2021-11-02

Hi Megha,

Yes this is possible.

You would create the OQL query in a string variable and add the entity as a variable in the OQL query.

For example:

'SELECT table.field AS field1 
FROM ' + $EntityVariable + ' AS table'

Cheers,

Jeffrey

Tim v Steenbergen · Answer 2 · 2021-11-02

Yes. Take a look at the example that Arjen has supplied in the OQL module:

Miroslav Samoylenko · Answer 3 · 2021-11-02

Check how OQL UI works. It does pretty much what you want: a user types in whatever OQL string to execute, and then dump the output into a table.