topic Re: |dbxquery query=&quot;SELECT DISTINCT last_name FROM hr.employees&quot; connection=&quot;ORCL_PDB1_CONN&quot; in Splunk Search https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498612#M194904 <P>Your admin should have disabled all <CODE>realtime</CODE>; it is nothing but trouble. Do not use <CODE>realtime</CODE> with this command. The timepicker is ignored anyway.</P> Sat, 21 Mar 2020 16:19:14 GMT woodcock 2020-03-21T16:19:14Z |dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN" https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498610#M194902 <P>Building a Dashboard dropdown. <BR /> 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:<BR /> Error in 'dbxquery command'. This command is not supported in realtime search.</P> <P>the query is ...<BR /> |dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN"<BR /> Using SPLUNK DB COnnect APP</P> <P>In advance, thanks for you comments/insights and assistance.</P> Wed, 30 Sep 2020 04:40:30 GMT https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498610#M194902 jaxxsplunk 2020-09-30T04:40:30Z Re: |dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN" https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498611#M194903 <P>Use a non-realtime timerange for dbxquery.</P> Sat, 21 Mar 2020 16:01:37 GMT https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498611#M194903 martin_mueller 2020-03-21T16:01:37Z Re: |dbxquery query="SELECT DISTINCT last_name FROM hr.employees" connection="ORCL_PDB1_CONN" https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498612#M194904 <P>Your admin should have disabled all <CODE>realtime</CODE>; it is nothing but trouble. Do not use <CODE>realtime</CODE> with this command. The timepicker is ignored anyway.</P> Sat, 21 Mar 2020 16:19:14 GMT https://community.splunk.com/t5/Splunk-Search/dbxquery-query-quot-SELECT-DISTINCT-last-name-FROM-hr-employees/m-p/498612#M194904 woodcock 2020-03-21T16:19:14Z