For a search result, get all values for a specified Key

[will-moore]

Having performed a search, we want to allow filtering by a chosen Key. This can be done by adding a AND clause to the search.
But we need to know all the possible values of that Key for the previous search results (otherwise the user may easily pick a value that gives no results in a new search).

I noticed that a search results from /submitquery includes a "bookmark" ID for pagination.
Perhaps this could be used for retrieving all the Values for a given Key from those results.

Ideally the results of this search would be similar to the searchvalues that is currently used to populate auto-complete and includes image counts:
E.g:

GET /searchengine//api/v1/resources/all/searchvalues/bookmark/123/?key=Gene&value=pax

This would then also work if the user hasn't chosen a Key:
GET /searchengine//api/v1/resources/all/searchvalues/bookmark/123/?key=Gene&value=pax

This is similar to the issue #11

[will-moore]

As discussed in meeting today... cc @khaledk2

Search scenario...

• Search for Organism = Homo Sapiens and get results grouped by study:
• Choose to view images from e.g. idr0043: This makes a query like:

 mode: "searchterms"
query_details: {
  "and_filters" : [
    {name: "Organism", value: "homo sapiens", operator: "equals", resource: "container"},
    {name: "name", value: "idr0043-uhlen-humanproteinatlas/experimentA", operator: "equals", resource: "container"}
  ]
case_sensitive: false

• Now I want to know all the values of "Organism Part" within those 5931242 Images.
• With that list E.g. "Brain", "Heart", "Lung" etc... the user then wants to see the images under "Brain", so I can do a query like the one above that adds to the `"and_filters" : {name: "Organism Part", value: "Brain", operator: "equals", resource: "image"}...
• Then, if they want to group those images again, e.g. by Gene Symbol then we need to query all the values for Key: Gene Symbol within that previous search...
• This cycle could continue through several iterations!

[will-moore]

This is working for me, testing against idr-testing at

https://idr-testing.openmicroscopy.org/searchengine2/api/v1/resources/image/container_filterkeyvalues/?container_name=idr0043-uhlen-humanproteinatlas/experimentA&key=Organism%20Part

with POST query of and_filter:

name:  "Gene Symbol"
operator: "equals"
resource: "image"
value: "A1CF"

returns:

    "results": [
            {
                "key": "Organism Part",
                "no_image": 74,
                "value": "Skin"
            },
            {
                "key": "Organism Part",
                "no_image": 61,
                "value": "Lung"
            },
...

[jburel]

Thanks @will-moore for testing and confirming that the issue is fixed.