SETFILTER parameter problem

erik_kurniawan

Hi experts,

I have 15 parameter to use in Filtering some data. such as many problem this may not possible to use code SETFILTER(Data,'%1|%2...%15,value1,value2...value15) because theres only 12 maximum parameter. Is there any technique to handle this problem? thanks before...

Belias

do not use parameters

setfilter(myfield,format(myvariable) + '..' + format(myothervariable));

and so on..

bluerock

Divide it into 15 filters:

"Sales Header".SETFILTER("Document Type", "Sales Header"."Document Type"::Order);.
.
.
.
15th filter

kriki

txtFilter := 'A|B|C|D'; // and this string you can make in different ways.

A way:

txtFilter := '';
recSomeTable.RESET;
recSomeTable.SETCURRENTKEY(...)
recSomeTable.SETRANGE(...);
IF recSomeTable.FINDSET THEN
  REPEAT
    txtFilter := txtFilter + '|' + recSomeTable."Some Field";
  UNTIL recSomeTable.NEXT = 0;
txtFilter := COPYSTR(txtFilter,2);

Now you have your field txtFilter with a filter in it. Use it like this:

TheTable.SETFILTER("Some Field",txtFilter);

Belias

bluerock wrote:

Divide it into 15 filters:

"Sales Header".SETFILTER("Document Type", "Sales Header"."Document Type"::Order);.
.
.
.
15th filter

:? :? :? :? :?
are you crazy?!?!only the last setfilter will be valid...each time you do a setfilter/setrange on a particular field, it overwrites previous filters on the same field (stating that you're working with the same record variable).

EDIT: kriki just remembered me that there's a way: with the help of filtergroups.
http://www.mibuso.com/forum/viewtopic.php?f=32&t=34863&p=169387&e=169387

kriki

The different filtergroups work like AND between them, so I don't think that in this case it is the correct way.

Belias

I was pointing out only that is actually possible to set filters on the same field without overwriting the previous one.
The correct solution to the original problem of this thread is the one in the 2nd or 4th post (best is 4th, anyway)

erik_kurniawan

Dear all,

sorry i haven't explain before.
here the full story...

Navision have Responsibility Center field.

in this case i want to make multiple resp. center to Filter Customer.
The step is ;

1. I have assigned customer to one resp. center before.
2. I have made one tabel contain role information.
Field ; username, resp. center

The record is like ;
- username A, resp. center A
- username A, resp. Center B
- username A, resp. center C
- username A, resp. center D
- username A, resp. center E
- username A, resp. center F
- username A, resp. center G
- username A, resp. center H
- username A, resp. center I
- username A, resp. center j
- username A, resp. center K
- username A, resp. center L
- username A, resp. center M
- username A, resp. center N

3. When user want to open customer card form and also customer list form, it will check to role table about username role.
so the result is 'username A only can see customer that have resp. center A,B,C,D,E,F,G,H,I,J,K,L,M,N'.

Its not possible to use code SETFILTER because maximum parameter is 12.

My question is how to make the filter is possible?

Thanks all...
Regards,

Erik

Sog

Look at the post Kriki made
this will make a string with all the responsibility centers for that user.
Let's say username A opens the customer card
then with kriki's method you get a filter like:
setfilter("resp. center","A|B|C|D|E|F|G|H|I|J|K|L|M|N")
so instead of a filter with 15 parameters you get 1 parameter with all the 15 responsibility centers in and the | sign

DenSter

Be aware that a filterstring can only be 250 characters. So if you have 15 customers with numbers that are 20 characters, you are going to run into an error. I'd consider an alternative solution, perhaps one with a temporary record variable.

erik_kurniawan

Ok, I will try kriki's method. I hope it can solve my problem [-o< ...

thanks all.

Regards,
Erik

pawanp

Be aware that a filterstring can only be 250 characters. So if you have 15 customers with numbers that are 20 characters, you are going to run into an error. I'd consider an alternative solution, perhaps one with a temporary record variable.

How to implement and alternative solution using a record variable..
As my key is exceeding maximum character length..
Please someone help on this context.. Its urgent. ](*,)

mabl4367

1. Create a temp record variable. (Just set its "Temporary" property to "Yes".

2. Filter the customers once for each responsibility center that the user belongs to and copy the records you get to the temporary table.

Andwian

erik_kurniawan wrote:

3. When user want to open customer card form and also customer list form, it will check to role table about username role.
so the result is 'username A only can see customer that have resp. center A,B,C,D,E,F,G,H,I,J,K,L,M,N'

I think it is by design. No need to do modification.