Filter Record

(0) Share

Report

Posted on by jsshivalik

3,099

I have Main Form & Sub Form . Main Form Source Table is Location & Sub Form is Sale Line Table. I have below code to filter record according to User Id Location . It should display only 1 record according to User Location . User should not be able to select any other Location. User should not be able to select Previous , Next buttons.

IF UserSetup.GET(USERID) THEN
BEGIN
UserSetup.TESTFIELD("Store No.");
IF (UserMgt.GetUserInfo2(USERID) <> '' )THEN BEGIN
SETRANGE("No.",UserMgt.GetUserInfo2(USERID));

END;
END;

Thanks

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Where is issue ???

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

When i pressed Next button it displays one more record but in non-editable mode which i don't want

Thanks

Was this reply helpful? Yes No
Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

Paste the screenshot

Was this reply helpful? Yes No
Suggested answer

npanchal on at

Like (0)

Report
Copy link

Link copied!

User FILTERGROUP, before and after the SETRANGE, it will resolve your issues.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

Can u pls guide how it should be written . I have written like this but not working properly

FILTERGROUP(2);
SETRANGE("No.",UserMgt.GetUserInfo2(USERID));
FILTERGROUP(0);

Thanks

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi Amol

I have added the screenshot

Thanks

Was this reply helpful? Yes No
npanchal on at

Like (0)

Report
Copy link

Link copied!

Which trigger are you putting your code?

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

Form - OnInit()

Thanks

Was this reply helpful? Yes No
npanchal on at

Like (0)

Report
Copy link

Link copied!

Put it on Open Page.

Was this reply helpful? Yes No