Hi, guys! I have two collections, collection1 and collection2. In collection 2 there are all of our employees. I need to generate a report where there are Partners, managers and employees. At first I get users into collection1, whose "Manager" column = One of our Partners name. Then i want to loop through this collection(collection1) and add users from collection2, whose "Manager" column equals to the people from the collection1. The problem is I am not able to use "=" sign between collection2.Manager and collection1.Manager columns. Collection1.Manager is record type and needs to be text type. Any ideas how to work this out?
