Advanced filtering query syntax

(0) Share

Report

Posted on by DELDYN

560

Hi,

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

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

I have the same question (0)

All responses (7)

Answers (1)

Sort by

DELDYN 560 on at

Like (0)

Report
Copy link

Link copied!

Any idea?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,212 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Igor Karmalita 16 on at

Like (0)

Report
Copy link

Link copied!

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")))

Was this reply helpful? Yes No
DELDYN 560 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Waed Ayyad 9,212 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Deldyn,

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

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Igor Karmalita 16 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Martin Dráb 240,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No