Tree View Question

Jhstephenson

Back to some Tree View Questions...

I have a tree view of Employees Supervised that looks some like this...

Employees Supervised by <<LoggedInEmployee>>

Mickey
	Donald
	Goofy
	Pluto
		Dewie
		Louie
Minnie
	Daisy 
	Hewie

Basically the Logged in Employee supervises Mickey who supervises Donald, Goofy, and Pluto. Pluto also supervises Dewie and Louie. Then Minnie supervises Daisy and Hewie.

This display and operates just fine.

I also have a record operation for each branch that takes me to that employee's main form. This works fine too.

I would like to have another record operation that runs a process for the employee branch selected that does a few things.

So, I create a process that has the Employee BO as the input. I want to find all EmployeeReview records associated with the employee selected and then show them in a query or do an update operation on them.

The question is how do I structure the Find Operation in the process?

I have tried the following:

FIND EmployeeReview WHERE EmployeeReview.Employee=Employee
DISPLAY EmployeeReviews
and

FIND EmployeeReview WHERE EmployeeReview.Employee=ThisEmployee
DISPLAY EmployeeReviews

In both cases I get the EmployeeReviews assigned to me, not the Employee on the selected tree branch.

I must be missing something in how this works, but I am not sure what.

PointsWell

FIND EmployeeReview WHERE EmployeeReview.Employee=ThisEmployee
DISPLAY EmployeeReviews

You are putting the ThisEmployee at the wrong level. The Find inside the Process should be:

FIND EmployeeReview WHERE EmployeeReview.Employee=Employee

The button that starts the process should receive a BO as Input (Employee) and your process will show inputs as Employee this should be mapped to ThisEmployee
Screen Shot 2022-03-12 at 08.28.06.png

If you look at the logger before making this change you will probably see multiple Employee instances being passed to your process, the find takes one of those and in this instance it happens to be your Employee record instead of the chosen Employee

Jhstephenson

We have tried that before and we get an error that says...

Operation 'Review Reports' used in Presentation information in attribute EmployeesSupervised in the form section Supervision of form Main in the business object Employee uses business object 'ThisEmployee' which has not been found.

PointsWell

Jhstephenson wrote
We have tried that before and we get an error that says...

Operation 'Review Reports' used in Presentation information in attribute EmployeesSupervised in the form section Supervision of form Main in the business object Employee uses business object 'ThisEmployee' which has not been found.

My bad, I was commenting from memory and my memory is failing.

On checking the example I had this issue with it seems like I have created a two step process that forks based on some personal criteria, this uses the format

IF x=y THEN 
 ProcessName USING ThisEmployee

That may be an annoying work around. I am going to make a guess that there is an issue of the FIND and the BOs in context.

Another unsatisfactory work around might be to place the target BO.ID into a LIRU or LIRU.SessionVariables attribute and then do

FIND EmployeeReview WHERE EmployeeReview.Employee.ID=LIRU.SessionVariable.EmpID

Jhstephenson

I tried putting the Employee.ID into a session variable, but had the same issue of knowing which Employee.ID it was actually putting into my session variable. Sometimes it worked and sometimes it didn't.

PointsWell

Having looked at your BO architecture you have an insurmountable problem

Employee has
Employee.psSupervisor
Employee.pmSupervised

Because the Query Tree layout is not available you have to use the Tree widget on a form.

The form by default has the Employee in context. The operation on the Supervised then brings another Employee into context. I don’t see how you would drop the initial Employee from context while bringing the desired one into context.

My only other suggestion is

Tree view calls process receives Employee as an input

Process then calls the real process with input of

ProcessName USING ThisEmployee

This would ensure that only one Employee was being passed but I am not sure that it would force the right Employee into context

@Support, this is another reason why Tree hierarchy for queries would be very helpful [IMPLEMENTED v8.8] - Tree Views>