How to get CreatedDate for connector

[wzr]

Hello,

I'm looking for a way to get the date of creation for connectors via script.
Unfortunately there is noch CreatedDate in t_connector as in t_object.

Maybe there is a chance with t_snapshot?
But the Information here seams to be quite difficult to decode.

Any ideas?

Thank you!

wzr

[qwerty]

No, there is no way to obtain it "in a natural way". You could write a trigger in your database to create a date somewhere (in an added column of t_connector). But the best would likely be that you just forget about it.

Going over t_snapshot means that you have to turn on auditing. I just think that's just a waste of resources. If so, it might be possible, but I'm not that sure as (I already said it) I'm not using this feature. I might have a look it you're desperate.

q.

[wzr]

Actually I need to analyse this information for existing connectors. So adding additional information might be a solution for future preparation but its not for my current problem.

Since I only need to know the order of creation for a subset of connectors I'm thinking of comparing the connector ID as an alternative way.
Probably I can't trust the ever-expanding characteristic of the ID, but is there a good chance to be close to it at least?

It won't be the end of the world if I'm wrong in some cases with this approach but it would be useless if the result is more like a fortunate coincidence.

What do you think?

[qwerty]

I'm no DB specialist but to my knowlege the ID will just go up by one each time a record is created. However, I would guess that operations like compress or cleanups (the mysterious EA consistency check) might get in the way. Definitely it's not bullet-proof, but maybe it might be sufficient for you. Start a test balloon and see how high it goes.

q.

[Geert Bellekens]

Yes, the connector ID gives you a clue, but be careful.

There are circumstances in which the ID's get reset.
One of those circumstances is xmi import. So if you use version control the ID's won't mean a thing.

Geert