Active Query Builder support area

RelatedField RelatedObject

Avatar
  • updated
  • Completed

Is the word Related in RelatedField RelatedObject actually referring to the general meaning of the word as opposed to the database meaning of the word related

ie It means the field information related to the column you have just clicked the ellipsis on as opposed to any table / join relationship etc

Avatar
Andrey Zavyalov, PM

Hello,

These properties are made to specify referential integrity constraints between database objects, i.e. foreign keys. This information is retrieved from database and stored in the Metadata Container. It allows to link database objects automatically and to add related objects easily by clicking on the chain button at the right of each datasource on Design Pane.

Avatar
Andrey Zavyalov, PM

Hello,

These properties are made to store information about referential integrity constraints (foreign keys). This information is retrieved from database, but it also can be filled programmatically. It is used to automatically join database objects dropped to Design Pane, as well as to display related objects on clicking on the chain button at the right of each datasource on Design Pane.

Avatar
Andrey Zavyalov, PM

I suppose you are talking about the IActiveQueryBuilderExpressionBuilderParams.Related* set of properties.

When the OnCustomExpressionBuilder event is fired for condition cell, the expression in condition cell can be incomplete (for example " = 1"). The left part of the expression is stored in the "Expression" cell of the grid (for example "Orders.OrderId"). The complete condition in the SQL is "Orders.OrderID = 1".

For the sample above, the RelatedExpression property contains left part of the splitted condition: "Orders.OrderID", the RelatedObject and RelatedField refer to the corresponding MetadataObject and MetadataField object respectively.