Finance | Project Operations, Human Resources, ...

AOT View Ranges: 'OR' operator in Value

(0) Share

Report

Posted on by DAX Dev

Hello,

I have a simple aot view created. The datasource is InventTrans.

I want to filter it with StatusIssue enum field.

If I have StatusIssue field in Ranges and I type StatusIssue::Sold, the values are filtered correctly.

Now I wanted to add another filter, so I have type StatusIssue::Sold || StatusIssue::Deducted. In this case it does not show anything at all, the view is empty.

How can I do that?

So, actually this what I want to have in View:

select * from InventTrans
    where   InventTrans.StatusIssue == StatusIssue::Sold ||
            InventTrans.StatusIssue == StatusIssue::Deducted;

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi DaxDev,

Have you tried specifying the range value like this - Sold,Deducted ?

You don't need to mention the Enum name. You need the values only

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi DaxDev,

You need to comma to separate value in "or" expression.

Check docs

docs.microsoft.com/.../how-to-create-queries-by-using-the-aot

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei,

Thanks,

How should I do it if I want AND (&&) expression?

For example if I add InventTransOrigin to InventTrans datasource and I want to filter it with

!InventTransType::TransferOrderReceive && !InventTransType::TransferOrderShip

Should I use comma also here?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi DaxDev,

In your case, an InventTrans record can have one StatusReceipt value. So, I am not sure how you will do an 'AND" join. An "AND" join can come into picture if you add another field into the query range.

The "," operator will work for the values you are looking to retrieve.

Was this reply helpful? Yes No
DAX Dev on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan,

I mentioned InventTransOrigin. There I want to use 'AND' for the ReferenceCategory field.

So I will add ReferenceCategory twice in Ranges

Was this reply helpful? Yes No
Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi DAXDev,

You can check if example from docs working.

A..D, !C

Finds A, B, and D.

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi DaxDev,

For InventTransOrigin, can a record have two values for the field InventTransType? You are essentially including InventTransOrigin records where the InventTransType value is not equal to TransferOrderReceive OR not equal to TransferOrderShip.

You don't have an '&&" condition here. The query value should be "!TransferOrderReceive , !TransferOrderShip

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi DaxDev,

As an example, you can check the query SalesTableListPageOpen which has a range on "ReturnStatus" field which can't be Canceled OR Created.

Was this reply helpful? Yes No