Add cross-search pivot capability
Allow Search results let the user select one or more records and click a "Pivot" option to show a listview of L1, L2, and/or CRM records that have a connection to the selected items.
Use Case:
I want to know about funded projects completed by some (not all) of the organizations from Region 5 that use fiscal sponsors. So I filter for organizations in Region 5 of types "Charitable" and "Non-profit Using Fiscal Sponsor", and get 19 results, of which 6 organizations are of interest.
I select those 6, and then select from a "Pivot" option list including "Applications" and "Contacts" - in this case I select "Applications", and that returns 11 applications for the 6 organizations, showing the application ID, status, etc. (this should be configurable like any listview).
Of the 11 applications, 7 are in "Closed" status, so I select those seven, and then select from a "Final Reports" from a "Pivot" option list that includes "Primary Contacts", Primary Organizations", "Grant Agreements", "Payments", "Progress Reports", "Final Reports", "Attachments", "Emails" etc.
I can now review the completed fiscally-sponsored projects through those reports.
If I simply tried to do an Activity Search for Final Reports related to Organizations in Region 5, I would have too many reports, or need to do further Boolean filter setup to filter fiscally sponsored application reports which would not not be easy. Plus I'd still have results I didn't want, since I couldn't manually select only the organizations I'm interested in.
