I want to be able to identify via a query, the parent assembly where a legacy option is used. I have been able to write a query that will return the option set using the VariantRevision as the starting class, with the criteria:
I.e if i enter the Item Id that the options were defined against, it will return a list of options.
I have also been able to write a query that will return the parent item if i enter the option name:
i.e If I enter any option names, it will identify the parent Item that it is defined against.
So I believe that I am on the write track. I have looked at using query that returns an Item revision, based on "Assembly to child components" Query Hint, with the following search criteria
However this does not return anything
Good pickup with the underscore before parent_bvr.
Sadly that was a typo in the post. The string I have in the query is as you suggested and returns no results