NULL values in my result set
Date: September 24, 2012 10:27AM
I need help diagnosing this query or a better way of running it. I recently added some new fields to my database but I get NULL values returned in my result set. I sm not sure why since when I look at the table that holds the new values they are there.
Here is the query:
select * from swtickets t
left join swcustomfieldvalues cfv
on t.ticketid = cfv.typeid
left join swcustomfieldoptions cfo
on cfv.fieldvalue = cfo.customfieldoptionid
where t.resolutiondateline > '1346457600';
I can confirm my values are in the swcustomfieldoptions table and again in my result set, I see the customfieldoptionid value but the field I am looking to see populate is called optionvalue which is a part of the swcustomfieldoptions table but for some reason returns with NULL values in the query above.
Any help and direction is greatly appreciated.
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.