I have been trying to figure this out. I am using the dbx module to do a sql lookup that creates a table, this part works...then, when you click on an entry in that table, another sql is executed using the value you clicked ($click.value$) as part of the next sql. I have been looking at various UI examples, then found that the DBinfo view of dbx itself is seemingly pretty close..so i started over, using that as the starting point and started replacing things to get what i need. back to having the initial sql work, but when i try to click on a result, the second sql is adding "search " before the | mysqlquery which does not work. tried removing and moving things...still cannot get this do do what i want. any help would be greatly appreciated.
here is my current XML:
Broker Supported Countries Lookup
*
False
1
dashboard
This is the exact same config, except we render into an interactive table instead of an interactive chart. Since the search in the table has no 'split-by' data, we configure the table with the 'row' highlighting rather than full on 'cell' highlighting, so as to not to confuse our users. Please Click on a Broker Name to get the supported country list.
| mysqlquery spec="forexpert" query="select distinct(b.name) from Broker b join BrokerCountryCode bcc on bcc.broker_id=b.id where bcc.supported=true and bcc.visible=true;"
-1h
bar
none
row
results
results
Supported Countries for $click.value$
| mysqlquery spec="forexpert" query="select distinct(b.name) from Broker b join BrokerCountryCode bcc on bcc.`broker_id`=b.id where b.name = $click.value$ and bcc.`supported`=true and bcc.`visible`=true;"
-1h
addterm
$click.value$
indexed
line
none
none
none
100%
160px
yeah, i did remove that at one point and it did put it at the end, but what i am tring to get it to do it to populate the $click.value$ in the second mysql query rather than add a pipe and the value at the end. basically i want my second search as it is sent to splunk to look like this (assuming that i have clicked on the word "HELP":
| mysqlquery spec="forexpert" query="select distinct(b.name) from Broker b join BrokerCountryCode bcc on bcc. broker_id =b.id where b.name = HELP and bcc. supported =true and bcc. visible =true;
when i do what you suggest i get something similar to this:
None | mysqlquery spec="forexpert" query="select distinct(b.name) from Broker b join BrokerCountryCode bcc on bcc. broker_id =b.id where b.name = $click.value$ and bcc. supported =true and bcc. visible =true; | series="HELP"
on that.. 2 things:
does that "None" that is prepended get ignored?
how can i get that HELP replacement in to my sql query?
... View more