References in queries

vinsnash

Is there a way to display attributes from a referenced object in a query for use as a report input?

Vins Nash

tford

Please further explain your question.

vinsnash

There is a business object that has a referenced object. We want values from the referenced object to appear in a report based on a query result. However, the referenced object does not appear in the "Details" section of the query editor as possible selections for the query result.

I.E. NSCPers.PrimaryParent.LastName

PrimaryParent is a referenced object in NSCPers and appears when it exists in the tab on the main form for NSCPers

Vins Nash

tford

Shortcut?

vinsnash

Not sure what you're asking by "short cut?". I followed the Linked In url and signed up.

The problem is that so many of our cadets have separated parents these days it just makes for too large an object and a too busy main form to track the separate addresses, phones, email, etc. The solution to that,which works quite nicely, is the referenced object. We use that for divorced/separated parents and emergency contacts as well as other necessary data - medical insurance, schools, completed training and other essentials.

We want to combine some of that information in various reports for use by upper echelons of the chain of command. We'd rather not, if possible, use temporary objects, or additional main business object attributes.

I didn't realize you were in the US.

Vins Nash

nlarson

Tom means a Reference Attribute Shortcuts which allow you to display reference data in a grid or report. The easy way to think of it is a quasi JOIN. There is a detailed description in the User Guide.

However, I am wondering if you are looking for reports which have both parent and child data (literally in this case which adds to the confusion! lol) on the same layout? i.e.

Child 1 (parent record in data)

Parent 1 (child records in data)
Parent 1
Parent 3 (?)

Child 2

Parent 1
Parent 2

If so I think you need to experiment with Sub-reports.

For your example, if you just want a list of all child (records) where the parent (record) meets a specific criteria without including the parent record on the report (like for a form letter mailing list to all parent where the child is under 18 or something like that) then you would create a query like...

'Parents of children under 18' with the query as Parent.ChildReference.Age<18

Then use that as that query as the selection criteria in the when you set up you document.

Is that what you are after?

vinsnash

It looks like I've created a mountain out of a mole hill. I assumed because the referenced object attributes weren't available for the query result they wouldn't be available for selection on the report. It appears that they are available and the query results just make for a convenient template.

Thanks for the effort.

Vins Nash