I have two table c and b joined using IDT. i need logindate and username as business object column from the below requirement sql
let me know how to achieve this uname is pulled in the query panel IDT BL alongwith pulling lgn date as login date but displaying null values.
here ogin date is blank for all the username. Please help with the design in IDT or custom query or formula to get the login date details for all the user associated.
with A as
select uname, max(date) LgnDate
from rpt c
where c.date >= add_months(sysdate,-12)
group by uname
from B_user b
inner join A
on A.uname = b.uname
where nvl(b.LgnDate,'01-jan-15') <> A.LgnDate