MySQLSyntaxErrorException: Unknown column 'session.salesApplication' in 'where clause'

[former_member734029]

I have a requirement to apply a restriction on Products that if a particular customer with a with a specific authentication hits product by product endpoint , provide them products(approved or unaproved)". I have set "salesApplication" attribute in session and created search restriction query like {approvalStatus} = Approved or ({approvalStatus} = UnApproved and IN (?session.salesApplication))

while hitting the endpoint i am getting error MySQLSyntaxErrorException: Unknown column 'session.salesApplication' in 'where clause'

Any suggestion will be helpful.

Thanks.

[Former Member]

I think is right, but also are you sure that "{approvalStatus} = Approved" is correct? I would expect that "Approved" should be a primary key or it should be surrounded by "'".

For example: {approvalStatus} = 'Approved' Or {approvalStatus} = 999999999

Replace 999999999 with the proper primary key of the status Approved.

[Former Member]

Hi Anurag, Could please check your query something wrong i think the both "AND IN" will not come one after another before "IN" you missed some attribute name

thanks , prabhakar