Search bar functionality in design studio 1.6 SP3

[Former Member]

Hi guys,

I have a requirement of creating a search bar in a dashboard , where the dashboard will have too many icons and when we click on one icon it should navigate to another webi report or crystal report.

So I am facing an issue while creating a search script for icons. Could you please help me in this? I know how to create a search tab for a crosstab but not for the icons.

Thanks for the suggesions.

[TammyPowlas]

When I Google Search Bar for Design Studio - this blog appears http://visualbi.com/blogs/design-studio/design-studio-tips-and-tricks/search-functionality-in-sap-de... - but it doesn't sound like it will meet your needs

[MustafaBensan · Accepted solution]

Hi Neetika,

Based on your explanation, it seems to me that you would like to create a searchable launchpad. You certainly will not be able to achieve this with the standard Design Studio components. However, you could possibly achieve the desired result with Community SDK Components as follows:

1) Ensure the data source query of available reports includes the following fields:

(i) Report Name

(ii) Report OpenDoc ID or URL

(iii) Icon code or icon ID

2) Add the Launchpad component to the application

3) Add the Data Iterator component to the application

4) Add a standard Input Field component for the search box

5) Use the getRows.containing() method of the Data Iterator to return only the data set rows that match the search string obtained from the Input Field

6) Iterate through the filtered data from Step 5 and add report tiles with report name and icon to the Launchpad using the addTile() method

7) Define script code in the "On Tile Select" event of the Launchpad component that executes the corresponding report via an OpenDoc URL reference in the APPLICATION.openNewWindow() method.

Regards,

Mustafa.

[Former Member · Accepted solution]

Thank you for all the help mustafa. 🙂

Regards,

Neetika Singh

[MustafaBensan · Accepted solution]

You're most welcome, Neetika. What direction did you end up deciding on?

[Former Member · Accepted solution]

Hello Mustafa,

sorry for such a quick reply.

I got a work around for it.

Used several cross tabs with one field each and scripted the search bar for each of it. and was working completely fine.

Regards,

Neetika Singh

[TammyPowlas]

Would BI platform search be an option? See https://wiki.scn.sap.com/wiki/display/BOBJ/Platform+Search

[Former Member]

Hi Mustafa,

1) Where is the list of reports associated with the icons coming from? Is a data source query going to return the list of available reports, or are you going to hardcode them in the Design Studio application?

Answer : I am fetching the report names from a field .Yes adatasource query is going to return the list of available reports.

2) "I am displaying icons in the dashboard which will navigate to another report. so there will be multiple icons present" - do you have a screenshot of your current layout with icons that you can share to clarify the requirement further?

Answer :capture.png the blue icons present in the dashboard is what i wanted to filter.

3) You have indicated that you do not want to use a list box. Even with a search box, the results of the search need to be displayed. How do you expect the search results to be displayed? In what type of component if not a list box?

Answer : As you can see in the screenshot there are icons present in the screenshot. So when i say type "1" then only Reports having "1" in them should filter out and should display.

After googling a lot, I have come to this conclusion that I guess it cant be achieved with out binding the icons to a data source. Or a major scripting can resolve this but again I am no coder. But I will be glad if you could tell me for a work around to do this.

Thanks & Regards,

Neetika Singh

[MustafaBensan]

Hi Neetika,

Can you be clearer, perhaps with a mockup, about how you want this icon search functionality to work? Your requirement description is a little vague at the moment.

It sounds like you want to be able to allow the user a way to select from multiple reports to jump to from a Design Studio application. If that's the case why not just use a list box or dropdown list?

Regards,

Mustafa.

[Former Member]

Hi mustafa,

Yes what you have understood is correct but the user wants a search box instead of list box or drop down list.

I am displaying icons in the dashboard which will navigate to another report. so there will be multiple icons present .say starting with letter A. So when user type A in the search box it should filter out all the reports icons containing A in it. This is the requirement.

Which I am not able to find a way for. I ll be glad if you could help.

Thanks,

Neetika

[Former Member]

The script for search box I am using right now to serach a string with in a table is

var Search_Value = INPUTFIELD_1.getValue();

var FilterList = "";

var MemberList = DS_3.getMembers("_AHNsNc-2EeWnlNGmodjH0g",200);

MemberList.forEach(function(element, index) {

if(Convert.indexOf(element.text, Search_Value)!= -1) {

//Appends the key of the element if it matches the user’s search string

FilterList = FilterList + element.externalKey + ";"; }

});

DS_3.setFilterExt("_AHNsNc-2EeWnlNGmodjH0g", FilterList);

if(DS_3.getFilterExt("_AHNsNc-2EeWnlNGmodjH0g")=="")

{

APPLICATION.alert("" + Search_Value + "is not found\nPlease check your search string! (It is case sensitive)");

}

else {

//Enables the ‘clear’ button incase the users want to clear the searched value

BUTTON_1.setVisible(true);

}

But i dont know what changes do i do when i have multiple icons instead of a table.

[MustafaBensan]

Hi Neetika,

Some more questions:

1) Where is the list of reports associated with the icons coming from? Is a data source query going to return the list of available reports, or are you going to hardcode them in the Design Studio application?

2) "I am displaying icons in the dashboard which will navigate to another report. so there will be multiple icons present" - do you have a screenshot of your current layout with icons that you can share to clarify the requirement further?

3) You have indicated that you do not want to use a list box. Even with a search box, the results of the search need to be displayed. How do you expect the search results to be displayed? In what type of component if not a list box?

Regards,

Mustafa.

[Former Member]

Hi Mustafa,

1) Where is the list of reports associated with the icons coming from? Is a data source query going to return the list of available reports, or are you going to hardcode them in the Design Studio application?

Answer : I am fetching the report names from a field .Yes adatasource query is going to return the list of available reports.

2) "I am displaying icons in the dashboard which will navigate to another report. so there will be multiple icons present" - do you have a screenshot of your current layout with icons that you can share to clarify the requirement further?

Answer: capture.png the blue icons present in the dashboard is what i wanted to filter.

3) You have indicated that you do not want to use a list box. Even with a search box, the results of the search need to be displayed. How do you expect the search results to be displayed? In what type of component if not a list box?

Answer : As you can see in the screenshot there are icons present in the screenshot. So when i say type "1" then only Reports having "1" in them should filter out and should display.

After googling a lot, I have come to this conclusion that I guess it cant be achieved with out binding the icons to a data source. Or a major scripting can resolve this but again I am no coder. But I will be glad if you could tell me for a work around to do this.

Thanks & Regards,

Neetika Singh