Filtering out ENUM Values in Electronic Reporting

(0) Share

Report

Posted on by HR-05070626-0

Hi i wanted to get only purchased inventory transactions. But as this field is an enum type , so i have a hard time putting in the condition.

i know in X++ we use it like this ,
queryFilter.value(queryValue(StatusReceipt::Purchased));

However , I can’t find out anywhere what is the proper syntax I can use here for filtering my condition

FILTER(InventTrans,
AND(InventTrans.ItemId = @.ItemId,
InventTrans.DatePhysical = TransDate,
InventTrans.StatusReceipt = ‘Purchased’ /// I want this line corrected
)
)

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Filtering out ENUM Values in Electronic Reporting

Hi,

try this to use GetEnumValueByName function.

Please refer to this :

https://fernitudela.dev/2023/07/25/d365fo-base-enums-in-er-electronic-reporting-model-mapping-listoffields-and-getenumvaluebyname-functions/

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No