Custom Field - Enter Modified Date and User

Hi @matthunter ,

I think you can accomplish what you’re asking one of two ways.

1. Create a custom event against the custom table behind the custom page.  Set the event up to trigger on insert and update.   You could then create two custom actions one which fires when for the insert and you could store the username and datetime of the insert into the record.   The second custom action would fire on an update and you could specify a specific field to monitor and record the user and datetime of the update.
2. Another option could be to utilize the IFS History Log under Solution Manager->Monitoring->History.   You could configure so your could record history on insert on the unique key named rowkey and the system would record the user and datetime.   You could also configure it to log update of a specific field and it will record the user and datetime.

Regards,

William Klotz

Ha! I had a feeling it might be a custom event. Thanks William.

The second approach is new to me but I’ll give it a shot.

Hallo

I did it for Custom LU CInstCompInstrument.

C_ICI_DATE_ENTERED

2020-06-23 FLESABRIW create - Show the Created Date (History Log) of the Installed Competitor Instrument

SELECT  hl.time_stamp

FROM    history_log_attribute_tab hla,

               history_log_tab hl

WHERE  hl.log_id = hla.log_id

AND       lu_name = 'CInstCompInstrument'

AND       hl.keys = 'OBJKEY=' || :rowkey ||'^'

AND       history_type = '1'

ORDER BY  hl.time_stamp DESC

FETCH FIRST ROW ONLY

C_ICI_USER_ENTERED

2020-06-23 FLESABRIW create - Show the Created User (History Log) of the Installed Competitor Instrument

SELECT  hl.username

FROM    history_log_attribute_tab hla,

              history_log_tab hl

WHERE  hl.log_id = hla.log_id

AND       lu_name = 'CInstCompInstrument'

AND       hl.keys = 'OBJKEY=' || :rowkey ||'^'

AND       history_type = '1'

ORDER BY  hl.time_stamp DESC

FETCH FIRST ROW ONLY

C_ICI_DATE_MODIFY

2020-06-23 FLESABRIW create - Show the Modified Date (History Log) of the Installed Competitor Instrument

SELECT hl.time_stamp

FROM history_log_attribute_tab hla,

 history_log_tab hl

 WHERE hl.log_id = hla.log_id

AND       lu_name = 'CInstCompInstrument'

 AND hl.keys = 'OBJKEY=' || :rowkey ||'^'

AND history_type = '2'

ORDER BY hl.time_stamp DESC

FETCH FIRST ROW ONLY

C_ICI_USER_MODIFY

2020-06-23 FLESABRIW create - Show the Modified User (History Log) of the Installed Competitor Instrument

SELECT hl.username

FROM history_log_attribute_tab hla, history_log_tab hl

WHERE hl.log_id = hla.log_id

AND lu_name = 'CInstCompInstrument'

AND hl.keys = 'OBJKEY=' || :rowkey || '^'

AND history_type = '2'

ORDER BY hl.time_stamp DESC

FETCH FIRST ROW ONLY

Setup History Log for C_INST_COMP_INSTRUMENT_CLT

I did it on IFS Apps 10 Update 10.

Best Regards,

André

that’s really good post

@andjor

Wow, that looks very helpful. Thank you so much for writing that all up! Are those attributes to the Custom LU? Or are they event actions?

@matthunter 

I didn’t need any event action for this. I use only custom field and the History Log.

Best Regards,

André

Could you send a screen shot of the custom field? Thanks André