Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-12-27T15:18:42Z by TSliva
TSliva
TSliva
34 Posts
ACCEPTED ANSWER

Pinned topic Help with query

‏2012-12-27T15:16:00Z |
Hi All,

I'm trying to do the following:

1 - pull in only three types of SERVICES
2 - query against those three SERVICES to check
if SERVICE is either 'serviceA' or 'serviceB' then
display only those records where REFERRED_TO REFERRED_FROM
else display the record regardless end

I've been trying to get this since yesterday without luck.

Query1].[Service] in ('Lending Pipeline (Referrals)','Deposit Pipeline (Referrals)','Third Party Services (Referrals)')


filters the three services I need but after that I'm not making any progress. I've tried nested IF statements and CASE statements but I'm missing something in the syntax I guess.

Any help greatly appreciated.

Terry
Updated on 2014-03-25T07:43:49Z at 2014-03-25T07:43:49Z by iron-man
  • TSliva
    TSliva
    34 Posts
    ACCEPTED ANSWER

    Re: Help with query

    ‏2012-12-27T15:18:42Z  in response to TSliva
    sorry, forgot to add the not equal to:

    REFERRED_TO REFERRED_FROM