Filter Groups on Header based on Lines

(0) Share

Report

Posted on by Community Member

I have created a new document page with Header table and Line table.

My Requirement is I have to display Enteries in List page only if the current user is approver ( a field in line table) in atleast one of the lines.

And when he clicks on the document , the page opens and only show the lines where the current user is approver and not other lines where he isnt a approver.

Any help would be great to have.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

Amol Salvi 18,698 on at

Like (0)

Report

How about creating list page based on lines and then write a code to open document page

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Jaspreet,

Can there be multiple approvers for a single document?

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Yogesh, Yes there can be because the approver is on per line basis

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amol , that is the workaround I was thinking but this would lead to multiple entries of the same document in case the approver has multiple lines that he has to approve in the same document

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Jaspreet,

What about setting SubPageView property of a ListPage?

Or the same can be achieved using code as well.

You will need to show the records from ListPage where ListPage.UserID = USERID

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yogesh, SubPageView Property is not working for me. I used "WHERE(Approver ID=FILTER(USERID)) " USERID should be the current user.

for the code method Where exactly should i write this code ?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

IF you are approver is approving based on line then you need to design customized page and if you approver field is available on header then I think you can filter on line for displaying only those records pertaining to that approver.

Hope my understanding is correct Isn't It ??

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Amol, Yes the approver is approving on basis of line. Approver User ID is available only on the line as well.

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Jaspreet,

On OnAfterGetRecord trigger of List Page write code as:

SETFILTER(Rec.Approver ID,'%1',USERID);

You will see only those records where ApproverId will match with the logged in User ID.

I have tested this and working well.

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No