Access sql queries from script

[amacara1]

I have a number of sql queries imported in a model from an MDG. I would like to run such an sql query from a JScript. How can one find the string from stored sql queries, please?

[Geert Bellekens]

The query is stored in the MDG xml, which, depending on the way the MDG is deployed is stored as a file, or internally in EA.
You would need to parse the xml and get that search string.

I'm pretty sure it's going to be easier to hardcode the query in your script.

Geert

[amacara1]

Thanks! I would like to avoid duplicating the query, if possible.
If it is stored internally in EA, where would I find that, please?

[Geert Bellekens]

Thanks! I would like to avoid duplicating the query, if possible.
If it is stored internally in EA, where would I find that, please?

IIRC the t_document table. But it's in a compressed binary format.

Geert

[amacara1]

Thank you. indeed, is a no go