How to combine filter

(0) Share

Report

Posted on by Neodep

Hi,

I try to combine filter in request

Currently i have this : and the result is that it show me the value in red under the field (N° reference)

        field(500; "Gtin BT"; Text[50])
        {
            TableRelation = "Item Reference"."Item No.";
            FieldClass = FlowField;
            CalcFormula = lookup("Item Reference"."Reference No." where("Item No." = field("Code article")));

I would like to combine F00027 (field "Code article"") with value BT from field (Unité) and the Field (Description) when it contains the value "X" to show the value from the field (N° référence). (in Yellow in this case )

Thanks in advance for your help

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Deekshitha Reddy 219 on at

Like (0)

Report

RE: How to combine filter

1.TableRelation = "Item Reference"."Item No." where("Item No."=filter(='F00027'),

"Unite"=filter(='BT'),"Description"=filter(='X');

-----------------

2.TableRelation = BankDetailsTable.BANKNAME where(BANKNAME = filter(= 'sbi'),

BRANCH = filter(= 'mumbai'));

The second one ,I have used to filter the required values inside fields, such as bankname

& branch. More filters can be added depending on requirement.

Please Let me know.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to combine filter

I did not get your requirement.

Was this reply helpful? Yes No
Neodep 20 on at

Like (1)

Report

RE: How to combine filter

Thanks Reddy, it was simple finally. Thanks for your help.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to combine filter

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

How to combine filter

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates