nFeed users: What is the SQL for Component?

[Jonathan Smith]

Hello all!

  I have 2 nfeed sub fields that populate values based on the selection in nfeed field project category.

• nfeed field 1: Project category
• nfeed field 2: Project sub category
• nfeed field 3: Project 3rd category

My current setup works... but if I wanted to utilize components for Project category, what would be the code in the WHERE statement below?

Select [SubcategoryValue]
FROM [dbo].[ProjectCategory] PC
LEFT JOIN [dbo].[SubCategory] SC
ON PC.ProjectCategoryID=SC.ProjectCategoryID
WHERE PC.ProjectCategory= '$issue.customfield_11330'

I essentially want to replace the nfeed custom field id with the value in the component field.

Thanks,

Jonathan

[Nicolas Esteves]

Hi @Jonathan Smith

I think what you want is a query like that:

Select [SubcategoryValue]
FROM [dbo].[ProjectCategory] PC
LEFT JOIN [dbo].[SubCategory] SC
ON PC.ProjectCategoryID=SC.ProjectCategoryID
WHERE PC.ProjectCategory in ($issue.components.stringList())

Do you confirm?

Kind regards,