Filter at Attribute View Level very limited?

[Former Member]

I have 2 scenarios for filters and it seems neither are possible at attribute level. When I right click on the field that needs filtering, I'm unable to do the following:

1) I can't input multiple filters. For example, I want the data to exclude STAT = TECO and CANC. I use 'list of values' option and write 2 values, but it's nto working. Is there a specific format? Is there a way to have multiple filters?

2) Current date filter. I want only data that is prior to today. When I right click on the date field I want put 'less than or equal" to system-date. Now() doesn't work it seems. Is there any way to do this?

[Former Member · Accepted solution]

Hi Zain

    For your 2nd scenario , you can create a calculated attribute there you can use the now() function.

  For your 1st scenario you can consider variables, input parameters of static values in case your requirement is dynamic.

Thanks

Santosh Varada

[Former Member · Accepted solution]

Hey Varada,

I can create a calculated column using now(), but how can I use that?

For example, table AFKO is order master, it has date field GSTRS. I want only records that are GSTRS < now()?

Can I use a calculated column in the filter? Or any other work around?

Note: For the first scenario it seems I got a put a comma with no spaces.

[former_member212706 · Accepted solution]

Hi,

Create a calculated attribute like

if(daysbetween(now(),DATE("GSTRS")) < 0,1,0)

And then filter this calc.attribute to filter out 0's . Hope this helps

Thanks,

Rajesh.

[Former Member]

Thank you Rajesh and Kulwinder.

My scenario is to find only active WBS. (exclude those that haven't started).

• So I have to check all order's dates, if all orders start in the future the WBS is not active (but even if 1 order has started already then WBS is active)
• The tricky part is, if the WBS is active, I still have to get detailed information for orders that are  scheduled to start.

Basically I want to do what's in the pic below, but it's not possible because the filter only allows values. I need to figure out if the below can be accomplished in Attribute View (without going to analytic, calcualtion views).

[Former Member]

Hi Zain,

For your second scenario----

1. Create one calculated column

IF(DATE<=now(),1,0)

then take a projection on this & filter records for value '1'.

To use multiple values on same field we use list of value STAT =TECO,CANC

Hope this serves your purpose!!!

Thankss

Kulwinder