ENUM Dynamic attribute in Intelligence returns all data when 'Select' is passed instead of enum values.I want the report to show no data when the enum value is not passed. anyone has any idea
select distinct ep.endpointname as Application,..otherfields,from ( select ev.customproperty9 , ev.CustomProperty10 from entitlement_values ev where ev.customproperty6 like concat('%', '${SelectClass}','%') ) as evleft join entitlement_types et on ...
select distinct ep.endpointname as Application,..otherfields,from ( select ev.customproperty9 , ev.CustomProperty10 from entitlement_values ev where ev.customproperty6 like concat('%', '${SelectClass}','%') ) as evleft join entitlement_types et on ...
Hi Rushikesh thanks for getting back to me.the issue is when I don't select any Enum value, it is dumping all of the data from the query. if I don't select any Enum value, it shouldn't display any data. I could not upload the screenshotthanksAmanuel
