Skip to main content

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

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'


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

Kind regards,

Julia Bauer


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

Kind regards,

Julia Bauer

Fantastic! Glad to hear!


Reply