Multi Select Field (with multiple values) as a parent for Nfeed field

[David Nickell]

Is it possible to use a multi select field as the parent for an Nfeed field? When working with the Edit Query, the syntax of the select statement is something like this:

Select FieldX from TableY where FieldZ = '$parentValues.get(0)'

How would I modify this SQL to handled the multiple values in the parent field? I understand I'll change the "=" to "in", but what is the format of the parentValues variable?

Thanks in advance

[Cyrille Martin · Accepted solution]

Hi David,

Sorry I didn't catch you question before.

Indeed you can have a parent with multiple value. To access to those value in the child nFeed field you will use 'in' and other functions.

An example

If you have string values:

Select FieldX from TableY where FieldZ in ($parentValues.get(0).prefix("'").suffix("'").serialize(","))

Regards

Cyrille