Look up does not work when i use deleted key word

Hi All,

I am using the following query in the look up for one of my attribute.

select FIRSTNAME + ' ' + LASTNAME from kuaf WHERE TYPE=0 AND DELETED=0 AND NAME NOT IN ('Admin','eLink') AND CONTACT IN ('Analyst','Associate')

But it throws "Invalid Select Statement" when i try to save it and if I remove the deleted=0, it works and shows the output (ofcourse it displays the deleted users also which i want to avoid).

If i run the statement in the livereport, it works properly.

Can any one please advice how shall i include the deleted=0 in my look up query?

Thanks,

Madhuker

Find more posts tagged with

Comments

Appu_Nair

Your query unfortunately contains a column that contains delete

Str.LocateI finds deleted in one of the validvals they are checking(delete)

Hence it is complaining. Ask a DBA how you can column alias that column

So that you are not putting a term that OT thinks is probably a SQLinjection term

From: eLink Entry: Content Server Development Forum [mailto:development@elinkkc.opentext.com]
Sent: Friday, December 17, 2010 3:27 PM
To: eLink Recipient
Subject: Look up does not work when i use deleted key word

Look up does not work when i use deleted key word

Posted by madhuker_kampe@scotiacapital.com (Kampe, Madhuker) On 2010/12/17 16:21

Hi All,

I am using the following query in the look up for one of my attribute.

select FIRSTNAME + ' ' + LASTNAME from kuaf WHERE TYPE=0 AND DELETED=0 AND NAME NOT IN ('Admin','eLink') AND CONTACT IN ('Analyst','Associate')

But it throws "Invalid Select Statement" when i try to save it and if I remove the deleted=0, it works and shows the output (ofcourse it displays the deleted users also which i want to avoid).

If i run the statement in the livereport, it works properly.

Can any one please advice how shall i include the deleted=0 in my look up query?

Thanks,

Madhuker

[To post a comment, use the normal reply function]
Forum:	Content Server Development Forum
Livelink Server:	knowledge-wlweb01

image001.png

Appu_Nair

also as I think more you could search the patch area for a patch that will allow an exception or instead of calling kuaf just create a view with feilds that you need from KUAF but call them differently

Madhuker_Kampe

Dear Appu,

Thanks for this.

As suggested, i have created a view and used this in the look up and got the required results.

Thanks very much for the idea

Regards,

Madhu