Generating a preview from SysQueryForm

(0) Share

Report

Posted on by Community Member

Hi all

I have an interesting thought from an end-user: it would be handy to have a "preview" run of any query that's currently made up in the SysQueryForm.

Is this even possible? Building a grid dynamically based on a passed query and execute it with like the first 10 rows.

Conceptually, i guess yes, as you know the tables, fields and ranges. You could then create proper columns and then execute the query and populate the grid.

The difficult part lies in converting the in-memory (not in AOT!!) Query and its QueryBuildDataSources to FormBuildDatasources etc. Is there an easy way? Preferably, I dont want to loop over all the datasources/ranges and convert. Simply passing along the query (or its datasources) as an object somewhere would be perfect.

Interested to hear your opinions.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

RE: Generating a preview from SysQueryForm

Hi Tim De Lobelle,

Its already done a while ago www.axaptapedia.com/DEV_QueryBrowser

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Generating a preview from SysQueryForm

exactly what i needed, much thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
RE: Generating a preview from SysQueryForm

For anyone interested in the solution, see screenshots.

First import the project mentioned above. I decided not to import the context menu stuff.

Then add a button on the SysQueryForm (see screenshot 1)

Add the code in the clicked method (see screenshot 1)

Click the button and the current query you are editing in the SysQueryForm should display results in the QueryBrowser.

Have fun :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Generating a preview from SysQueryForm

@TimDeLobelle

I wanted to ask how you implemented this. Can you explain.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Generating a preview from SysQueryForm

Hi Maha

The steps are described in my last post.

One thing i'd note is that you better instantiate a new query instead of passing it by reference.

The QueryBrowser seems to fiddle with the query object and you dont want it to be changed by the querybrowser as it might result in bugs in your business logic.

In the clicked method you should use: new DEV_QueryBrowser().run(new Query(sysQueryForm.query()));

What part are you having trouble with?

Was this reply helpful? Yes No