Skip to main content
Question

FILTER out Cases with condition

  • December 18, 2020
  • 4 replies
  • 3 views
steven.bernd
Level 6
Forum|alt.badge.img+1

Hi everyone,

i hope you can help me with a FILTER function.

image716234 8.28 KB

I need a FILTER function with PU_LAST that deletes my cases (in this case it is 98068) when the last activity of Vorgangsart_gend. in column Wert Neu is like /RWEE/DGF.

Can you help?

4 replies

D
Level 1
Forum|alt.badge.img+2
Hi Steven, the following PU_LAST will return the Wert Neu value of the last Vorgangsart_gend activity for each case. In the FILTER statement, you can then compare against this value to filter cases: FILTER PU_LAST("CaseTable", "ActivityTable"."Wert Neu", "ActivityTable"."Activity" = 'Vorgangsart_gend') != '/RWEE/DGF'; Best David
steven.bernd
Level 6
Forum|alt.badge.img+1
  • steven.bernd
  • Author
  • Level 6
  • December 21, 2020
super. it works. thx
steven.bernd
Level 6
Forum|alt.badge.img+1
  • steven.bernd
  • Author
  • Level 6
  • January 7, 2021

Thanks again. But I have noticed that the formula does not work 100% yet.

Cases without the activity Vorgangsart_gend. are not even considered with this formula. These are sorted out.

In principle, I would like to see these cases and check your formula about them.

The problem is

PU_LAST ("/ XFT / INV_Q", T_CEL_AT_ACCOUNTS_PAYABLE. VALUE_NEW, T_CEL_AT_ACCOUNTS_PAYABLE. TEXT = Vorgangsart_gend.)

There are also cases without Vorgangsart_gend..

These should also be counted.

Hope you can help.

Greetings.

D
Level 1
Forum|alt.badge.img+2

Hi,

in order to also filter on the Cases without this particular activity, you can add this condition with an OR. Checking if an activity is contained in a Case can be done in many different ways, but the easiest one is probably using PROCESS NOT EQUALS:

FILTER PROCESS NOT EQUALS 'Vorgangsart_gend' OR PU_LAST("CaseTable", "ActivityTable"."Wert Neu", "ActivityTable"."Activity" = 'Vorgangsart_gend') != '/RWEE/DGF';

Cheers

David

Community Code of ConductAccessibility statement