user name , creation time

[Former Member]

Dear experts,

I want to get the user name who created the business partner and also the creation time.

[Former Member · Accepted solution]

Hi,

Try:

select t0.CardCode,t0.CardName, t0.CreateDate,t1.U_name from OCRD t0

inner join OUSR t1 on t0.UserSign=t1.INTERNAL_K

Thanks,

Gordon

[Former Member]

Thank you everyone . issue solved.

[kothandaraman_nagarajan]

Hi,

The created time is not stored in OCRD table. Hence it is not possible to get created time.

Try this query without creation time:

SELECT T0.CardCode,T0.CardName, T0.CreateDate as 'Created Date',T1.U_name as 'Created user Name' from OCRD T0

INNER JOIN OUSR T1 on T0.UserSign=T1.INTERNAL_K where T0.[CardType]  = [%0]

Thanks & Regards,

Nagarajan

[former_member188586]

hi

check bellow thread ,it will help you

Thanks&regards

AndakondaRamudu

[former_member184146]

Hi,

     For Date and Created by use below query

select A.CardCode,A.CreateDate,B.U_NAME from OCRD A INNER JOIN  OUSR B on A.UserSign2=b.USERID

and for Time

it is not possible to save also the time in those columns. You can however create userfields to store the time at which the record was created/updated.

Regards,

Manish