wild card in reports?

Hi,Can someone explain how I can use wild cards for inputs into my reports..

Find more posts tagged with

Comments

Message from Anne Callanan via eLinkHelloI use wild cards in most of my reports that request user input. If you are on Oracle SQl then use something similar to the following:where lower(Officelocation) like %1||'%%'orand (upper(b.name) like upper(%1)||'%%')the second example makes the query case insensitive. If there is no input in Parameter Number One then two % signs are compared and therefore (since % is the Oracle wildcard character) all non-null fields fit the selection criteria.Best regardsAnneeLink Discussion: Livelink LiveReports Discussion wrote:>wild card in reports?>Posted by DeloitteAdmin on 02/08/2004 06:37 PM>>Hi,>>Can someone explain how I can use wild cards for inputs into my reports..>>>>[To reply to this thread, use your normal e-mail reply function.]>>============================================================>>Discussion: Livelink LiveReports Discussion>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view>>Livelink Server:>https://knowledge.opentext.com/knowledge/livelink.exe>>> >-- Anne CallananLivelink and Webboard Systems AdministratorIntranet Services TeamLondon Metropolitan University166 - 220 Holloway RoadLondon N7 8DBSwitchboard : 020 7423 0000 Extension: 2389Direct : 020 7314 4325

eLink User

Message from Adams, Gavin <<A HREF="mailto:GAdams@skm.com.au">GAdams@skm.com.au> via eLink

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

We are about to migrate from Oracle to MS-SQL.

Will the same wildcard work with livereports offan MS-SQL database?

Cheers,

Gavin

------------------------------------------------------------

Gavin Adams

Senior Application Services Manager

Sinclair Knight Merz

Ph 2-9928-2517 - gadams@skm.com.au

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, 9 February 2004 9:09 PM
To: eLink Recipient
Subject: Re wild card in reports?

Re wild card in reports?		Posted by eLink on 02/09/2004 05:09 AM
In reply to: wild card in reports?		Posted by DeloitteAdmin on 02/08/2004 06:37 PM

Message from Anne Callanan <a.callanan@londonmet.ac.uk> via eLink

Hello

Iuse wild cards in most of my reports that request user input. If you
are on Oracle SQl then use something similar to the following:

where lower(Officelocation) like %1||'%%'
or
and (upper(b.name) like upper(%1)||'%%')

the second example makes the query case insensitive. If there is no
input in Parameter Number One then two % signs are compared and
therefore (since % is the Oracle wildcard character) all non-null fields
fit the selection criteria.

Best regards
Anne

eLink Discussion: Livelink LiveReports Discussion wrote:

>wild card in reports?
>Posted by DeloitteAdmin on 02/08/2004 06:37 PM
>
>Hi,
>
>Can someone explain how I can use wildcards for inputs into my reports..
>
>
>
>[Toreply to this thread, use your normal e-mail reply function.]
>
>============================================================
>
>Discussion: Livelink LiveReports Discussion
>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view
>
>Livelink Server:
>https://knowledge.opentext.com/knowledge/livelink.exe
>
>
>
>

--
Anne Callanan

Livelink and Webboard Systems Administrator
Intranet Services Team
London Metropolitan University
166 - 220 Holloway Road
London N7 8DB

Switchboard : 020 7423 0000 Extension: 2389
Direct : 020 7314 4325

eLink User

Message from Anne Callanan <<A HREF="mailto:a.callanan@londonmet.ac.uk">a.callanan@londonmet.ac.uk> via eLink

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> Hello

This is a good reference site for migrating from Oracle to MS SQL. Youcan cross reference SQL commands in Oracle with the MS SQL equivalent.

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/oracle.asp

There seems to be an extended set of wildcard characters in MS SQL butthe % sign seems to be common to both sets of SQL. Livelink requiresyou to use 2 % signs for Oracle queries - I would assume the same istrue for MS SQL queries. As far as I know you will need to replace ||(string concatenation characters) with +

Best regards
Anne

Elink Discussion: Livelink LiveReports Discussion wrote:

eLink

RERe wild card in reports? Posted by eLink on 02/09/2004 05:16 PM
In reply to: Rewild card in reports? Posted by eLink on 02/09/200405:09 AM

Message from Adams, Gavin <GAdams@skm.com.au> via eLink

We are about tomigrate from Oracle to MS-SQL.

Will the samewildcard work with livereports offan MS-SQL database?

Cheers,

Gavin

------------------------------------------------------------

Gavin Adams

Senior Application Services Manager

Sinclair KnightMerz

Ph 2-9928-2517- gadams@skm.com.au

From:eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, 9 February 2004 9:09 PM
To: eLink Recipient
Subject: Re wild card in reports?

Rewild card in reports? Postedby eLink on 02/09/2004 05:09 AM
Inreply to: wildcard in reports? Posted by DeloitteAdmin on 02/08/2004 06:37PM

Message from Anne Callanan<a.callanan@londonmet.ac.uk> via eLink

Hello

Iuse wild cards in most of my reports that request user input. If you
are on Oracle SQl then use something similar to the following:

where lower(Officelocation) like %1||'%%'
or
and (upper(b.name) like upper(%1)||'%%')

the second example makes the query case insensitive. If there is no
input in Parameter Number One then two % signs are compared and
therefore (since % is the Oracle wildcard character) all non-nullfields
fit the selection criteria.

Best regards
Anne

eLink Discussion: Livelink LiveReports Discussion wrote:

>wild card in reports?
>Posted by DeloitteAdmin on 02/08/2004 06:37 PM
>
>Hi,
>
>Can someone explain how I can use wildcards for inputs into myreports..
>
>
>
>[Toreply to this thread, use your normal e-mail reply function.]
>
>============================================================
>
>Discussion: Livelink LiveReports Discussion
>https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=view
>
>Livelink Server:
>https://knowledge.opentext.com/knowledge/livelink.exe
>
>
>
>

--
Anne Callanan

Livelink and Webboard Systems Administrator
Intranet Services Team
London Metropolitan University
166 - 220 Holloway Road
London N7 8DB

Switchboard : 020 7423 0000 Extension: 2389
Direct : 020 7314 4325

-- Anne CallananLivelink and Webboard Systems AdministratorIntranet Services TeamLondon Metropolitan University166 - 220 Holloway RoadLondon N7 8DBSwitchboard	: 020 7423 0000 Extension: 2389Direct		: 020 7314 4325