How to set r_modify_date, r_modifier and r_creator_name ?

Hi All,

I have to set r_modify_date, r_modifier, r_creator_name for an object using dfc code. Other than this attributes all the attributes is getting saved properly with the value which i used in set methods. But when i am using

folder.setString("r_modifier","Test User");

folder.setTime("r_modify_date",Test Date);

folder.setString("r_creator_name","Test User1");

The value which i used for setting(Test User,Test User1,Test Date) is not saved in the object, Instead the session user name that is "dmadmin" is saved in the r_creator_name and in r_modifier. And the current date is getting saved in the r_modify_date.

Please help me on this

Thanks

Arun

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

dm_user

Hi Arun,

You can save those values by executing below mentioned SQL query:

For that you need to have superuser previlege

execute EXEC_SQL with query =' update dm_sysobject_s set r_modifier=''Test User'', r_creator_name=''Test User1'' where r_object_id=''<r_object_id>'' ';

But, it is not a recommended approach.

Regards,

Arindam

All comments

sivarry

Hi Arun,

It is the intended functionality of DFC to comply with document/records management. You can modify these attributes directly in the underlying RDBMS which is not a good approach

-Siva

dm_user

Hi Arun,

You can save those values by executing below mentioned SQL query:

For that you need to have superuser previlege

execute EXEC_SQL with query =' update dm_sysobject_s set r_modifier=''Test User'', r_creator_name=''Test User1'' where r_object_id=''<r_object_id>'' ';

But, it is not a recommended approach.

Regards,

Arindam

DCTM_Guru

Why dont you try solving the root of the problem -> "...Instead the session user name that is "dmadmin" is saved in the r_creator_name and in r_modifier. And the current date is getting saved in the r_modify_date."

- That is b/c your DFC code is connecting to the docbase as dmadmin. You should be connecting (and establishing session) with the user credentials.

- The r_modify_date contains the server time when an object is modified. If you dont want to use this date, create your own custom date attribute.

aflowers001

To add to what johnny said use a user account. If you don't have the full credentials, i.e. no password, then look at getting a login ticket via the superuser account and then use this to create a session as the actual user. this way you are covered by setting the right metadata AND you will execute under the security rights/privileges of the actual user as opposed to a super user.