New Topic

Community Topic Question Report Builder

Nathan Schroeder

NA Business Team

Assigned

Category Report Builder

Product Version 7.2

Filter Group

Vikas Bhorhari shared this question 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.

The same question

Replies (4)

Vikas Bhorhari ●

Any update on this.

Reply URL

Nathan Schroeder ●

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

Reply URL

Vikas Bhorhari ●

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

Files:

Reply URL

Nathan Schroeder ●

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

Reply URL

Vikas Bhorhari ●

Hi Nathan,

Refer attached doc

mention all steps with SS

Files:

URL

Vikas Bhorhari ●

Any update on this?

URL

Nathan Schroeder ●

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

URL

Vikas Bhorhari ●

Thanks for your information.

Means this feature is available in 7.3.

I am using 7.2 version.

Regards,

Vikas

URL

Nathan Schroeder ●

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

URL

Vikas Bhorhari ●

Thank Nathan.Please close it.

URL