Hello,
I am using the below data set , and i am generating the cockpit and getting graph through ,but while passing parameters its not working
SELECT 'Single' graphType,DATE_FORMAT(oreg_order_date,'%Y-%m') monthyear,SUM(oreg_order_value) OrderValue FROM crm_sale_order_registration
WHERE oreg_status>0 AND oreg_order_type NOT IN (5) AND oreg_order_date BETWEEN $P{endDate} AND $P{startDate}
GROUP BY YEAR(oreg_order_date),MONTH(oreg_order_date) ORDER BY oreg_order_date;
and my sdk is below
Sbi.sdk.api.injectDocument({
documentLabel: 'test'
, executionRole: '/knowage/user',
parameters: {startDate:'2019-01-01',endDate: '2018-05-01'}
,target: 'sales'
, displayToolbar: true
, displaySliders: false
, iframe: {
style: 'border: 0px;'
},
useExtUI: true
});
