How to find out AwareIM ID of a Business Object Group??

softserv

Hello members,

I have a problem statement on Business Object Group. We have 2 objects namely, 'Company Admin' and 'Business User'. We created a business object group namely 'ClientUserGroup' and pulled these objects into it. When we call this group in any form as a reference (in the form of a dropdown), we write the following query in AIM.

FIND ClientUserGroup WHERE ClientUserGroup.Company=LoggedInClientUserGroup.Company

Since ClientUserGroup is existing in the database, there has to be an AIM ID that gets attached to it. Is there a way to find that ID somehow?

I am also attaching an SP which we used to pull User Full Name from this Business Object Group. But it is giving an error. "Rule uses ClientUserGroup which has not been found".

SP details as mentioned below:-

EXEC_SP 'EventModuleAll_EXT' WITH '@companyID'=LoggedInClientUserGroup.Company.ID RETURN ClientUserGroup

Thanks,
SoftServ

tford

Instances of a BO in a Business Object Group don't get a new ID, their ID remains the ID of the underlying BO that is a member of the Business Object Group.

The easiest way to demonstrate this is to create a brand new BSV and add one process to it with this one rule:
DISPLAY MESSAGE 'ID :'+LoggedInSystemUser.ID

You'll find that the ID that is shown in this message is identical to the ID of the default RegularUser instance that is created with any new BSV.

aware_support

Your stored procedure needs to use a UNION on the tables of the members of the group.

For an example use database tools to see the SQL that Aware IM creates automatically when you run a standard Aware IM query on a group - this will make it obvious what you need to do in the stored procedure.

softserv

Hi AIM Support team,

We are able to create a UNION between those 2 business objects withing BO group. But when we are executing below statement, then there is an error appearing:-

EXEC_SP 'EventModuleAll_EXT' WITH '@companyID'=LoggedInClientUserGroup.Company.ID RETURN ClientUserGroup

We want to return the business object group i.e., ClientUserGroup but getting 'Rule uses ClientUserGroup which has not been found' error message. Is there another way to return BO group or return the UNION of 2 business objects in the above statement?

Thanks,
SoftServ team

aware_support

Is there a stack trace of the exception in the output of the Aware IM Server? Can you attach it?

softserv

Hi,

It is not letting us to Create the SP statement itself. There is no note in AwareIM server log also. I am attaching a screenshot of the same. Thanks!

SP error.png

aware_support

Try specifying any member of the group as the return. It shouldn't affect the result