filter using first 5 characters (C/AL Code)

julkifli33 · **Posted:** Mon Jun 04, 2012 6:14 pm

hi all
usually when we want to filter using '*'
but how to do that in CAL code?
let say we have vendor name : microsoftdynamics
but i just have parameter micro
how to filter using first 5 characters?
thanks

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1%2',VendName,'*');

-->failed

gerrykistler · **Posted:** Mon Jun 04, 2012 6:18 pm

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1%2',COPYSTR(VendName1,5),'*');

julkifli33 · **Posted:** Mon Jun 04, 2012 6:22 pm

gerrykistler wrote:

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1%2',COPYSTR(VendName1,5),'*');

failed also

my complete code

Code: Select all

          VendName := COPYSTR(FORMAT(COPYSTR(vString,1,PosCode-1)),1,5);
          VendTable.RESET;
          VendTable.SETFILTER(VendTable."Search Name",'%1%2',VendName,'*');
          IF VendTable.FIND('-') THEN

vijay_g · **Posted:** Mon Jun 04, 2012 6:31 pm

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1','@'+VendName+'*');

Savatage · **Posted:** Mon Jun 04, 2012 6:37 pm

COPYSTR(VendName1,5)
Should be
COPYSTR(VendName,1,5)

gerrykistler · **Posted:** Mon Jun 04, 2012 6:39 pm

That's what I get for typing the code here rather than in NAV first, then copy and paste.

Savatage · **Posted:** Mon Jun 04, 2012 6:55 pm

How you you want to specify the first 5 digits?

Do you want a TEXTBOX where you enter 5 characters & then it filters?
Do you want to click on a name and it takes "that" name - get's the first 5 characters and then filters for others with the same starting 5?

Not sure what your final goal is? :-k

gerrykistler · **Posted:** Mon Jun 04, 2012 7:04 pm

I see now it is the %1%2 which is the problem. Try this:

Code: Select all

      VendTable.SETFILTER(VendTable."Search Name",'%1',VendName + '*');

kine · **Posted:** Mon Jun 04, 2012 9:00 pm

and what about

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1*',VendName);

...

gerrykistler · **Posted:** Mon Jun 04, 2012 9:04 pm

Of course, fewer characters so much improved.

kine · **Posted:** Mon Jun 04, 2012 9:20 pm

No, but correct usage of parameters... ;-)

gerrykistler · **Posted:** Mon Jun 04, 2012 9:45 pm

Yes, 6 fewer keystrokes. Both are correct and work but your's is preferred for less code space.

Note for the OP (julkifli33) - next time give your code sample along with the question, as your question was somewhat misleading as to the issue. Also any error message you received such as "No vendor found in the filter '%1%2'". You will get your answers sooner.

julkifli33 · **Posted:** Tue Jun 05, 2012 4:20 am

if i use it's ok, but it should have the exact name

Code: Select all

VendTable.SETRANGE(VendTable."Search Name",VendName);

because i want to import for 3rd party
even the same vendor, but i think its better if i search from the first 5 characters
because this 3rd party dont have vendor id

i use this code

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1',VendName + '*');

or

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1*',VendName);

the error message as i attach

mohana_cse06 · **Posted:** Tue Jun 05, 2012 6:21 am

The error message attached is nothing to do with suggested code..its a setup error..
activate debugger and check..

julkifli33 · **Posted:** Tue Jun 05, 2012 6:24 am

Hi All,
it works

Code: Select all

VendTable.SETFILTER(VendTable."Search Name",'%1',VendName + '*');

use this code
thanks

mibuso.com

filter using first 5 characters (C/AL Code)

Who is online