Hi all,
I was exploring running reports on remote tables in my PDI and encountered a problem on it. I like to see if anyone faced this problem before and what workaround did you use.
The problem I encounter is that that a score type report on a remote table doesn't return any results when I apply a filter condition.
Details about the findings: I created a remote table that retrieves records from the incident table (just for testing)
And ran a single-score report on this table, all is fine, when I ran it without a filter - example below.
But the moment i add a filter, a filter that will always return true, it doesn't return any records no matter which aggregation i used - example below.
A bit more poking around reveals that it seems to affect the score type reports, a normal list type report runs fine with the same filter conditions - example below.
Also, running a score type report on a standard non-remote table, for example, the incident table, does not have the same issue when there are filter conditions.
The current work around I can think of is control the filter in the remote table definition instead of the report filter conditions. Not the most ideal as this would mean that if I require multiple score type reports on the same table with different filter conditions, I will need to create different remote tables and its definitions to achieve this.
I am unable to find this behavior for remote tables in ServiceNow's docs or knowledge articles, so I will appreciate it if any one have any official information about this!
Regards,
Wei
Without count it is 1:
The screenshot of count with '0' records was because i was trying out all aggregation types, and happened to take a screenshot when it was on 'count.
With the condition filter, i should be expecting 1 records also, but it is showing 0 records
Currently, I have applied a filter within the remote table definition directly, so in the list view it shows 1 record, with or without the filter that will evaluate to true.
Without filter:
With filter:
