Creating dynamic search which searches within Business Workspace

J Brown · 2021-10-05T23:11:01+00:00

There was an error rendering this rich post.

We have a requirement where within a Connected Workspace Business Workspace there should be a "saved search" which returns documents (only) stored in that specific workspace. Obviously we can do a * search in the Business Workspace and then filter for documents, but I'm thinking about a tab within the Smart UI perspective applied to the Business Workspace "Search" which dynamically passes the object ID of the current workspace to either a saved search query, or a webreport search, that runs and displays the search results within that tab.

The new Smart UI widget "Search Query Results" is ideal, as it displays within the widget the search results output from the search query used in the widget. Now I need it to do this dynamically and grab the Object ID from the workspace, run the same query and return search results in the widget.

We've discussed other methods like triggering a new search query to be created in any new Business Workspace that is created, but this is clunky and if the search changed, we have no easy way to update the 50,000 or more search queries that would be the end result. It doesn't appear you can do a LQL query that searches "From here" as you can do in the GUI search.

Has anyone done a similar customisation?

Find more posts tagged with

Comments

Appu Nair

@Jeff_Brown

I recently accomplished this with an HTML Content Intelligence Widget and here is its mechanism. I got all the things needed for it from WR forums(Old and New). Should be very easy to create on your own.

Create a WR whose only "Role" is to pass "csuiContainerID" getting passed from a SmartUI widget to a real WR that will actually do the work. This is because unlike an LR my experiments and knowledge with it I couldn't get it to call the search query and pass the container id in one shot(Setup Docs https://forums.opentext.com/forums/support/discussion/308688/smartui-workspace-perspective-using-wr-html-ci-widget#latest)
You will create a "Complex Query" search because WR cannot understand parameters in a GUI-based query.

I create a "Complex Query" with a location (csUICOntainerID/LL_REPTAG_WIDGETCONTAINERID)and the Cat: Att I want to search and test it to my heart's satisfaction. I duplicate it replacing the hard codes with replacement params(%1,%2 )etc and create a WR with it as its source. Now I test it to my heart's content. When the SmartUI CI WR runs it passes the container to the launcher, who passes that as a parameter to the runner, and livelink search will take care of the rest. Note as another poster in the other forum said if you were using an LR-based WR you don't need the launcher.

Screencap of implementation :)Perhaps I should do this in my Blog http://livelink.in/ so more people could run off with these quick wins.

PS: Full acknowledgment of my dear mate @PramodMohandas for the excellent help he gave me to get the Google Maps API laden with a Category Attribute in case anyone was wondering what the Map tab does:) and countless postings by @Ian_Whitfield @Nizar_Ghazal

Update:I did this on 16.2.11 so I have not used the new search widget perhaps it is easier than what I have done. I will update if I get to do this on the new 20 versions without some circus.

J Brown

Wow Appu that is excellent feedback on how to accomplish this. As always, much appreciated!

David Henshaw

Hey Appu - question if you ever have had need or thought about this.....

Do you know whether the same can be done with Virtual Folders, such that you can define a VF that is added to a Connected Workspace template, but the VF definition then draws in one or more attributes from the instance of the workspace.

Example - workspace for a work order, category contains the asset IDs in the work order, work order workspace template then contains a VF that looks for all documents matching the asset IDs associated with the instance of the workspace.....

Appu Nair

@Henshaw_David One aspect of the VF that is difficult to do is in a template there is not a way for us to define a Location Dynamically. At customer sites, I have used answer modules and other Oscript hacks to define the location dynamically but at its heart as soon as you add a VF one of the parameters for it is to say where the Location is. I do not know if OT has made the VF Location hardcoded as before or whether it can be figured out basing some parameters now, but when time permits will try your idea. I have only now kind of understood the smart view hullabaloo and I was very late to the party so when something even works tends to get overjoyed :)

Greg Griffiths

If you can convert your search into a GET/POST request, then you can use either the csuiContainerID, the URL value, the value in the JS Objects etc as appropriate to get the value you need to then call your search in a two hop approach. I've also not been able to get it working in a one shot approach - have a few FR's in progress of being raised with OT for this too.