I'm hoping that my admission of defeat will spawn an epiphany after I hit the Submit button. This is just too easy.
I have a process to load a BO for chart data, so this is really easy. I have several others just like this, but this one is not behaving.
This process loads one row for each Investigator object, of which I have two in the database...
/find and delete all chart object data/
FIND ALL ChartInvestigatorWorkload
DELETE ChartInvestigatorWorkload
*/do this for each Investigator
FIND ALL Investigator
CREATE ChartInvestigatorWorkload WITH ChartInvestigatorWorkload.Investigator=Investigator,
ChartInvestigatorWorkload.Organization=Investigator.Organization,
ChartInvestigatorWorkload.ActiveCases=COUNT PHS WHERE PHS.Candidate.Status='Active' AND PHS.Candidate.Investigator=Investigator)
As I said, I have two Investigators in the database and the process creates only one row in the ChartInvestigatorWorkload object.
Does anyone see anything that I don't?
