I have an entity called module and another called upgrade. Each upgrade has a strip property that has a reference to all the modules they can be applied to. This strip is called ApplicableTo.
I tried putting a calculated strip on the Module which should list all the upgrades that can be applied to the module.
I Tried
- Code: Select all
SELECT * FROM Entities WHERE Upgrade.ApplicableTo contains SELF
and .
- Code: Select all
SELECT * FROM Entities WHERE Contains(Upgrade.ApplicableTo, SELF)
Neither worked. Am I missing something? Help pls.
Thanks