Display query string from usage data

(0) Share

Report

Posted on by Stefan Wojtas

550

Hi, everyone,
I am currently trying to create a form using a key user, which should display a list of which user is using saved queries within a form.
The saved queries name should ideally be displayed and the queries should be output as a string.

I can also access the packed queries per user via the usage data, but I can't get the queries unpacked.

Within the SysQueryForm class there is the loadQueryPack method, but I can't really get any further with the loaded container from the usage data.

Does anyone of you have an idea how I can achieve the goal.

I can also provide some more information if needed.

greeting
Stefan

All responses (2)

Answers (0)

Stefan Wojtas 550 on at

Like (0)

Report

RE: Display query string from usage data

Hello Martin,

thanks for your answer, but unfortunately it doesn't seem to be an instance of QueryRun.

There can also be multiple saved queries in this container.
Martin Dráb 233,013 Most Valuable Professional on at

Like (0)

Report

RE: Display query string from usage data

Unfortunately I don't remember the solution in AX 2012, but isn't it a packed instance of QueryRun class? If so, you can unpack it by QueryRun qr = new QueryRun(sysLastValue.Value).