Technical rule Advance Query - Add Direct and Indirect Reports

[JuanHernandez]

Hi 

I am working in a requirement where people that covers 2 conditions needs to be assigned to an application, as you may know this needs to be done over a technical rule; for that purpose, the people assigned that covers this rule needs to get assigned users that repots directly or indirectly to the main user. 

Example 

Imagin a table users with fields, username, manager, type 

if the user type is equal to "ContidionMatch" this user and all users reporting to the same should be assigned, including those that report indirectly. 

Sample below: 

We have User1, User2, User3 and User4, User10

User2 has as Manager User1 and User3 has as manager User2, and User4 has as manager User10

If the user covers the first condition, User1, User2 and User3 should be assigned to the app. Below a sample tree.

User1 - Parent assignee since it covers the rule of employee type.
User2 - gets assigned because it is directly managed by User1.
User3 - gets assigned because it gets indirectly managed by User1 since User3 is managed by User2 managed by User1.

Is there a way to cover this assignation from a technical rule? the technical rule supports HQL so wondering me how the MySQL can be translated to HQL for this use case. 

Thanks
Juan Hernandez

[nimitdave]

@JuanHernandez , This is not supported now in EIC versions. But the condition that is matching for the manager should also be matching for the direct and indirect reportees too. 

However, you can leverage the Inline preprocessor to make the same change consistent for direct and indirect reportees too if its a full user import.

[JuanHernandez]

nimitdate thanks for your answer, in this case we are looking to create accounts based on that hierarchy Is that supported by a preprocessor or query? 

[nimitdave]

@JuanHernandez in preprocessor you get the same customproperty set for the direct and indirect reportees also in addition to the manager and then the same tech/userupdate will triggere for reportees to and then will provision account.