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)?

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, Please check this article

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

Thanks

Mohit

Was this reply helpful? Yes No
Community member 11 on at

Like (0)

Report

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).

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates