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

Where is issue ???

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

Like (0)

Report

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

Paste the screenshot

Was this reply helpful? Yes No
Suggested answer

npanchal on at

Like (0)

Report

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

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

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

Like (0)

Report

Hi Amol

I have added the screenshot

Thanks

Was this reply helpful? Yes No
npanchal on at

Like (0)

Report

Which trigger are you putting your code?

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

Like (0)

Report

Hi

Form - OnInit()

Thanks

Was this reply helpful? Yes No
npanchal on at

Like (0)

Report

Put it on Open Page.

Was this reply helpful? Yes No