Query Creation Question with Relationship

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
twhitehurst
Posts: 62
Joined: Mon Jan 02, 2006 3:20 pm
Location: Fort Worth Texas

Query Creation Question with Relationship

Post by twhitehurst »

I have a business object called Project and I have a business object called inspections.

I have a one to one relationship of "InspectionProject" and a one to many of "ProjectInspections"

This works find on the form. When I create an Inspection record the system pulls in the project information from the project I am working in.

However, I need to run a query that shows all Projects and their Inspections. When I choose the Business Object of Inspections for the Query, the attribute of InspectionProject is not avaliable?

Am I doing this wrong? I need the result table to show the Project that is associated with the inspection.
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:

Post by aware_support2 »

All you need to do is to add some shortcut attributes to Inspection object that point to Project attributes. This way the project details will appear to be a part of Inspection object and can be used in query results and other parts of the system as if they were actual Inspection attributes.

For example, if object Project has attribute Name you can add attribute ProjectName of type Shortcut to object Inspection with the attribute path set to InspectionProject.Name. You can then select ProjectName as an attribute to display in the query results for Inspection.

If you have a single form for object Inspection the system will automatically append the newly added attributes to the form. Do not forget to remove the shortcut attributes from the form if you do not want them visible there.

Please check object Loan in the configuration of the Library sample application for an example of shortcut attributes.
Aware IM Support Team
Post Reply