A form with header/lines grids, shows lines when no header selected.

(0) Share

Report

Posted on by Community member

I have a form with a header grid and a lines grid. When I select a header in the top grid its lines are shown in the bottom grid. They are matched through a identifier and is working as intended when I select a header.

The problem is that when no header is selected (or one does not exist), there are still lines showing. The lines in question are lines that does not match any header id (an error set their id to 0). Why this has happened is another issue, for now I just want them not to be shown when no header is selected.

What is the best way to do this, can I add some filter to the relation (only show rows where id field > 0)?

All responses (3)

Answers (1)

Community member 11 on at

Like (0)

Report

A form with header/lines grids, shows lines when no header selected.

Hello Girish

I added a range on the executeQuery method of the lines grid datasource as you suggested, this is my line:

this.query().dataSourceTable(tableNum(CustLine)).addRange(fieldNum(CustLine, HEADERID)).value(SysQuery::valueNot("0"));

That seems to have done the trick, I no longer see the id = 0 lines when no header is selected, all seems fine.

I am not sure how to do the second part:

"and set the relation between the two tables as a range in the second datasource."

Is that needed if it already works? At the moment the header and lines datasource relation is refrecid == recid, how would I set a range in the relation (if it is needed).
Suggested answer

Mohit Rampal 12,556 Moderator on at

Like (0)

Report

A form with header/lines grids, shows lines when no header selected.

Hi, Please check this article

https://dev.goshoom.net/2013/11/lines-for-multiple-headers/

Thanks

Mohit
Verified answer

Community member on at

Like (1)

Report

A form with header/lines grids, shows lines when no header selected.

Hi,

You can add a range on the executeQuery method of the lines grid datasource and set the relation between the two tables as a range in the second datasource.

Thanks,

Girish S.