Searching the SalesLogix Database for Looped or Recursive Joins

Question: I believe that my SalesLogix system may have some recursive joins
because it takes a very long time to pull up the field selector (text)
on the property window of a field on a form.  Is there a way to look at
the database and generate looped or recursive joins? 

Answer: Try running this:

SELECT J1.FROMTABLE FromTable, J1.FROMFIELD FromField, J1.TOTABLE ToTable, J1.TOFIELD ToField
FROM sysdba.JOINDATA J1 join sysdba.JOINDATA J2
on (J1.FROMTABLE = J2.TOTABLE

AND J1.TOTABLE = J2.FROMTABLE
AND J1.FROMFIELD =J2.TOFIELD
AND J1.TOFIELD = J2.FROMFIELD)

 

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!