Skip to Content
0
Dec 12, 2021 at 03:20 AM

LDate is empty

155 Views

Hello Experts,

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.

Requirement SQL:

with A as

(

select uname, max(date) LgnDate

from rpt c

where c.date >= add_months(sysdate,-12)

group by uname

)

select b.LgnDate

from B_user b

inner join A

on A.uname = b.uname

where nvl(b.LgnDate,'01-jan-15') <> A.LgnDate

Thanks,

Dinya.