Skip to main content
Question

Object Creation Date & Creator

  • October 8, 2021
  • 3 replies
  • 256 views

Forum|alt.badge.img+10

Hi,

Every single object has got a ROWKEY ID, is there a table centralizing a kind of log of who generated this ROWKEY so you can know who is the creator of any data in IFS? and when it was created?

If not, how can i know who has created a Supplier? and when?

idem for Customer, Employees, Persons …

For Purchase Order, there is an history, but for most of the rest, it is not obvious…

I know I can create an History Log on every item but 

1- that’s a lot of work

2- that’s maybe redundant

3- It’s not that easy to audit

4- It’s slowing down the DB at some point

Thanks for your help !

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+9
  • Sidekick (Customer)
  • 92 replies
  • June 16, 2022

I’m also interested in finding this out.


KristenGastaldo
Superhero
Forum|alt.badge.img+18

@Rusiru Dharmadasa - Can you help on this one?


Rusiru Dharmadasa
Superhero (Employee)
Forum|alt.badge.img+20
  • Superhero (Employee)
  • 697 replies
  • June 20, 2022

Other than history logging, I don’t think there is no such functionality that already available with the application. It has to be a oracle database table trigger or something, and that is the same way it history log does.