Filter by windows user group

darmaa
Member Posts: 65
Hello All,
I need to filter entries by "Windows user group" from entries. This table is customized local table. "User ID" field must be filled by "Windows user group name" when insert into table. But it filled by last "Windows user group name". How can I find correct "Windows user group name"?
IF WindowsLogin.FINDSET THEN
REPEAT
TempLogin.INIT;
WindowsLogin.CALCFIELDS(ID,Name);
TempLogin."User ID" := ShortUserID(WindowsLogin.ID);
IF TempLogin."User ID" <> '' THEN BEGIN
TempLogin."Windows Login" := TRUE;
TempLogin."Windows Login ID" := WindowsLogin.ID;
TempLogin.Name := WindowsLogin.Name;
TempLogin."Windows Login SID" := WindowsLogin.SID;
TempLogin.INSERT;
END;
UNTIL WindowsLogin.NEXT = 0;
CLEAR(TempLogin);
TempLogin.SETCURRENTKEY("User ID");
TempLogin."User ID" := USERID;
IF TempLogin.FIND('=><') THEN
"User ID" := TempLogin."Windows Login ID";
I need to filter entries by "Windows user group" from entries. This table is customized local table. "User ID" field must be filled by "Windows user group name" when insert into table. But it filled by last "Windows user group name". How can I find correct "Windows user group name"?
IF WindowsLogin.FINDSET THEN
REPEAT
TempLogin.INIT;
WindowsLogin.CALCFIELDS(ID,Name);
TempLogin."User ID" := ShortUserID(WindowsLogin.ID);
IF TempLogin."User ID" <> '' THEN BEGIN
TempLogin."Windows Login" := TRUE;
TempLogin."Windows Login ID" := WindowsLogin.ID;
TempLogin.Name := WindowsLogin.Name;
TempLogin."Windows Login SID" := WindowsLogin.SID;
TempLogin.INSERT;
END;
UNTIL WindowsLogin.NEXT = 0;
CLEAR(TempLogin);
TempLogin.SETCURRENTKEY("User ID");
TempLogin."User ID" := USERID;
IF TempLogin.FIND('=><') THEN
"User ID" := TempLogin."Windows Login ID";
0
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