AND condition for filter in DataFlow doesn't work

DM9346
DM9346 Member Posts: 7
in ION

Hi All,

I have a dataflow wherein I have a filter node however, the AND condition doesn't work. If I use the OR it does work but never the AND condition.

Has anybody experienced this?

Answers

  • Prabodha Amarapema
    Prabodha Amarapema Member, Infor Partner Posts: 25

    No, AND filter should work, make sure your attributes mappings and conditions are correct

  • DM9346
    DM9346 Member Posts: 7
    https://community.developer.infor.com/discussion/comment/560#Comment_560

    Mappings and conditions are correct but it still doesn't work. I tested with OR and that one works.

  • Prabodha Amarapema
    Prabodha Amarapema Member, Infor Partner Posts: 25

    Can you share a screenshot of the condition

  • Aaron Roma
    Aaron Roma Member Posts: 4

    Use AND in filters all the time and have never had an issue. As Prabodha mentioned, if you can share a screenshot, we may be able to help out. Just to be sure the basics are covered, you have selected the combined condition in the "Used Condition" field, yes?

  • Kevin Heiman
    Kevin Heiman Member, Staff Posts: 15

    For reference this section covers filters in flows with a fair amount of detail and considerations as well as a "Combined condition" section with examples. Check the data has content, if your are using attributes that you are filtering to the correct attribute.

    You can also see the filter step in OneView and see the comparison used.
    As others have noted, more specifics would help to narrow in on what steps you need to consider.
    Filter Routing has worked well in the scenarios I have created.

  • DM9346
    DM9346 Member Posts: 7

    Here's the XML from that day.

    image.png

    Here's how I get the attributes. Note that these 2 are now separated since I asked this question as it was not working.

    image.png
    image.png

    This is the one that passes when I use OR condition.

    image.png

    This is the AND condition that doesn't pass

    image.png

  • Carsten Steinhoefel
    Carsten Steinhoefel Member, Staff Posts: 18

    You have probably already tried this but does the filter pass "Level1Hierarchy EQUALS 'C'"? It looks like it should but that's what has not been tested by the OR condition above.

  • DM9346
    DM9346 Member Posts: 7
    edited November 18
    https://community.developer.infor.com/discussion/comment/623#Comment_623

    By extension yes. Right now I changed it to a routing then filter and the C condition routing is working then the filter is with regards to 2800 or 2801.

  • Carsten Steinhoefel
    Carsten Steinhoefel Member, Staff Posts: 18

    I have set up a similar condition and it is working for me. However I could not get the filter to look exactly like yours. I have always got the simple OR branch first independent of the order I defined them in:

    image.png

    In my case the BOD has ItemType='Purchased' and ItemGroup='P30010'.

    I would test once with the simple Hierarchy = 'C' filter just to make sure it passes. Then I'd delete and re-add the combined conditions and test again.

  • DM9346
    DM9346 Member Posts: 7
    https://community.developer.infor.com/discussion/comment/625#Comment_625

    Thank you very much. This is how I did it before(I briefly recreated it). This results in the condition in my comment above.

    image.png

Categories