multiple Filtergroups question?

Tom1793

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...

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

Belias

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=26978

Tom1793

Thnx Belias,

I solved the problem by creating a temp table and copy the records in that table...
Works fine like that...