Record filtration in OnOpenPage trigger

mohana_cse06 · 2017-06-27

I want to show projects which have some specific permissions to the user which opening Projects list page.

I have written below code to calculate the permissions and store records in tempJob table.

what is the best way to apply those jobs from temporory variable to rec variable?

JobTMP.DELETEALL;
Job.RESET;
Job.SETFILTER(Blocked,'%1|%2',Job.Blocked::" ",Job.Blocked::Posting);
IF Job.FINDSET THEN
REPEAT
IF (Job."Person Responsible" = UserSetupRec."Resource Code") OR (Job."Project Manager" = UserSetupRec."Resource Code") THEN BEGIN
JobTMP := Job;
IF JobTMP.INSERT THEN
JobTMP.MODIFY;
END ELSE BEGIN

IF LimitProjectsandTasksLookup(UserSetupRec."Resource Code",Job."No.",'') THEN BEGIN
JobTMP := Job;
IF JobTMP.INSERT THEN
JobTMP.MODIFY;
END;

END;

UNTIL Job.NEXT = 0;

taher.bha · 2017-06-28

Hi Mohana,
I am not sure this is the answwer you are looking for, but i would suggest, as an alternative, to apply the required permissions by modifying the OnFindRecord and OnNextRecord triggers on the page.
This is IMHO the more flexible way to apply more complex filters
See Page 7347 - Locations with Warehouse List as an example.

taher.bha · 2017-06-28

Hi Mohana,
I am not sure this is the answwer you are looking for, but i would suggest, as an alternative, to apply the required permissions by modifying the OnFindRecord and OnNextRecord triggers on the page.
This is IMHO the more flexible way to apply more complex filters
See Page 7347 - Locations with Warehouse List as an example.

mohana_cse06 · 2017-06-28

I will apply this in my scenario.
do you have any idea whether it works if users are working simultaneously without any error?

taher.bha · 2017-06-28

I got no problems when using this technique (which is already in use in standard NAV).
I should admit that in my own scenarios the records involved are lower than 100 but I don't see why a higher number of records or a multiple simultaneous access should be a source of problems as we are just checking for each record whether it should be displayed or skipped when loading the page.

Hope this helps.

mohana_cse06 · 2017-06-28

Thank you and didn't notice any issue in initial testing.

NavNab · 2017-06-28

taher.bha wrote: »

but I don't see why a higher number of records or a multiple simultaneous access should be a source of problems

Hi all,

A colleague of mine implemented this solution on a table with thousands of records and it's very very very slow when the end users run the page.

vaprog · 2017-06-28

Hi nabil.bamoh@hotmail.com

if it's slow then this is probably because you have to skip over many records in OnNextRecord. Implement some logic to circumvent this.

First set a filter as good as possible in Rec.
Then, if filter function (WMSMgt.LocationIsAllowed in the Page 7347 mentioned above) returns false, check if you can skip stretches of records, that will get rejected. E.g. you might want to use a second record with an different filter (same sort order though) and step through them alternatingly. You might even need a rec for a different Table for this.

NavNab · 2017-06-28

Thank you @vaprog , I shall pass the message

mohana_cse06 · 2017-07-19

Now, the lookup or dropdown page is filtred correctly but user can enter data which is not present in list.

How can we solve it?

Juhl · 2017-07-19

What about Security Filter

mohana_cse06 · 2017-07-20

Security filter in permissions?

I somewhere read uzing security filters cause lot of problems?

Juhl · 2017-07-20

But for specific problems maybe a solution.

mohana_cse06 · 2017-07-20

any other solution that validates data from list we have filtered?

Record filtration in OnOpenPage trigger

Best Answer

Answers

Categories