Small and medium business | Business Central, N...

NOT EQUALS IN A FILTER

(0) Share

Report

Posted on by Mohamed Ali ELLOUZE

addafter(" ")

{

part("Produit"; "Produit")

{

ApplicationArea = all;

SubPageView = where(Produit = filter(false));

SubPageLink = "No." = Field(Ref);

Caption = 'Produit équivalent';

}

The No filter here is equals to Field(Ref), but i want all item not equals to field(Ref). I'm trying this one --> SubPageLink ="No." = FILTER (<>Field(Ref));

Which is not correct.

Thanks for your propositions

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Hi,

the correct syntax is as follows:

SubPageLink ="No." = FILTER (<>Ref);

but when you are using FILTER, you can not use any variable with it, instead it requires a hardcoded values with <> operator.

In either way you can extend your open page trigger of sub page with the Header page values.

Thanks.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

As Nitin mentioned, You can only use <> in Filter.

If your needs are more complex, you can refer to Item Attributes Factbox (9110, ListPart), this Factbox is not associated with SubPageLink.

Hopefully the link below can give you some hints.

https://yzhums.com/25011/

Thanks.

ZHU

Was this reply helpful? Yes No
Mohamed Ali ELLOUZE 5 on at

Like (1)

Report

Hi,

Thanks for your request, I m testing with a variable named recNo = value of ref field, then i use

"No." = FILTER(<> recNo)

But the problem still exists

The problem is resolved when i make "No." = FILTER(<> '21174')

There no way to have a variable ?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

The filter value have to be a text so you should try use the use this command to format your filter value correctly when you have a variable that you want to be part of the filter

something like FILTER =(STRSUBSTRNO('<>%1,recN);

It can be smart to check the filter value in the debugger or in a message so you see that it is formatted correctly.

docs.microsoft.com/.../text-strsubstno-method

Was this reply helpful? Yes No
Mohamed Ali ELLOUZE 5 on at

Like (0)

Report

I'm trying this one:

"No." = FILTER(StrSubstNo('<> %1', recNo) )

Then I declared a new Text var :

myText := StrSubstNo('<>%1', recNo);

And i do like this :

"No." = FILTER(myText) --> always wrong

although when i check the myText value in a message it's OK -->

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

I think you set your filter incorrectlty.

You should say rec.setfilter("No.",myText);

SETFILTER Function (Record) - Dynamics NAV | Microsoft Docs

Was this reply helpful? Yes No
Mohamed Ali ELLOUZE 5 on at

Like (0)

Report

I can't do setfilter in this context, i would like to do this filter in the subpagelink.

Was this reply helpful? Yes No