Archive
Highlighted

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

New Member

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 lastname FROM hr.employees" connection="ORCLPDB1_CONN"
Using SPLUNK DB COnnect APP

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

Tags (1)
0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

Use a non-realtime timerange for dbxquery.

0 Karma
Highlighted

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

Esteemed Legend

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

0 Karma