|dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN"

[jaxxsplunk]

Building a Dashboard dropdown.
The following query works fine and there are no duplicates in the resultset however the dashboard filter has the message "Duplicates values causing conflict". When I hover over this message a pop up show the following:
Error in 'dbxquery command'. This command is not supported in realtime search.

the query is ...
|dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN"
Using SPLUNK DB COnnect APP

In advance, thanks for you comments/insights and assistance.

[woodcock]

Your admin should have disabled all realtime; it is nothing but trouble. Do not use realtime with this command. The timepicker is ignored anyway.

[martin_mueller]

Use a non-realtime timerange for dbxquery.