Advanced filtering query syntax

(0) Share

Report

Posted on by DELDYN

304

Hi,

can i do the following range in data entity (InventTransferOrderHeaderEntity) ?

((TransferOrderStatus = /Shipped/) && ((ReceivingAddressLocationId= 1234) || (ShippingAddressLocationId = 1234))

All responses (7)

Answers (1)

Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

Advanced filtering query syntax

The problem about no data returned shouldn't be discussed here anymore. DELDYN created a new thread for it and forgot to mention it here.
Igor Karmalita 16 on at

Like (0)

Report

Advanced filtering query syntax

Hello Deldyn,

I've tried to solve "Extended range failure", i'm not sure about tables fields and ranges you have used here, if Query works now but you see nothing or result is different from you expects, then problem in something else.
Waed Ayyad 6,408 Super User 2024 Season 2 on at

Like (0)

Report

Advanced filtering query syntax

Hi Deldyn,

Did you save view after you changed the query? Can you share the form?

Thanks,

Waed Ayyad
DELDYN 304 on at

Like (0)

Report

Advanced filtering query syntax

Hi Igor,

i've put quotations on shipped, but the question format replaces "" with /

i've added the extra bracket at the end thank you and the error stopped appearing.

((TransferOrderStatus = "Shipped") && ((ReceivingAddressLocationId= "1234") || (ShippingAddressLocationId = "1234")))

However, the range is not working as expected.

i created a new transfer, i've put the ReceivingAddressLocationId as 1234 and the status is shipped.
However, when i export the entity i get nothing

i also tried to replaced shipped with it's integer value but same result (it's not good to put enum integers anyway)

So is to doable via the UI in the first place?
Verified answer

Igor Karmalita 16 on at

Like (0)

Report

Advanced filtering query syntax

Hello Deldyn,

1. Use "Shipped" instead /Shipped/

2. Add aone mode closing bracket ")" in the end

so if you are correct with data types in LocationId's range should looks like this:
((TransferOrderStatus = "Shipped") && ((ReceivingAddressLocationId = 1234) || (ShippingAddressLocationId = 1234)))

But I think ReceivingAddressLocationId and ShippingAddressLocationId it's string, so rather:

((TransferOrderStatus = "Shipped") && ((ReceivingAddressLocationId = "1234") || (ShippingAddressLocationId = "1234")))
Suggested answer

Waed Ayyad 6,408 Super User 2024 Season 2 on at

Like (0)

Report

Advanced filtering query syntax

Hi Deldyn,

1- Replace the TransferOrderStatus with Enum integer that is related to "Shipped" status.
2- ReceivingAddressLocationId is it integer value? or String?

Thanks,

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
DELDYN 304 on at

Like (0)

Report

Advanced filtering query syntax

Any idea?