Selecting a category based on one to many relationships

[biofio]

I currently have data with relationships set up like this. Here are some key points about the data:

* Every AppRelease has multiple submissions, which each have zero or more reviews

* Every review can either be "Blocking" or "Non-blocking"

* If an AppRelease has any review that is "Blocking", it should be "HasBlocking" should be equal to "Blocking". Otherwise, if it has a "Non-blocking" review, it should be "Non-blocking". Otherwise, it should be "No Review."

Is there any mechanism by which to properly set the "HasBlocking"? attribute

[v-piga-msft]

Hi @biofio,

I'm not very clear about your requirement.

If it is convenient, could you share some data sample and your desired output so that I can understand your scenario better?

Best Regards,

Cherry