I'm
not sure this will help you but it might do a interesting job for you, in
SQL. It is not possible to execute it from within TMS but use MS SQL Query
Analyser if you have it or any other similar tool, like the one in Crystal
Reports. (if installed on windows it's : start>>program>>
CrystalReportsTools>>CrystalSQLDesigner, click the blank with paper
and
then choose your linking info (ODBC – TMS?)and then choose to "enter sql
statement directly") Run this query: "select distinct constituentid, displayname
from constituents where constituentid not in (select distinct constituentid from
conxrefs) order by constituentid". They can be linked to something
elsewhere in TMS but this might point you in the right
direction.
The
following query will give you the number of objects related to each constituent:
"SELECT constituentid, count(id) number_of_obj FROM conxrefs group by
constituentid". I hope this was helpful for you.
-----Ursprungligt meddelande----- Från: Ella Rothgangel
[mailto:[log in to unmask]] Skickat: den 26 november 2002
14:30 Till:[log in to unmask] Ämne: searching for
unlinked constituents
I’m trying to figure out a way to
search for unlinked constituents (i.e. constituents who are not attached to
anything anywhere and need to be deleted).Has anyone tried this or been
successful, either with an Advanced Query or a Crystal
Report?