Advanced filtering query syntax

(0) Share

Report

Posted on by DELDYN

458

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)

DELDYN 458 on at

Like (0)

Report

Advanced filtering query syntax

Any idea?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,023 Super User 2025 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

Was this reply helpful? Yes No
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")))

Was this reply helpful? Yes No
DELDYN 458 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?

Was this reply helpful? Yes No
Waed Ayyad 9,023 Super User 2025 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
Martin Dráb 237,679 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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Advanced filtering query syntax

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Advanced filtering query syntax

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates