I created a query under knowledge management to help people searching through the DB. I put many criteria "prompt by user". One of those is to search by Category - Is equal to Category - prompt user. I use "is equal to category" since I have many category level, and using this option allow me to select first level category and it give all the sublevel category in this main category. This option works pretty well under incident, problem, request. But under Knowledge Management, I got this error when I select any category :
The multi-part identifier "T17.im_guid" could not be bound.
When I logged as SA, I don't get this error.
Anyone know what the issue might be?