Uploaded image for project: 'Jira Service Management Cloud'
  1. Jira Service Management Cloud
  2. JSDCLOUD-17994

The filter does not return any data when using Advanced search in data manager for grouping 'Within last X days' if some data contains a very old date.

XMLWordPrintable

      Issue Summary

      The filter does not return any data when using Advanced search in data manager for grouping 'Within last X days' if some data contains a very old date.

      Steps to Reproduce

      1. Use the Intune adapter to bring data into Data Manager.
      2. For a date field, enter date ina string format like '0001-01-01 00:00:00:000'
      3. Use a transform function in the adapter to convert the date to the correct format. This would convert it as Jan 1, 1, 12:00:00 AM which is correct
      4. Use the Advanced search now and add the condition 'LastScandate' to be 'Within the last X days' for 'Any'

      Expected Results

      It should return the data for the number of days selected.

      Actual Results

      It comes back blank.

      Workaround

      Will update

              Unassigned Unassigned
              2988a663b0a1 Christal Rodrigues
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: