How do I create a query that returns a BO + references?

Contains tips for configurators working with Aware IM
Post Reply
GaryBartlett
Posts: 58
Joined: Wed Feb 22, 2012 9:44 am
Location: New Zealand
Contact:

How do I create a query that returns a BO + references?

Post by GaryBartlett »

Hi,

I'm sure this is obvious, but I just can't work out how to create a Query that returns a table containing the BO attributes and its reference attributes.

E.g. I have a BO called Request, with attributes Number and Name and a reference attribute Requester. Requester is drawn from a BO called Contacts.

I want to create a Request query that shows

Number|Name|Requester

Thanks very much!

Gary
Gary Bartlett
gary.bartlett at prodsol.com
[Aware IM 5.8]
GaryBartlett
Posts: 58
Joined: Wed Feb 22, 2012 9:44 am
Location: New Zealand
Contact:

Post by GaryBartlett »

Oh dear - wrong forum - sorry Support!
Gary Bartlett
gary.bartlett at prodsol.com
[Aware IM 5.8]
GaryBartlett
Posts: 58
Joined: Wed Feb 22, 2012 9:44 am
Location: New Zealand
Contact:

Post by GaryBartlett »

Got an answer from Rocketman, offline (I sent him a private email asking for help):
In Request, create a attribute (type Shortcut) which points to contacts.name(or something - you can have more than one shortcut eg Firstname Surname)

Then put the Shortcuts into the query so Request.number, Request.Name, Request.shortcut1, etc etc
Worked perfectly!
Gary Bartlett
gary.bartlett at prodsol.com
[Aware IM 5.8]
Post Reply