CMDBuild Forum

Syntax error when filtering

Systems Engineering
#1

Hello,
Please can you help me ? this syntax does’t work

from SWCategoryType where Id in (/(select “CategoryType2” from “SWCatalogue” where “Status”=‘A’ and “Brand”={client:Brand})/)

thanks

#2

Not sure if that’s PostgreSQL, but the syntax looks wrong to me, again I´m no savvy on DBs or programing.

here is an example:
SELECT “CategoryType”, “SWCatalogue”
FROM SWCategoryType
WHERE “Status” = ‘A’

Looks like you have two different tables, you will need to use a “Join” clause and a “group by”, there is a lot of information on the postgresql site.

#3

Thank you for your help