Help with Ticket Lister filter DepartmentId

[clazo91]

Hello, sorry for bring up another trouble,
following this topic:

Hopefully a Quckie Question - Re: Ticket Lister Filter

Hi Sorry for another question… I would like to add a filter to a Ticket Lister Widget to only display tickets from one particular Entity please advise what the syntax is that I need to enter. I have a Table Entity called ‘Takeaway’ and want to list all tickets for that entity Thanks as always Rob

i’m trying to filter only ticket from my 2nd department (Take Away):
here the setup:

i hope somebody can tell which mistake i did, because still not working properly.

thanks
Claudio

[QMcKay]

What isn’t working properly? Is it displaying the wrong Tickets, or is it not displaying Tickets at all?

It may be that your Take Away DepartmentId is not actually 2. It could be 3, or 4, or another integer. The only way to know for certain is to look at the [Departments] table in the DB.

[arslan]

Open SQL Management
and Follow this Setup and check Department ID

[clazo91]

Thank you!! the Ticket lister was not showing any tickets at all, i checked the DB tables (now i know what are those…), the DepartmentId was 3!

thank you again!!