Need a help in a filtering of information...

Becka

Hi all..

I need to filter a table... For example i need to filter table by words in which there's 'X' symbol, and in second case by words in which there's no 'X' symbol... If any ideas just help me

thanks to all

JedrzejT

HI,

1 case
Words with X symbol
Filter:
*X*

2 case
Words without X symbol
Filter:
<>*X*

Second one work only on SQL Server option.
We cannot use wildcards (*) with excluding filters (<>) in native databse.

Becka

nope.. i need to filter it from C/AL code..

tinoruijs

record.SETFILTER(field, '*%1*', 'X');

garak

YorRecord.setfilter(YourFieldToFiler,'@*%1*','x'); <- these shows all Records where in YourFieldTofilter is an x (@ <- not case sensitive)

YourRecord.setfilter(YourFieldToFiler,'<>@*%1*','x'); <- all record, without an x

Regards

Becka

okay... I made it..

that's my code: SETFILTER(FieldForFilter,'%1','x*');

thanks