How to filter correctly

Johannes_Nielsen · 2011-01-12

Hi all

Running NAV 5.0 on SQL

Regarding Table 5065 "Interaction Entry Log"

Theres are entries of Interactions, which have an Template Code assigned. The Template Code is part of a Template Group.

We have a Template Group named "SYSTEM" which has several Template Code members.

I need in list Form 5076 "Interaction Log Entries" - to filter out ALL members of the SYSTEM Group except One specific Template Code.

:oops: I can't figure out how to do this.. :oops:
SETFILTER/RANGE operates solely on one specifik Field at a time.
Will I have to list all the members of the Group which I want to Filter out - except the One I want to show?

Maybe filter the table twice and join the results in a temporary table?

Any inputs are appreaciated

dkone · 2011-01-12

Hi,

Maybe you could create your filter dynamically...

Something like :

TemplateCode.SETFILTER("Template Group","System");
TemplateCode.FINDFIRST;
REPEAT 
 IF TemplateCode.Code <> "UnwantedCode" THEN
   FilterTextVar =  TemplateCode.Code + '|'
UNTIL TemplateCode.NEXT = 0

InteractionEntries.SETFILTER("Template Code",FilterTextVar);

Or if it is used everywhere you can also add the Field "Template Group" in your table as a lookup flowfield and use standard table filter in your form. (Group = "System" AND Code <> "UnwantedOne")

Hope this help,

dkone.

Johannes_Nielsen · 2011-01-12

Hello dkone

Thank you so much for your suggestions, I will try them out tomorrow! :thumbsup:

How to filter correctly

Answers

Categories