OraFAQ Forum: Reports & Discoverer » How to handle no data found in rdf query- slightly complex requirement

Home » Developer & Programmer » Reports & Discoverer » How to handle no data found in rdf query- slightly complex requirement (11.5.10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to handle no data found in rdf query- slightly complex requirement [message #563592]

Wed, 15 August 2012 11:15

godfather1000
Messages: 13
Registered: July 2012

Junior Member

Gurus - I have a requirement here which I think is a little complex. I have spent a day on it but am unable to get the entire requirement working.

Here is my req - There are 2 columns C1, C2 - both of which capture a different set of values in 2 seperate custom oracle apps forms.

I have a RDF query to get the result set of C1,C2.

When this query does not return any values I need to look in form 2 and handle each value of C1 seperately. I do not know how to achieve this with formula column - since I can perform checks/validations on the data returned by the query using a formula column.

Can some one please advise how to approach this.

thanks in advance

Report message to a moderator

Re: How to handle no data found in rdf query- slightly complex requirement [message #563600 is a reply to message #563592]

Wed, 15 August 2012 15:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm not sure I understood what you are saying. However: "When this query does not return any values" statement made me think that you might try with UNION of 2 SELECT statements: the first one is SELECT you are using now, while the other one would be selecting values from "form 2".

If the above doesn't make much sense, please, explain it once again - screenshot(s) would be fine, to illustrate what you are explaining with words. If you choose to do that, please, don't capture the WHOLE screen (such as desktop, gadgets you might have and stuff) and save files in JPG format.

Report message to a moderator