BusinessObjects Board

Last updated date?

general discussion
#1

I’m hoping to find when all my documents were last updated by querying the repository table obj_m_docat. the return is the document id and two date fields that i am unfamiliar with. example = 1156667952

can someone explain what that translates into a calendar date?

is there a better way to find this information?

Also, how can i find a list of users in the repository?

I’m on 5.1.9

thank you

taylor99ss (BOB member since 2006-12-20)

#2

There are two table columns in most tables, one ends in _LAD and the other in _LAT. The LAD is the last action date, and the LAT is the last action taken. Both are coded. The date is a form of a timestamp as the number of seconds since midnight on December 1970, and the LAT is coded as well. The documentation on the repository that we have posted in the Supervisor forum will probably help you understand what you are looking at.

Dave Rathbun :us: (BOB member since 2002-06-06)

#3

Hi,

If you have an Oracle repo below you can find the conversion function:


to_date('15/12/1970','DD/MM/YYYY') + (OBJ_M_ACTOR.M_ACTOR_N_LAD/86400)

Regards