Help with process

roxmer

Hi,

I have been trying to solve this problem with no success. I would very much appreciate any help to accomplish the following functionality:

There are 2 BOs: Study and Organization. One Study is carried out in one Organization. The attribute Organization in the Study is a per reference to the BO Organization. The Organization has an calculated attribute called TotalStudies to count how many studies are carried out in the Organization.

BO Study
Organization: type Organization, per relationship
...

BO Organization
TotalStudies: numeric (calculated)
...

I tried to calculate the TotalStudies through a process called "UpdateTotalStudies":

Organization.TotalStudies=COUNT Study WHERE (Organization IN Study.Organization)

-It doesn't work. I tried also to do something similar in a rule in the Study BO when the Study.Organization IS CHANGED, but it did not work properly.

I have a presentation with a chart that uses as X axis "Organization.Name" and Y axis is the "Organization.TotalStudies". The presentation is used by a query used in the the member perspective. This perspective has three tabs: Welcome, Organizations and Studies. The tab Organization presents the chart.

My questions are:

How to calculate Organization.TotalStudies in the Organization BO?
How to update TotalStudies for all organizations at once before the tab "Organization" is selected in the visual perspective to present the chart for the organizations?

Thanks in advanced and have a very nice day,
Roxana

RLJB

Hey Roxana

You're close:

a) change your rule to:

Organization.TotalStudies=COUNT Study WHERE (Study IN Organization.Study)

and Orgainization.Study is the ref attribute with multiple allowed

b) put the rule on the Organization BO. If you just put it in like that it will fire when you save the form. You can also refine it by adding:

IF Orgainization.Study WAS CHANGED

c) to update all at once, you have a few different options, if there aren't too many other rules on the BO you could do:

FIND ALL Organizations
UPDATE Organizations

(as a process)

Have fun!

(Also - this isn't a problem with Aware so you should have posted it in the General section, not in problem reports)

roxmer

Hi RLJB,
Thanks a lot for your replay! (My mistake, I had no idea I was posting in "problems").
The Organization BO is like a static BO. The members has no access to it through the interface. They can only select from the Study form which Organization it belong to.
There are another BOs using Organization in the same way (ContactPerson, DataAdministrator...) Only the system administrator can modify the Organization BO interactively or by importing a file. The Organization BO behaves more like a selection list. As an attribute of Study, ContactPerson, Member.
Do you think I should create the relationship for Study, ContactPerson, Member... BOs as well?
I'll try your solution right away with Study BO and inform you about the result.
Thanks again and have a nice day,
Roxana

roxmer

RLJB,

It works perfectly. No need to use the process. It works with the rule for Organization and adding the multiple relationship to Study.

Rule:

JuristicPerson.TotalSampleCollections=COUNT SampleCollection WHERE (SampleCollection.JuristicPerson=ThisJuristicPerson)

I'll do the same for the BOs that need to be query in the same way.

I love AwareIM!

Thanks again!