I am trying to get a list of entities where the value of an enum is equal to the technical name or display name of the entity it is attached to.
For example:
Entity1 has a calculated strip that wants to get a list of entities where the value of the "WhatEntity" enum is equal to "Entity1".
Is it possible to make this happen? From the documentation it seems I need to supply the enum index value or the enum technical name, but there is no way to convert my DisplayName to that.
What I want:
Self = Entity1
SELECT *
FROM Entities
WHERE Entity.WhatEntity = DisplayName <- Errors