multiple Filtergroups question?

Tom1793
Member Posts: 5
Hi All,
I was woundering if i could use multiple filtergroups to set a combination of filters to the same table?
For example:
I have a table where i setup acces for users to different project codes, and for each of those projectcode an approval code linked.
I want to see what projects they can acces through the project code, linked to his username, but within that project code they can only acces a certain
approval level. On another projectcode that same user can have acces to a different approval level.
So i would like to use one filtergroup for the first combination of project code and the approval code and another for
the 2nd project code with that approval code linked, and another...
Here is what im trying to do...
He never returns anything... And im sure there are projects to return.
Is a NAV5.0SP1 on SQL
Can someone help?
Thnx!
Tom
I was woundering if i could use multiple filtergroups to set a combination of filters to the same table?
For example:
I have a table where i setup acces for users to different project codes, and for each of those projectcode an approval code linked.
I want to see what projects they can acces through the project code, linked to his username, but within that project code they can only acces a certain
approval level. On another projectcode that same user can have acces to a different approval level.
So i would like to use one filtergroup for the first combination of project code and the approval code and another for
the 2nd project code with that approval code linked, and another...
Here is what im trying to do...
FOR x := 1 TO i DO BEGIN FILTERGROUP(9+x); SETFILTER("Project Code",gProjectFilter[x]); SETFILTER("Approval State",'%1',gStageFilter[x]); SETFILTER("WF State", '%1|%2', "WF State"::"Approval(prices)", "WF State"::"Approval(receipts)"); END; FILTERGROUP(0);
He never returns anything... And im sure there are projects to return.
Is a NAV5.0SP1 on SQL
Can someone help?
Thnx!
Tom
0
Comments
-
be aware that multiple FILTERGROUPS works like an "AND", not like an "OR"...
see this how to. http://www.mibuso.com/howtoinfo.asp?FileID=22 and search filtergroup in your browser. You'll certainly get what the problem is.
and this is for the next question you would have done
http://www.mibuso.com/forum/viewtopic.php?f=23&t=269780 -
Thnx Belias,
I solved the problem by creating a temp table and copy the records in that table...
Works fine like that...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