Livereport searching for Users Interests.

Hi,I need a livereport for selecting the Users interests on the Profile Page.This is the SQL:select name, FirstName, LastName, OfficeLocation, Contact, interests from kuaf where Interests LIKE %1;The Param%1 is User Input 1.When I'm searching for the interests, I had to enter them in %. For example: %livelink%Is there any other chance to get a report where I do not enter the % in the search field?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try changing the SQL in the LiveReport to:

select name, FirstName, LastName, OfficeLocation, Contact, interests from kuaf where Interests LIKE '%%' || %1 || '%%'

The above is for Oracle-based Livelinks. If your database is Microsoft SQL Server , use:

select name, FirstName, LastName, OfficeLocation, Contact, interests from kuaf where Interests LIKE '%%' + %1 + '%%'

Explanation: the %% combination acts as a wildcard when used in LiveReports. The || symbols represent the concatenation operator for Oracle, whereas the + symbol is the concatenation operator for SQL Server.

Let me know if that helps...

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, May 13, 2008 5:30 AM
To: eLink Recipient
Subject: Livereport searching for Users Interests.

Livereport searching for Users Interests.

Posted by tschulte (Schulte, Thorsten) on 05/13/2008 05:29 AM

Hi,

I need a livereport for selecting the Users interests on the Profile Page.

This is the SQL:
select name, FirstName, LastName, OfficeLocation, Contact, interests from kuaf where Interests LIKE %1;

The Param%1 is User Input 1.

When I'm searching for the interests, I had to enter them in %. For example: %livelink%

Is there any other chance to get a report where I do not enter the % in the search field?

Thorsten Schulte

Great, It works.Thank you very much!Is it also possible to change a report, that it is not case sensitive? For example searching for "opentext" give the same result as "Opentext" ?thorsten.

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Thorsten,If you want to be case independent you can force the column and query tobe either upper or lower case.So where you currently have where Interests LIKE '%%' || %1 || '%%'you could instead use where upper(Interests) LIKE '%%' || upper(%1) || '%%'This makes SQL server / Oracle convert the column data and the userspecified value to the same (upper) case before the comparison is made.Similarly, you could use the function "lower" to convert both sides tolower case.RegardsLindsay-----------------------------Lindsay DaviesPrincipal Product SpecialistOpen Text, Beaconsfield, UK----------------------------------Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 14 May 2008 07:20To: eLink RecipientSubject: Great, It works.Great, It works.Posted by Schulte, Thorsten on 05/14/2008 02:15 AMGreat, It works.Thank you very much!Is it also possible to change a report, that it is not case sensitive? For example searching for "opentext" give the same result as "Opentext"?thorsten.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Livereport searching for Users Interests.https://knowledge.opentext.com/knowledge/llisapi.dll/open/14534015Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/llisapi.dll/open/Livelink_LiveReports_DiscussionLivelink Server:https://knowledge.opentext.com/knowledge/llisapi.dllTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.