How to match and show matched values from two different fields?

[adann_CB_96]

I am using a filer pane in which I must show some values.

There are two fields: "A" and "B" with contract ids and I have to do something like inner join between them to check, if a values from "A" field exists in "B" field. If so, such a value will be shown in the filter pane and all other values existing in both fields will be shown too.

Do you know how to do it in an edit expression?

[marcus_sommer]

It shouldn't be done within the UI else in the data-model and might resulting in a single field for the id's and n extra fields with the information if the id is in orders/billing/shipment/whatever ... and/or how many times and/or the date-offsets or ...

There are various approaches possible, for example checks with exists() or aggregation-loads or interrecord-functions like peek() and previous.

[adann_CB_96]

Hi, none of those functions you mentioned exist in a edit expression.

[marcus_sommer]

Like hinted, it shouldn't be done there else within the script to get native fields with the appropriate information.

[marksouzacosta]

Hi @adann_CB_96,

Maybe something like this:

Count({<FieldA=P(FieldB)>} FieldC)

Regards,

Mark Costa