Display result of Custom Query Builder in browse/grid or in which cursor is the resul

[Schlingmeier]

When I enter a filter via Custom Query Builder, I can then use the actionbar to scroll through the filtered records. However, I would now like to see the result of the filtered datasets displayed in a browse/grid. If I call up the customers table, I see all of them. Hence my question, is the result reported in a different table. How can I get the filtered data? Greetings Olaf

Display result of Custom Query Builder in browse/grid or in which cursor is the result of Query Builder?

[barrymavin]

Hi Olaf,

A section can have any of the following that are used to filter the data being displayed.

- Search field
- Search bar
- Search panel
- query builder filter
- filter
- row filter

These are all concatenated and the filter used to refresh the data

There is no temporary table as Lianja uses Rushmore index optimizations on desktop and odata calls to the server in web and mobile apps.

In your desktop app if you want to browse a section in a popup window (see Lianja.showDialogForm() in web/mobile) you can have a section menu item that causes the following code to be executed.

local m_selected = select()
local m_tmpname = tmpnam()
select yourtable
copy to &m_tmpname
browse 
select &m_selected

[Schlingmeier]

Thanks Barry If I understand correctly, there is no way to further use the result of the query builder. I imagine that I want to output the displayed result in a CSV file. Or is there a way to query the set filter? Greetings Olaf

[barrymavin]

Hi Olaf

All you need to do is

copy to … type csv

That data will be automatically filtered based on the active querybuilder filter.

If you require JSON, EXCEL, etc use the SQL SELECT command after the COPY.
https://www.lianja.com/doc/index.php/SQL_SELECT