Dashboards & Visualizations

Query is not fully resolved in dashboard

bowesmana
SplunkTrust
SplunkTrust

I have a Simple XML dashboard which does

<form>
  <label>Admin Dashboard</label>
  <description/>
  <fieldset>
    <input type="dropdown" token="company" searchWhenChanged="true">
      <label>Select a Company:</label>
      <default>*</default>
      <choice value="*">All Companies</choice>
      <populatingSearch fieldForValue="Company" fieldForLabel="Co_Name">
        <![CDATA[ | inputlookup rich-co ]]>
      </populatingSearch>
    </input>
    <input type="time" searchWhenChanged="true">
      <label>Select a time</label>
      <default>
        <earliestTime>-7d@w0</earliestTime>
        <latestTime>@w0</latestTime>
      </default>
    </input>
  </fieldset>
  <row>
    <single>
      <searchString>sourcetype=completions_standard Company=$company$ | eval f=if("$company$"=="*","All Companies",Co_Name) | table f</searchString>
      <earliestTime>$earliest$</earliestTime>
      <latestTime>$latest$</latestTime>
    </single>
  </row>
  <row>
    <chart>
      <title>Last week's visitors to the Knowledge Centre</title>
      <searchString>sourcetype="logins_*" Company=$company$ | timechart dc(Username)</searchString>
      <earliestTime>$earliest$</earliestTime>
      <latestTime>$latest$</latestTime>
      <option name="charting.chart">area</option>
      <option name="charting.axisTitleX.visibility">visible</option>
      <option name="charting.axisTitleY.visibility">visible</option>
      <option name="charting.axisX.scale">linear</option>
      <option name="charting.axisY.scale">linear</option>
      <option name="charting.chart.nullValueMode">gaps</option>
      <option name="charting.chart.sliceCollapsingThreshold">0.01</option>
      <option name="charting.chart.stackMode">default</option>
      <option name="charting.chart.style">shiny</option>
      <option name="charting.drilldown">all</option>
      <option name="charting.layout.splitSeries">0</option>
      <option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
      <option name="charting.legend.placement">none</option>
      <option name="wrap">true</option>
      <option name="rowNumbers">false</option>
      <option name="dataOverlayMode">none</option>
      <option name="drilldown">cell</option>
      <option name="charting.axisTitleY.text">Users</option>
      <option name="charting.axisLabelsY.majorUnit">10</option>
      <option name="charting.axisTitleX.text">Date</option>
    </chart>
  </row>
</form>

When I open the dashboard, both panels have the text

Search query is not fully resolved

Any idea what's wrong?

Tags (1)
0 Karma
1 Solution

cschmidt0121
Path Finder

In Splunk known issues: "eval $foo$ tokens don't work in Simple XML, searches fail with error Search query is not fully resolved. (SPL-74498)"

Looks like it has to do with this?

eval f=if("$company$"=="*","All Companies",Co_Name) 

View solution in original post

somesoni2
Revered Legend

You can't have more than one answer. just glad things working for you.

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Not sure if you can have more than one answer, but if you can, please add your post as an answer and I will accept it.

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Ah, I just flagged cschmidt0121's reply as the answer, but now I changed the autorun to autoRun (capital R) and it works. It doesn't seem to matter about the case of true, both upper and lower case t works.

0 Karma

somesoni2
Revered Legend

Sorry, I overlooked the case.
Try changing

to
.
in autoRun, "R" is capital and in True, "T" is capital.

I tried the exact same xml of yours and its working fine (its showing no result found as I don't have data, but no error)

cschmidt0121
Path Finder

In Splunk known issues: "eval $foo$ tokens don't work in Simple XML, searches fail with error Search query is not fully resolved. (SPL-74498)"

Looks like it has to do with this?

eval f=if("$company$"=="*","All Companies",Co_Name) 

bowesmana
SplunkTrust
SplunkTrust

Yes, you're right. I removed the first panel and it still had the problem, so I changed Company=$company$ in the second panel and it fixes the problem. Thanks for that. Not a big deal, just messy.

0 Karma

bowesmana
SplunkTrust
SplunkTrust

No difference.

0 Karma

somesoni2
Revered Legend

Try changing

to
.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Free Professional Services for .conf26 Attendees

This year at .conf26, we are doing something a little different. We are bringing the best minds from ...

Defend at Machine Speed: Your Guide to Security Sessions at .conf26

Splunk .conf26   With threats moving at machine speed and attack surfaces expanding across hybrid ...

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...