Problem with flexible query

[Former Member]

Hi,

I am getting empty result with below query ,but entries are available with these parameters.

            SELECT {customer:pk} FROM {B2BCustomer AS customer JOIN PrincipalGroupRelation AS pg ON {customer:pk}={pg:source} JOIN UserRole AS ur ON {pg:target}={ur:pk} JOIN UserTypeEnum AS userTypeEnum ON {customer:userType}={userTypeEnum:PK} JOIN B2BUnit AS bu ON {pg:target}={bu:pk} } WHERE {userTypeEnum:code}='CUSTOMER' AND {bu:uid} IN ('TCSUK', 'TCSIndia') AND {ur:uid}='marketing'

Any issues with these query? please help.

[Former Member]

Hi

Did you got the result while running the above query in hac? or the issue is while executing through code. If it is code then check if there is any search restrictions. You can also disable the search restrictions

Thanks

[Former Member]

hi,
you need to grant user the appropriate permissions if query contains b2bUnit .

[VinayKumarS]

query looks correct for me. i am not sure which database you are using.. if it is oracle then please check the case sensitive data... especially the data can u check in the database which is in where condition