HomeActive Query BuilderStop user defined joins

Stop user defined joins

Is there a way to prevent the user from creating relationships between fields in tables where that relationship hasn't been defined by a <relation> tag in the metadata?

E.g. stop the user from making a bogus join between two fields in a table that don't make any sense.

Similarely, is there any way to prevent the user from accidentally dropping several tables on the query and creating a cartesian join between them?

Or at the very least, if there's no way to prevent it, at least a way to detect it so that I can show a warning?
Gordon | email
July 10 2008, 09:41 AM
Dear Gordon,

I agree with your suggestions. I believe they could be useful for other users of our component, and we are going to add some new functionality to solve these problems.

We will add an event on adding a relationship, so you may check it for conciseness, and deny it's creation.

Also we are going to add a new method to check queries for validity/conciseness, so you may call it, read warnings and act in accordance with these warnings.

You may expect these features to be available in the near future (may be this month).

Sergey Smagin
Sergey Smagin | email
16 hours, 1 min since original post
This topic is closed