Advanced Filter

Watch Queries with AdvancedFilter

Usage

Get IEasyProfilerBaseService<ProfilerDbContext> From Dependency Injection.

var queryProfilers = await easyProfilerService.AdvancedFilterAsync(new AdvancedFilterModel()
{
    CombineWith = CombineType.Or,
    Duration = new Range<TimeSpan> { Max = TimeSpan.MaxValue, Min = TimeSpan.MinValue},
    Page = 1,
    PerPage = 15,
    Query = "Select", // <---- Contains
    SortBy = Sorting.Descending, // <---  Default value Sorting.Descending,
    Sort = "Duration" // <--- Default value "Duration"
});

Response

[
  {
    "query": "SELECT [c].[CustomerId], [c].[CreateDate], [c].[Name], [c].[Surname]\r\nFROM [Customers] AS [c]",
    "duration": {
      "ticks": 8737783,
      "days": 0,
      "hours": 0,
      "milliseconds": 873,
      "minutes": 0,
      "seconds": 0,
      "totalDays": 0.000010113174768518518,
      "totalHours": 0.00024271619444444446,
      "totalMilliseconds": 873.7783,
      "totalMinutes": 0.014562971666666667,
      "totalSeconds": 0.8737783
    },
    "id": "c06cae66-3dd1-4e34-810c-498c979a5c6a"
  }
]