Display Filtered Values

[Former Member]

Hi Friends,

I have a report which is built on Bex Query. Query has got some mandate prompts based on Calmonth and Fiscalyear.

I am using Filter button in my report to display the Bex Query Prompts as shown in the below screen shot

Now, i want to display the selected filter values as text so that the user can know what are the filtered values.

I did some work around but couldn't succeed.

Some how i did manged to display the selected values from the chart component as shown below.

Here i selected the GENERATION company code which is displayed. In the same way i want to display the selected Bex Query Prompt values.

Your Help will be greatly appreciated.

Thanks,

Madhu

[Former Member · Accepted solution]

Hi Madhu,

If you are using Design Studio 1.5 version we have a component called Filter line that displays the Filters applied to the datasource.

Try implementing this component on your application to display the filter values. We could also perform additional filters by clicking on the + button (top left).

Let me know if this solves your problem.

Thanks,

Kavya

[Former Member · Accepted solution]

Hi Kavya,

Thanks and i appreciate your quick response.

But, however its not which i am looking for.

I tried using Filter Line and what i observed is it fetching all the Objects available in the query. But users doesn't really need all those objects for filtering. They got some set of objects for filtering as the screen shot which i posted earlier and this are set in Query itself.

I wonder, is there any way around to get only this Query set filter objects in Filter Line instead of all the available objects.

Regards,

Madhu

[Former Member · Accepted solution]

Hi Madhu,

If you wish not to display all the objects in Filter line menu. you could restrict those using css. Identify which row(s) you want to hide and find their css class and provide the following code:

style= "display: none"

Add this code in a css file & add it to your application as 'Custom CSS'

Thanks,

Kavya

[Former Member]

Hi Dwain,

I didn't try it. I am working a other way round using Filter Panel Component. But i will try the solution you provided.

Thanks for all for your valuable feedback.

Regards,

Madhu

[Former Member]

Thanks to all for your feedback.

@Kavya: I am very new to this tool and started using this tool very recently. Can you please guide me how and where can i find CSS Class.

@D.Chang & Dominik:

Correct me if i am wrong or didn't understand you.

As per your post i should set DS_1 (data source) as source in Text component and should use the var text method. But i need to display filter values as per the Filter Button Selection. In my report i used a Filter Button to provide Filter Objects for the user so they can filter as per requirement. For this Filter Button (as per screen below) i am not using any Data Source (DS_1).

To get this Bex Query prompts i used the method

APPLICATION.openPromptDialog(500, 500);

So i need to display only this selected values.

Regards,

Madhu

[former_member209499]

The Datasource you should use the code on is the Query of which you display the prompts when clicking the button. And CSS classes can be applied as a property on many components. The CSS file itself is specified in the Properties of the application.

Hope it helps!

Best Regards,
Dominik Herrmann

[d_chang]

The Prompt filters are defined in the BEx query.

When you use a Bex query in design studio it will be mapped to DS_1 by default.

If you use the script that we provided you should get a correct result. Did you try it?

just store the value that someone entered in the prompt using the getVariableText() method in a design studio variable (String).

Then use this string to display the filter value, for instance Text_1.setText()

or BUTTON_1.setText()

Regards,

Dwain

[former_member209499]

You can use

DS_1.getVariables().forEach(function(element, index) {

  DS_1.getVariableValueText(element);

});

to read all variables from the Datasource. Then with element you can fetch the texts for all of the variables in the Query and write it somewhere to display it to the User.

Best Regards,

Dominik Herrmann

[d_chang]

You can use the method

var text = DS_1.getVariableValueText("0I_CALMO");

or

var text = DS_1.getVariableValueExt("0I_CALMO");

to store the text value or key in a variable or use it in a Text component