Filter Data

jsshivalik
Member Posts: 67
Hi
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
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
0
Answers
-
No. field in Sales Line refers to G/L or Item, or Reource etc, not to a Location.
Your filtering code shold look someting like this:
...//IF UserMgt.GetUserInfo.. is not necessary if you use SETFILTER SETFILTER("Location Code", UserMgt.GetUserInfo2(USERID));
- assuming that the UserMgt.GetUserInfo2(USERID) returns a valid location code (or locatin code list)
Still the code above will display all Sales Lines sharing the same location code. If you want to have only one record displayed per user you have to make sure that only one record with unique location code per user exists in your Sales Line.Slawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030 -
Hi Slawek
I have Location as Main Form & Sales Line as Sub Form. I want that only one record according to user Location should get displayed . Problem i am facing when i click Next Button it display another Blank record for that Location.
I have below code
IF UserSetup.GET(USERID) THEN
BEGIN
UserSetup.TESTFIELD("Location");
IF (UserMgt.GetUserInfo2(USERID) <> '' )THEN BEGIN
FILTERGROUP(2);
SETRANGE("No.",UserMgt.GetUserInfo2(USERID));
FILTERGROUP(0);
END;
END ELSE BEGIN
ERROR('Record Does Not Exists');
END;
FILTERGROUP(2);
Thanks0 -
"No." field field is not unique on Sales Line. You can have many sales lines having all the same value No.
Are you familiar with the concept of primary key?
Slawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions