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)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

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 100,659 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

IB-29041624-0 1,187 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

IB-29041624-0 1,187 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No