Skip to main content
Solved

Filter with augmented attributes?

  • May 21, 2024
  • 3 replies
  • 28 views
julia.bauer
Level 9
Forum|alt.badge.img+1

Hello everyone,

 

I'm currently building a worklist with two tabs (Open and Done). I have created an augmented attribute named STATUS which is either NEW (default value) or DONE (will appear in the DONE tab also). Accordingly, I now want to set a filter in the table of the Open Tab to filter out already processed data rows:

 

FILTER "MARC_AUGMENTED_status"."VALUE"='NEW';

 

This is only a simple filter, however after publishing the filter, the table shows no existing data rows anymore.

 

How is this possible?

 

Does anyone have an idea?

 

Thanks so much!

 

BR

Julia Bauer

Best answer by matt.witty13

It's a weird interaction but it is because the augmented table does not exist in your data model. It's only in the front end. If you look at the augmented attribute PQL, it's a PU_FIRST of a bunch of different things. So you might have to do a:

 

FILTER PU_FIRST([formula]) = 'NEW'

    3 replies

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • 123 replies
    • Answer
    • May 21, 2024

    It's a weird interaction but it is because the augmented table does not exist in your data model. It's only in the front end. If you look at the augmented attribute PQL, it's a PU_FIRST of a bunch of different things. So you might have to do a:

     

    FILTER PU_FIRST([formula]) = 'NEW'

    julia.bauer
    Level 9
    Forum|alt.badge.img+1
    • julia.bauer
    • Author
    • Level 9
    • 58 replies
    • May 23, 2024

    Hello @matt.witty13 - thanks so much, this worked exactly the way I wanted it to :-)

    Kind regards,

    Julia Bauer

    matt.witty13
    Level 10
    • matt.witty13
    • Level 10
    • 123 replies
    • May 23, 2024

    Hello @matt.witty13 - thanks so much, this worked exactly the way I wanted it to :-)

    Kind regards,

    Julia Bauer

    Fantastic! Glad to hear!


    Community Code of ConductAccessibility statement