Hi!,

Can a search be formulated, that will list the Active Links created within
a date range? The Create Date for an Active Link doesn't seem to be kept
track of by ARS. Or if it does i am not aware of where it holds that info.
If any one of us can shed light on this subject, it will help in
determining the workflow created within a date range for reporting purposes.

Thanks.

Regards,
Reuben

Hi...

ARS does keep track of the modification date of all objects.

If you in AR-Admin-tool selects details for all objects, you will have a column (among many others) in addition that holds the modification date/time of the objects.

Where this is stored internally, I don't know.

I guess its just to play around with an SQL-tool in the underlaying DB and you will find it.

Of course that gives the Modified Date. My question was about the Create Date .

I overlooked the fact that it was the creation-date-time of an object you wanted.


If the create-date-time is not a part of an object (I don't know if it is or not...) a workaround would be to do some administrative housekeeping yourself.

1) At regular intervals run a query (SQL, ARS-API or whatever)
2) The query lists the existing objects and stores the information "somewhere".
3.1) Then you could do some aggregation on the raw-values like only store the time when objects are created and deleted.
3.2) Or you could keep the raw-values (but this can mean lots of data if the interval is short).

4) With this in place you should have the framework for creating the reports you want.
5) If you can't report on the information you have directly, then you might have to "twist" a bit on the datacollection (1-3).


Once again, I don't know if the create-time of an object is stored somewhere internally. Could be worth to dump a single AL to a def-file and check the contents of the export-file.

I hope I have thrown a few ideas into the air....

You could also use an arsperl script to export all the objects into RCS source control... that would allow you to view create dates... it would be a little bit of work.

You could also build some triggers on your data dictionary that would log the create dates off to custom tables that you could report off of.

Just a couple ideas....

Matt,
Thanks. I myself had just thought of the idea of triggers.

Being a person who likes DB more than front ends, I was thinking on those lines.

Quick,
Thanks. I agree. Administrative options would be the easiest here.