I am trying to get a query that lists items in a Business Group using a common attribute to all business objects in the group. When I try to create it I get a an 'Invalid Query' titled message but the actul message box is blank.
The query is
FIND CallTypes WHERE CallTypes.CallRecord.Status='Open'
Is CallRecord attribute in CallTypes multiple? If it is, then the query is invalid because it is unclear which of the referred CallRecords you are checking. if you want to check that there is one among them that has open status, then the query should use EXISTS
It is not CallTypes that has status - it is CallRecord. So which CallRecords with open status you want to show? All of them? Then the query should be FIND CallRecord WHERE CallRecord.Status = 'Open'
Does it have to do anything with CallTypes? If so, which one?
Actually I have a mistake in my original request. The CallTypes Business Objects Groups contains approx 20 Business Objects. Each Object has an attribute of CallRecord and Event. There is only one type of Call Record Object, however the Event attribute can be any one of the twenty Call Types Business Objects. There is an attribute of Status on Callrecord but also an attribute of Status on each object in the EVENT attribute.
Therefore I can do a search direct on Call Record for Status however the Event.Status can be in any number of business objects.
I actually need to find all EVENTS where status - Open