Querying a view

Igor Zottich

Hi All,

Does anyone know if it is possible to execute a search on a view instead of CS's table?

If yes, could you share a snippet?

Thanks in advance,

B/R

Igor

Find more posts tagged with

Comments

Appu_Nair1

Are you talking about Search as in a saved search or using the search engine or a LR to query tables/views

I don't understand why would querying a view vs a table be a problem.In 971 and below systems if you write a LiveReport select name,subtype from dtree where subtype=0 and execute the LR through a WSAPI LIveReport Object you would get results.If you take that same code and put it in a 10 and upper systems it would work, but OT has changed DTREE from a table to a view this time.

So is your question regarding a non OT view? or something else.If you put debug=2,wanllogs=true,wantlapilogs=true and execute your LR through a WSAPI call you could actually see what LL got at its server level and what it passed off to the DB layer.

I would also think that if the VIEW was permissioned through GRANTS or similar stuff in SQLserver livelink code would not know the difference.

Here are some links to some code that I tested that workd before

https://knowledge.opentext.com/knowledge/cs.dll/39660740/How_to_Run_a_LR_in_Webservices_on_CS10_UPD_11__STRING_PARAM.docx?func=doc.Fetch&nodeid=39660740

https://knowledge.opentext.com/knowledge/cs.dll/39663024/How_to_Run_a_LR_in_Webservices_on_CS10_UPD_11_INTEGER__PARAM_.docx?func=doc.Fetch&nodeid=39663024

A bug that OT corrected kind of what I reported...
https://knowledge.opentext.com/knowledge/cs.dll/39532007/Debugging_How_to_Run_a_LR_in_Webservices_on_9.docx?func=doc.Fetch&nodeid=39532007

Igor Zottich

Hi Appu,First of all, thanks for your feedback.To better explain the need, a customer has built a view in the CS's database that is being used by a custom module for the searches for performance reasons.Now the customer would like to be able to query that same view also via a webservice. Now looking at the search service it seems to me that I can only use CS's indexes and regions, so effectively to be able to query the view the only way seems to be to call a LR passing the where string as an input parameter.I was just wondering if there was a different approach that could have been used.B/RIgorOn Tue, 31 Jan 2017 14:12:29 +0000 "eLink Entry: Content Web Services Forum" wrote:> eLink : Querying a view Querying a view Posted by >Nair, Appu On 01/31/2017 09:10 AM > > Are you talking about Search as in a saved search or using the >search engine or a LR to query tables/views > I don't understand why would querying a view vs a table be a >problem.In 971 and below systems if you write a LiveReport select >name,subtype from dtree where subtype=0 and execute the LR through a >WSAPI LIveReport Object you would get results.If you take that same >code and put it in a 10 and upper systems it would work, but OT has >changed DTREE from a table to a view this time. > So is your question regarding a non OT view? or something else.If >you put debug=2,wanllogs=true,wantlapilogs=true and execute your LR >through a WSAPI call you could actually see what LL got at its server >level and what it passed off to the DB layer. > I would also think that if the VIEW was permissioned through GRANTS >or similar stuff in SQLserver livelink code would not know the >difference. > Here are some links to some code that I tested that workd before > https://knowledge.opentext.com/knowledge/cs.dll/39660740/How_to_Run_a_LR_in_Webservices_on_CS10_UPD_11__STRING_PARAM.docx?func=doc.Fetch&nodeid=39660740 > > https://knowledge.opentext.com/knowledge/cs.dll/39663024/How_to_Run_a_LR_in_Webservices_on_CS10_UPD_11_INTEGER__PARAM_.docx?func=doc.Fetch&nodeid=39663024 > > A bug that OT corrected kind of what I reported...> https://knowledge.opentext.com/knowledge/cs.dll/39532007/Debugging_How_to_Run_a_LR_in_Webservices_on_9.docx?func=doc.Fetch&nodeid=39532007 > > [To post a comment, use the normal reply function] > Topic: Querying a view Forum: Content Web >Services Forum Content Server: Knowledge Center CS16 >

jdonpaul

You could probably try using a LiveReport or a WebReport to query the table. Other than that, if you want to use a web service, you will need to extend the web services to add that functionality. The SDK documentation explains how this can be done. They can be found here:

https://knowledge.opentext.com/knowledge/llisapi.dll/Open/devzone

Hope this helps.

Jerome