Hi everyone!
I'm currently stuck trying to achieve the following:
I've created a preset called "Sidecharacter" and "Side-Character Parent". The idea is that each Sidecharacter can have a parent it can use it's voice-type from. Now I've created a calculated strip in the Sidecharacter-Parent Template, which I want to display all the Sidecharacter-entities that are using this sidecharacter parent. To give you an example:
Merchant Ora uses the Sidecharacter-Parent "Female Merchant, Young". For this she has the "Female Merchant, Young"-Reference selected in a reference slot. Now, when I select the Female Merchant, Young - Entity, I want the calculated strip to automatically display all the entities using herself as a parent. I know this should be pretty simple, but I know nothing about the query language. What I tried is this, but it doesn't work:
SELECT * FROM Entities WHERE
TemplateName = 'Seitencharakter' AND Gamedata.ReferenceSlot = SELF
Any help would be appreciated. Thanks in advance!