CODEWITHSUNDEEP
dynamics-nav
Jonathan Lam
Jonathan Lam

Reputation: 1330

SETFILTER w WildCards Not Working as Expected

I have been trying to get Setfilter with wildcards working properly but i don't know why it isnt.

SETFILTER(Description,'*@%1*',"Assembly Header"."No.");

The filter does not work and does not display anything, probably because NAV is not interpreting %1 well

Upvotes: 1

Views: 3781

Answers (3)

ghuebner
ghuebner

Reputation: 1

The only solution working for me in NAV 2018 was that of azatoth:

'*@....' not working

'@*....' working

Upvotes: 0

azatoth
azatoth

Reputation: 705

because it's working the other way around:

SETFILTER(Description,'%1','@*' + FORMAT(Assembly Header"."No.") + '*');

so [at][star]{search term}[star]

In NAV 2013R2 it's actually gave you an error message for '*@'

Cheers!

Upvotes: 0

Jonathan Lam
Jonathan Lam

Reputation: 1330

Found a solution, it is always better to make use of STRSUBSTNO function for wild cards concatenation

So, it do works fine

SETFILTER(Description,STRSUBSTNO('*@%1*',"Assembly Header"."No.");

:)

Upvotes: 1

Related Questions