Filter Group

Vikas Bhorhari shared this question 6 years ago
Answered

I am creating Filter group with two condition

[Calculated Fields--> Formula Builder--> filter group]

1.Date is equal to "Manual User Entry"(User selecte date-Input from report)

2. Date is Null


When I generate the report query

SELECT "DIM_PERIOD"."PERIOD_DATE"

FROM "DIM_PERIOD"

WHERE (

"DIM_PERIOD"."PERIOD_DATE" = '20170727'

AND "DIM_PERIOD"."PERIOD_DATE" IS NULL

)


Requirement:

I want "OR" in where condition.

How to do it.


Please help us.

Replies (4)

photo
1

Any update on this.

photo
1

Hi Vikas,


When you create a filter group you should have the option to switch the logic of the filter parameters.


663ef1318f4d81a828894bcd0af50221


Does this work for you?


Regards,

Nathan

photo
1

No Nathan,

I know about this filter.


I want "OR" functionality in when we create filter in View[ Calculated Fields--> Formula Builder--> filter group]


Thanks,

Vikas

photo
1

Hi Vikas,


I am a little confused here, the screen-shot was meant to highlight where you can find the or within the filter group creator at the view level:


ef738b7d624fef6581bf3a2c42994b3e


Is this not what you are referring to?


Regards,

Nathan

photo
1

Hi Nathan,


Refer attached doc

mention all steps with SS

Files: Q.docx
photo
1

Any update on this?

photo
1

Hi Vikas,


My apologies, I was out of town for the last few days. The instructions that I provided were for 7.3. It appears that the option to switch this to "OR" logic is not available in 7.2 and 7.1.

In order to achieve this you will need to upgrade. Sorry for the inconvenience here.


Regards,

Nathan

photo
1

Thanks for your information.


Means this feature is available in 7.3.

I am using 7.2 version.


Regards,

Vikas

photo
1

Hi Vikas,


Yes this is available in both 7.3 and 7.3+ (the view editor was slightly upgraded).


I am going to set this to closed, but let me know if you have any other questions.


Regards,

Nathan

photo
1

Thank Nathan.Please close it.

photo
Leave a Comment
 
Attach a file