nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

search by node name

Tunca_Usluer

Hello,

How can I search by a node name with web service API?

I want to search all folders thats name like

'Diger'

How is it possible?

Find more posts tagged with

Comments

Rakesh_Kumar_Jalla

starting with CS 10 update 9, there is a new WS call RunReport, using which you can execute live report.

If you requirement is as simple as get all folders whose name is like ‘Diger’, you can just create a live report with an sql query and call it.

Thanks,

Rakesh.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 2:58 PM
To: eLink Recipient
Subject: search by node name

search by node name

Posted bytunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 05:25 AM

Hello,

How can I search by a node name with web service API?

I want to search all folders thats name like

'Diger'

How is it possible?

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Tunca_Usluer

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

Rakesh_Kumar_Jalla

We can also send parameters to sql query also. In the live report you have placeholders like %1, %2 and while making a call to live report you would send the values to be inserted within these placeholders. But you need to be careful about permissions because it is difficult to validate permissions using a sql query.

For your search related query, I will let the search gurus answer it.

Thanks,

Rakesh.

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 5:28 PM
To: eLink Recipient
Subject: RE search by node name

RE search by node name

Posted bytunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 07:57 AM

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

eLink User

if you know are open to livelink search it can be called from code as well.It will always be /llisapi.dll?func=search .I usually practice my search query by creating stand alone forms and then when I get what I am looking for I put them in a piece of code.Note I am talking about searching using livelink search(REST) and not the search services api which we have been advised not to pursue to greater extent by OT.In this forum the search api is well documented and replete with almost every example you can think of.

LR's as Rakesh says will also work and will be easier but require a higher livelink server that has the server side code..I have posted samples as well as a couple of others have samples as well.

..Appu

I wonder how one could debug livelink if Fiddler, Wireshark and Softerra LDAP browser was not invented and not free

On Fri, Sep 12, 2014 at 7:03 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

RE RE search by node name Posted byrjalla@opentext.com (Jalla, Rakesh Kumar)On 09/12/2014 08:03 AM

We can also send parameters to sql query also. In the live report you have placeholders like %1, %2 and while making a call to live report you would send the values to be inserted within these placeholders. But you need to be careful about permissions because it is difficult to validate permissions using a sql query. For your search related query, I will let the search gurus answer it. Thanks,Rakesh. From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 5:28 PM
To: eLink Recipient
Subject: RE search by node name

RE search by node name

Posted bytunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 07:57 AM

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Praveen_Nagarajan

Hello Rakesh,

When a LiveReport is executed from a Web Service does it return more than one record? I may be wrong but I heard from a fried that only one record is returned when a LR is executed from a Web Service. If so, when a LIKE parameter is used in SQL query chances are it will return multiple records. I look forward to your response. Thanks!

Best Regards

Praveen Nagarajan

Analyst
Information Technology
Enterprise Solutions - Content Management - Livelink
Praveen.Nagarajan@P66.com

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 7:04 AM
To: eLink Recipient
Subject: [EXTERNAL]RE RE search by node name

RE RE search by node name

Posted by rjalla@opentext.com (Jalla, Rakesh Kumar) On 09/12/2014 08:03 AM

For your search related query, I will let the search gurus answer it.

Thanks,

Rakesh.

RE search by node name

Posted by tunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 07:57 AM

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

Steve Brezina

Hi Tunca,

A query like this will find all Folders (subtype 0) with name values containing the token "diger":

?func=search&where1="OTName":"diger"&where2="OTSubType":0&boolean2=and

If needed, the query could be changed to test specific metadata language values of OTName or use regular expressions on the value.
I suggest reading the Search API documentation: https://knowledge.opentext.com/knowledge/piroot/llessrc/v100500-1406/llessrc-pgd/docovw.xml

In CS 10.5.0 the OTName region is aggressively tokenized by default, making queries against it behave similar to the SQL "like" keyword.

Regards,

Steve

Praveen_Nagarajan

Hello Rakesh,

I would like to correct my previous response. There is no bug surrounding LiveReport. It was related to LiveReport extensions I believe there should be a patch for it by now. My apology for incorrect response.

Best Regards

Praveen Nagarajan

Analyst
Information Technology
Enterprise Solutions - Content Management - Livelink
Praveen.Nagarajan@P66.com

ossie.moore@capspire.com

The one record only was related to a bug fixed in a patch. Specifically, the LiveReport extensions module broke the ability of WebServices to invoke a LiveReport that returned more than one (or sometimes a few) records. However, a patch was released to fix the issue.

Ossie

On Sep 12, 2014, at 9:14 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

eLink : RE RE RE search by node name
RE RE RE search by node name Posted bypraveen.nagarajan@p66.com (Nagarajan, Praveen)On 09/12/2014 10:13 AM

Hello Rakesh, When a LiveReport is executed from a Web Service does it return more than one record? I may be wrong but I heard from a fried that only one record is returned when a LR is executed from a Web Service. If so, when a LIKE parameter is used in SQL query chances are it will return multiple records. I look forward to your response. Thanks! Best Regards Praveen NagarajanAnalyst
Information Technology
Enterprise Solutions - Content Management - Livelink
Praveen.Nagarajan@P66.com From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 7:04 AM
To: eLink Recipient
Subject: [EXTERNAL]RE RE search by node name

RE RE search by node name

Posted by rjalla@opentext.com (Jalla, Rakesh Kumar) On 09/12/2014 08:03 AM

For your search related query, I will let the search gurus answer it.

Thanks,

Rakesh.

RE search by node name

Posted by tunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 07:57 AM

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

ossie.moore@capspire.com

Ossie

On Sep 12, 2014, at 9:14 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

eLink : RE RE RE search by node name
RE RE RE search by node name Posted bypraveen.nagarajan@p66.com (Nagarajan, Praveen)On 09/12/2014 10:13 AM

Hello Rakesh, When a LiveReport is executed from a Web Service does it return more than one record? I may be wrong but I heard from a fried that only one record is returned when a LR is executed from a Web Service. If so, when a LIKE parameter is used in SQL query chances are it will return multiple records. I look forward to your response. Thanks! Best Regards Praveen NagarajanAnalyst
Information Technology
Enterprise Solutions - Content Management - Livelink
Praveen.Nagarajan@P66.com From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, September 12, 2014 7:04 AM
To: eLink Recipient
Subject: [EXTERNAL]RE RE search by node name

RE RE search by node name

Posted by rjalla@opentext.com (Jalla, Rakesh Kumar) On 09/12/2014 08:03 AM

For your search related query, I will let the search gurus answer it.

Thanks,

Rakesh.

RE search by node name

Posted by tunca.usluer@fibabanka.com.tr (Usluer, Tunca) On 09/12/2014 07:57 AM

well I had problems with sql query indeed. I do not know what keywords I should use?

Basically this is what I am looking for.

func=search&where1=folderName like 'Diger'

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center

[To post a comment, use the normal reply function]
Topic:	search by node name
Forum:	Content Server Development Forum
Content Server:	Knowledge Center