Ticket count

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



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