Property based filter

[UMAMAHESH]

Hi Experts,

In Employee list we maintained one property called Reporting Person.

In Reporting person property we maintain reporting employee names for eg: manager reporting to owner , Supervisor reporting to manager,Staff reporting to Supervisor.

In Selection When i select Owner position then Show all owner combination data in one report Its working correctly.

In second report we need to display all descendent members of Particular Owner. (i.e managers,supervisors,staff under Particular owner)

in the above screenshot Sravan is owner under his have some managers,supervisors and Staff employees.All descendent employees display in second report.

[VIGNESH.M]

Hi Uma,

You already have 1st filter,

Add 2nd Filter, Use the logic shown above.

Apply the 2nd filter in your 2nd Table.

~Vignesh

[DavidSmith]

That will only work if the orginal filter resolves to a single employee

If the filter reslovers to 1+ Owners, the filter will show multiple chains of authority

the solution might require some parallel lists

I will have a think!

David

[VIGNESH.M]

Hi David,

It will work even we have 1+Owners. 

[DavidSmith]

Agreed, but you won't be able to sync the lower grid when you select an owner from the top grid, which I understood to be the requirement

[VIGNESH.M]

Yes David , you are right, the 2nd grid won't sync if we select particular employee.

[Pooja]

Hi Uma,

As a best practise replicate same List into Module.

Create Single cell Employee list formatted line item and one Boolean line item.

 Write a logic shown Below.

Now Apply a filter based on Boolean as shown below.

Now Publish both Single selection line item and filtered saved view.

Thanks

Pooja

[DavidSmith · Accepted solution]

@UMAMAHESH 

Ok, this works

Expanding on my solution from above I added the Reporting to? line item to the Employee Details module (formatted as the Employees list)

1. Add two line items to the Employee Filter module, both formatted as Boolean

2. the formula for Children Filter is Analyse?[LOOKUP: Employee Details.Reporting to?]

3. Publish just the Analyse? column to the dashboard, set the Employee column width to 6

4. Now Publish the Employee Details module again below the top grid and filter the module on the Children Filter from above

5. Now when you filter from above, you can filter the second view accordingly

Given the Analyse? filter may get hidden if you change the top filter, it would be worth putting some instructions on the dashboard to clear the Analyse? settings before amending the top filter

Hope that helps

David

[UMAMAHESH]

Hi david,

Thank you for your reply.

As per above reply when i select Owner then it displays manager members only. But as per the requirement when i select owner it displays all decendent members i.e managers,supervisors and staff.

In the above screenshot sravan(Owner) based on owner selection  we need to display pallavi(Manager),Prasanth(Supervisor),Arun(Staff).But in your solution it shows only manager(Pallavi).

Hope you understood.

Regards,

Uma

[DavidSmith]

Ok, if I understand correctly, you are wanting the whole chain of reporting to be displayed in the bottom grid not just the direct children

To faciliate this, you can set up line items in the Employee details module to traverse back up the hierarchy

So manager L4, Manager L3, Manager L2 ertc.

The line item formulae are:

L2 Mgr = Reporting to?[LOOKUP: Reporting to?]

L1 Mgr = Reporting to?[LOOKUP: 'L2 Mgr']

You then need to amend the Children filter to check against the new "Manager" line items from above

This will now reflect the full hierarchy when selecting which top level manager to analyse

David

Then you should be able to use those to check again the filtered values.