Reverse Search with Elasticsearch
Elasticsearch has an amazing feature called Percolation, which allowed us to save the complicated searches of the Group Portfolio into an index, then when a new project is added, we can ‘search the searches’ to return the Group Portfolio ID.