04.View Tickets

This page will allow users to view their tickets as a list. Also be able to view a single ticket with all the information visible.

Each ticket has a readonly property , Archived (True/False), that can be used to filter about the pending and completed ticket.
The reason is that different task_status can be used to reach a completed state. The field archived will be filled based on the task_status.

Displaying Ticket list

GET ~/api/TaskView

Applying filtering using Odata

You can implement small filtering easily with OData queries. Here`s some samples.

List all pending tickets (not archived):

GET ~/api/TaskView?$filter=archived+eq+false

Getting Tickets belongs to specific Task Type :

GET ~/api/TaskView?$filter=task_type_id+eq+9f20ec69-7c0e-4f7f-84f6-420ce312b1c6

Displaying single ticket

Grab user selected task.id from the list to show that task.

GET ~/api/TaskView(task_id)

Displaying Documents attached with Tickets

This query is done db dDbFileView where you specify that you wants all document linked to your task (table_name=task) and giving the object id with the params id_in_table.

GET ~/api/DbFileView?$filter=db_table_name+eq+'task'+and+id_in_table+eq+%Your_Task.id%

Be aware the query on DbFileView didn't return you the content of the file. For that, you need to make one distinct call on DbFileView/GetFileThumbnail