According to Epicor help I should be able to use resource collections to create a quick search to return a list of resource groups in the collection. I can’t figure out how to do this. The resource groups are stored in a delimited list in the resource collection record. Am I trying to do the impossible? Is there another way to do this? I am on 9.05.701.
Sue
Once you get the ~ delimited data you can split it.
In C#:
In a BPM:
I have been able to split the list using calculated fields in a BAQ. The problem is I end up with the split values in one row, I think I need one row per list item to return a list of resource groups in a search. I’m on E9, not E10, so can’t try subqueries. I could be misunderstanding quick searches or maybe my brain is done for the week, but I’m thinking it would be much easier to ditch the idea of using the Epicor resource collection feature and set up my own resource collection with a user-defined table! I did find an old SCR (80623) that says Epicor help misleads the user as of the use of resource groups.
Thanks for the suggestion!
Answer from support on using a delimited string in a quick search is “It can’t be done.” (Epicor help on resource collections…You use resource collections on quick searches and custom dashboards. When you select a resource collection, the search window or dashboard displays data for all of the resource groups included within the collection. For example, you can view a resource collection within a Scheduled Load Graph, displaying all of the load for the resource groups included in the collection.)
I accomplished what I needed by creating quick searches for various sets of resource groups. A user-defined parent/child table used as resource collections also worked.