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

All responses (3)

Answers (1)

Neodep 20 on at

Like (1)

Report

RE: How to combine filter

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

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to combine filter

I did not get your requirement.
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.