Hi,
we have made some matrix-models - and thus some "ticks" have created the Relationship "Provides input for".
I would like to do a report/query on objects that do NOT have this relationship.
How do I do that?
Thanks and merry christmas :)
Regards Carsten
Hello Carsten,
this should be quite easy with a macro or report. First you have to decide where the report should be started, e.g. on a model or directly on an object. If you start on a diagram you have to collect first all occurences of the model and then the object definitions of the occurences. Now you can ask the object definitons for their attached connection definitions. These definitions have a type and this type you have to compare with the type number of your relationship. If there is no such connection definition attached to your object it is part of the result set.
You might also start directly on a dababase and search for all object definitions with a certain type. All found objects now should be processed as described above.
Best Regards
Uwe
Hello Uwe,
thank you for your reply. I am afraid you need to be a bit more specific, as I have not a lot of Report building experience. I have tried the WYSIWYG approach but got stuck. I will probably have to go the script way. Any more specific ideas?
Thanks!
Regards Carsten
Hello Carsten,
you are right, you have to go the script way to reach your goal. With a little software development background it is not a big thing to create a script that starts on an object definition for example and to write a small algorithm to analyze it's attached connection definitions. The scripting interface is well documented, for an experienced developer it be a matter of less a day to write the script.
Best regards
Uwe