Re: Linking records together
Date: Thu, 24 Sep 2009 08:46:53 +0200
Thanks for the suggestions, I will definitely look into it.
"Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> wrote in message
> PJ (pjv_dev.nospam_at_geenspam.hotmail.com) wrote:
> : Hi all,
> : We need to track work items across several existing applications. Items
> : start as a document on disk, can be renamed or moved, converted to a
> : in an application, until they reach a certain state. The applications
> : nothing about preceding or following applications and there is no common
> : identifier for the items, which has always been a good thing.
> : My idea is to create a table for all events. Each application will
> : their
> : own events. A minimum is one event per application with a starting and
> : finishing situation for that application. Example: "file \\folder1\x.doc
> : moved to \\folder2\y.doc". Another application may follow up with
> : "\\folder2\y.doc was archived with id 12345". Each event will have a
> : and time.
> Use connect by to join the entries and sys_connect_by_path to show each
> complete path.
> You will get extra entries such as
> Filter that list so you only see the results where the end (e.g. X) does
> not have a next connection.
> CONNECT_BY_ISLEAF might help do that.
> CONNECT_BY_ROOT might be useful when displaying the end points.
> sys_connect_by_path might not even be required here.
Received on Thu Sep 24 2009 - 01:46:53 CDT