web
You’re offline. This is a read only version of the page.
close
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
I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

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

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


  • lematjas Profile Picture
    lematjas 35 on at

    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.

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    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

    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!

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans