### Additional Filter

Additional filter conditions can be used to filter the SQL language. You can enter subqueries.

In an additional filter, the following fields:

Numeric fields:
[CreatorId], [EditorId], [Hours], [Id], [ParentId], [Path], [Price], [PriorityId], [ServiceId], [ServiceStageId], [StatusId], [ReactionTime], [ReactionTimeFact], [ResolutionTime], [ResolutionTimeFact]
Text fields:
[Categories], [Comment], [Coordinators], [Description], [Executors], [Name], [Participants]
Date/Time fields (in form "yyyy-mm-dd hh: mm"):
[Changed], [Closed], [Created], [Deadline], [LastDeadLineChangedInPause], [LastStatusChangedDate], [ReactionDate], [ReactionDateFact], [ResolutionDateFact]
Boolean fields:
[Escalated], [MassIncidents], [ReactionOverdue], [ResolutionOverdue]

Additional filters can independently specify the report parameters.

For example:

1. We derive all the records in which the Id field is not equal to 1:

[Id]!=1

2. We derive all the records in which field contains the string field Categories "Layout" :

[Categories] LIKE 'Layout'

You can use several conditions:

3. We derive all the records in which field contains the string field Categories "Layout" and whose Id field is not equal to 1:

[Categories] LIKE 'Layout'; [Id]!=1

4. We derive all requests in the status "Open" or "In Process" and at the same time run Today or Tomorrow:

[StatusId]=1 OR [StatusId]=7; ([Deadline] BETWEEN (DATENAME(year,GetDate())+'-'+DATENAME(month,GetDate())+'-'+DATENAME(day,GetDate())+' '+'00:00:00') AND (DATENAME(year,GetDate())+'-'+DATENAME(month,GetDate())+'-'+DATENAME(day,GetDate())+' '+'23:59:59')) OR ([Deadline] BETWEEN DATEADD(day,1,DATENAME(year,GetDate())+'-'+DATENAME(month,GetDate())+'-'+DATENAME(day,GetDate())+' '+'00:00:00') AND DATEADD(day,1,DATENAME(year,GetDate())+'-'+DATENAME(month,GetDate())+'-'+DATENAME(day,GetDate())+' '+'23:59:59'));