Filter data on button click

[Anonymous]

Hi All,

I have chart which contains jobname and Execution_status .

I want to show jobnames whose  Execution_status ='E' by button Click .

I tried button action and set  a variable with expression Only({<Execution_status={'E'}>}Jobname)

But i didn't get desired result .please clarify me where i am wrong .

Thanks

[sunny_talwar]

Is this used a straight table expression? or as a dimension  or in a text box? We would need more information to resolve this.

[sunny_talwar]

See if the attached sample make sense

[Mark_Little]

Hi,

I think you where half way there, with the actions choose select in field.

Field = Execution_status

Search string = 'E'

Mark

[Anonymous]

Hi sunny ,

I used the expression in Button under action-> Variable ->Only({<Execution_status={'E'}>}Jobname)

[sunny_talwar]

So you are trying to make a selection on all the job names where Executive_Status is E? Then why not do what Mark said have a select in field in Execution_status where it equals E?

[Anonymous]

Yes ! i have  already tried it but it is not working

[sunny_talwar]

Would you be able to share a sample where it isn't working?

[jonas_rezende]

Hi, rgv rand.

Utilize the button according to the image below.

Verify if the data of Execution_Status contain space, case afirmmative use trim(Execution_Status) function in script, after reload.

Hope this helps!

[sunny_talwar · Accepted solution]

I think just E (without single quotes and equal sign should do the same thing)