How do I use a LIKE statement with a User Input?

I'd like to search the dtree.dcomment field with a user defined string. But I cannot figure out the correct syntax (if possible) for something like:dtree.dcomment LIKE '%%1%'

Find more posts tagged with

Comments

James_Schardt_(LMGTUser1_(Delete)_2167537)

I think I should be able to help with this one.You have to use the concatenation operators. It should like something like this:select name from testwhere dept LIKE '%%'||%1||'%%'Hope this helps!

Babatunde_Akinniyi

If you want to search for a string in the value of an attribute. For an example, to exclude all users that have been deleted from result set. Since this users usually have their login as: loginname(Delete). You can use the following syntax: ...where d.name not like '%%'Delete'%%'...

David_Spirhanzl

Message from David Spirhanzl <David.Spirhanzl@syconix.cz> via eLink

eLink

Or maybe you're asking how to combine %1 with % wildcard in LIKEclause?

I'm used to contruct the query like

select * from KUAF where NAME like %1 || '%%'

for ORACLE DB server.

Where Parameter %1 is User Input 1.

The above query with user input of 'eL' returns e.g. eLink user asone of the results.

From: eLink Discussion: Livelink LiveReportsDiscussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, June 23, 2009 7:19 PM
To: eLink Recipient
Subject: Just to add in

Just to add in		Posted by takinniy (Akinniyi, Babatunde) on 2009/06/23 13:17
In reply to: RE- How do I use a LIKE statement with a User Input?		Posted by LMGTUser1 (Delete) 2167537 (Schardt, James A) on 2000/03/28 15:10

[To reply to this thread, use your normal E-mail reply function.]
Topic:	How do I use a LIKE statement with a User Input?
Discussion:	Livelink LiveReports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Frewini_Atakiti

The above explained like with userinput works well for live report. When I try to use such a livereport as the source of a web report , it does not return any results. Any help is appreciated.Thanks,Sunu

Greg_Petti

Message from Greg Petti <gpetti@resonatekt.com> via eLink

eLink

Hi,

This should work the same with a WebReport so you may have aproblem of some sort. Can you share which WebReports version and Livelinkversion you have? Maybe you could post this in the WebReports discussion: OpenText WebReports Discussion

Greg Petti

From: eLink Discussion:Open Text Live Reports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: December 30, 2009 4:11 PM
To: eLink Recipient
Subject: The above explained like with userinput works well for livereport. When I try...

The above explained like with userinput works well for live report. When I try...		Posted by eu0023014 (Atakilti, Frewini) on 2009/12/30 18:08
In reply to: RE Just to add in		Posted by david.spirhanzl@syconix.cz (Spirhanzl, David) on 2009/06/23 14:05

[To reply to this thread, use your normal E-mail reply function.]
Topic:	How do I use a LIKE statement with a User Input?
Discussion:	Open Text Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.