Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Filtering out ENUM Values in Electronic Reporting

Posted on by 10

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

  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 8,080 User Group Leader on at
    Filtering out ENUM Values in Electronic Reporting
    Hi,
     
    try this to use GetEnumValueByName function.
     
    Please refer to this :
     
     
    Best regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans