Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Electronic reporting f...
Finance forum

Electronic reporting framework: multiple conditions

(0) ShareShare
ReportReport
Posted on by lematjas 35

Hi All,

Is it possible to use multiple conditions with the function: FILTER or WHERE? 
In my scenario I want to check if the startdate is greater than x and enddate lower than y or enddate = maxvalue

table.Startdate >= x and (table.enddate < y OR table.enddate = maxvalue) ==> for what i've found on the internet there is only one condition possible in the where clausule but I find it hard to believe that it's not possible for multiple conditions on a datasource within the electronic reporting framework.

thanks in advance

kind regards

Matthias

Categories:
Development / Customization / SDK
  • lematjas Profile Picture
    lematjas 35 on at
    RE: Electronic reporting framework: multiple conditions

    Aha, that makes sense. I was thinking sql like.

    But indeed these functions in ERF require parameters.

    Gonna try it on monday. And come back to you! Have a nice weekend!

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Electronic reporting framework: multiple conditions

    AND is a function, it accepts parameters. If you spend some time you may notice the difference between "OR (table.enddate < y, table.enddate = maxvalue)"  and "(table.enddate < y OR table.enddate = maxvalue)"

  • lematjas Profile Picture
    lematjas 35 on at
    RE: Electronic reporting framework: multiple conditions

    Well that doesn't seem to 'compile' in the formula designer.

    if my formula is like:

    FILTER(mytable,

    mytable.startdate >= x)    this gives no problems.

    if I try to use the AND :

    FILTER(mytable,

    mytable.startdate >= x AND mytable.enddate < y)  this fails and gives an error, but the error itself is not explaining anything.

    I wonder, what is the correct syntax to use the AND/OR with the FILTER function. as i've been trying multiple formats.

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Electronic reporting framework: multiple conditions

    Use AND (condition 1[, condition 2, …]) and OR (condition 1[, condition 2, …])  like:

    AND (table.Startdate >= x, OR (table.enddate < y, table.enddate = maxvalue))


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,145 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,917 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans