I love the OEM-Grafana App and the Dashboards ! I have some Custom-Repository time-series queries in panels which return datasets that are being limited to 10 metrics and they are always ordered and displayed alphabetically on metric . How can increase this array ceiling to say 20 and alter the sort order based on value rather than metric string-values A-Z order ? I have tried all sorts of things by obviously adjusting the order by in query and adjusting Application API restful property settings on OMS but nothing alters the 10 limit.
basic example:
select rollup_timestamp as time_sec, average as value , key_value as metric
from sysman.mgmt$metric_daily a, sysman.mgmt$target b
where b.target_name = $oem_gf_target_name
and b.target_guid=a.target_guid
and a.metric_column = 'spaceAllocated'
and a.metric_name='tbspAllocation'
ORDER BY 1 ASC;
If I have more than 10 tablespaces in my database then I only see the first 10 in A-Z tablespace-name order.
This the query inspector perspective :
Object
request:Object
url:"api/datasources/proxy/159/em/websvcs/restful/grafana/v1/query"
data:Object
range:Object
targets:Array[1]
isRemoteConnection:false
method:"POST"
response:Array[10] <--- How to change this and how to change order to sort on value rather than metric?
0:Object
target:"BMFDATA"
datapoints:Array[6]
1:Object
target:"EXAMPLES"
datapoints:Array[6]
2:Object
target:"IOPS"
datapoints:Array[6]
3:Object
target:"SCOTT_ARCHIVE"
datapoints:Array[2]
4:Object
target:"SDBA_DATA"
datapoints:Array[6]
5:Object
target:"SDBA_IDX"
datapoints:Array[6]
6:Object
target:"SYSAUX"
datapoints:Array[6]
7:Object
target:"SYSTEM"
datapoints:Array[6]
8:Object
target:"TEMP"
datapoints:Array[6]
9:Object
target:"TPCCTAB"
datapoints:Array[6]
( I have another few tablelspaces with tablespace-names not being included in returnset )
Many thanks for any insight/assistance you can offer. Brett