Howdy, Stranger!
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
- 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
Options
Setfilter / Filtergroup
hsilveira
Member Posts: 23
Hi all,
Im trying to make a piece of code to filter a field (code 20). The value that i want to filter is something like that:
"??????03|??????04|??????05"
When i make a simple setfilter
record.setfilter(field,'%1','??????03|??????04|??????05');
Navision return an error telling that the filter is more than 20 characters.
How can i resolv this?
I'm trying to make somthing like this:
//*************************
Parameter: pstring - text 100; ptabel - integer
Function()
i := 1;
CLEAR(temp);
WHILE pString <> '' DO BEGIN
Position := STRPOS(pString,'|');
IF Position <> 0 THEN BEGIN
temp := COPYSTR(pString,1,Position-1);
pString := DELSTR(pString,1,Position);
END ELSE BEGIN
temp := pString;
pString := '';
END;
i += 1;
END;
FOR i := 1 TO ARRAYLEN(temp) DO BEGIN
IF temp <> '' THEN BEGIN
IF pTabel = 17 THEN BEGIN
GLEntry.SETFILTER("Global Dimension 1 Code",'%1',temp);
GLEntry.FILTERGROUP(6);
END;
IF pTabel = 96 THEN BEGIN
GLBudgetEntry.SETFILTER("Global Dimension 1 Code",'%1',temp);
GLBudgetEntry.FILTERGROUP(7);
END;
END;
END;
Im trying to make a piece of code to filter a field (code 20). The value that i want to filter is something like that:
"??????03|??????04|??????05"
When i make a simple setfilter
record.setfilter(field,'%1','??????03|??????04|??????05');
Navision return an error telling that the filter is more than 20 characters.
How can i resolv this?
I'm trying to make somthing like this:
//*************************
Parameter: pstring - text 100; ptabel - integer
Function()
i := 1;
CLEAR(temp);
WHILE pString <> '' DO BEGIN
Position := STRPOS(pString,'|');
IF Position <> 0 THEN BEGIN
temp := COPYSTR(pString,1,Position-1);
pString := DELSTR(pString,1,Position);
END ELSE BEGIN
temp := pString;
pString := '';
END;
i += 1;
END;
FOR i := 1 TO ARRAYLEN(temp) DO BEGIN
IF temp <> '' THEN BEGIN
IF pTabel = 17 THEN BEGIN
GLEntry.SETFILTER("Global Dimension 1 Code",'%1',temp);
GLEntry.FILTERGROUP(6);
END;
IF pTabel = 96 THEN BEGIN
GLBudgetEntry.SETFILTER("Global Dimension 1 Code",'%1',temp);
GLBudgetEntry.FILTERGROUP(7);
END;
END;
END;
XMAN
0
Comments
record.setfilter(field,'%1|%2|%3','??????03','??????04','??????05');
The user can change the filter?
Any more idea???
XMAN
The user can change the filter if you don't put it in another filtergroup (the standard filtergroup is 0).
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!