XDataWebDataset and querystring Filter

Cavalera_Guido · August 5, 2020, 9:13am

Hi i need to 'select' a substring with filter like this :

Format('$filter=(Desc_Art SUB ?? ''%s'')',[Substring]);

How i can do this by filter ?

using XDataWebDataset.Filter what is the difference ?
can i use SQL dilect to select records server side ?

thx

wlandgraf · August 5, 2020, 2:47pm

You can use functions Contains, StartsWith and EndsWith.

For example:

Format('$filter=(Contains(Desc_Art, ''%s'')',[Substring]);