Ticket count

English Forum Technical
1

Hi,
for counting the total tickets in view Sql to filter the assigned tickets using filter in sql
« AND assigned_to_user = :_user_id »

if i want to count the created ticket by the user in sql what is the variable to filter based on :_user_id

Thankyou.

2

Hello

To filter the ticket which are created by specific user using sql, you can specify filter in where clause like created_by = :_user_id

Thank you