One Star

Why tOracleRow filter the rows?

Hello,
I want to make an sql to a table in order to look up for a date if exist, and if does not exist, show a null but i dont want to filter the row if the query doesn't gives a result
My sql is
select 'YES' as RESULT from table where fieldA > '50'
Thanks
4 REPLIES
Seventeen Stars

Re: Why tOracleRow filter the rows?

I would select the amount of datasets.
select count(1) as count_ds from table where fieldA > '50'

This query returns always as value and you can filter for 0 or greater 0.
One Star

Re: Why tOracleRow filter the rows?

So it isnt possible to change the filtering
Seventeen Stars

Re: Why tOracleRow filter the rows?

the component tOracleRow does not filter at all. I guess you are working with the component tParseRecordset? This component returns as much output rows as the result set of the query have rows.
Moderator

Re: Why tOracleRow filter the rows?

Hi,
We usually use t<DB>Input to execute a select query, you have to use a tParseRecordSet after t<DB>Row to parse the record set if you use t<DB>Row to execute a select query.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.