Visualize: Ad Hoc View Filter Parameters
HTML
<script src="http://code.jquery.com/jquery-2.1.0.js"></script>
<script src="https://mobiledemo.jaspersoft.com/jasperserver-pro/client/visualize.js"></script>
<!--Provide container to render your visualization-->
<div id="container"></div>
CSS
#container {
height: 400px;
margin-left: 10px;
}
/*Start of Crosstab specific styles*/
/*Crosstab side panel*/
#container .jr-mDatatable-cellRowlabel.jr-mDatatable-cellField.jr {
background-color: #E0D2BC;
font-weight: bold;
color: black;
}
/*Crosstab totals section in side panel*/
#container .jr-mDatatable-cell.jr-mDatatable-cellRowlabel.jr.jr-mDatatable-cellTotal {
background-color: #E0D2BD;
border: 1px solid #c19a83;
}
/*Crosstab totals in main table - even row*/
#container .jr-mDatatable-rowEven.jr .jr-mDatatable-cell.jr-mDatatable-cellValue.jr-mDatatable-cellTotal.jr {
background-color: #e8dcd0;
border: 1px solid #ad795b;
}
/*Crosstab totals in main table - odd row*/
#container .jr-mDatatable-rowOdd.jr .jr-mDatatable-cell.jr-mDatatable-cellValue.jr-mDatatable-cellTotal.jr {
background-color: #e8dcd0;
border: 1px solid #ad795b;
}
/*Crosstab value in main table - odd row*/
#container .jr-mDatatable-rowOdd.jr .jr-mDatatable-cell.jr-mDatatable-cellValue.jr {
background-color: #F0E9E0;
border: 1px solid #ad795b;
}
/*Crosstab value in main table - even row*/
#container .jr-mDatatable-rowEven.jr .jr-mDatatable-cell.jr-mDatatable-cellValue.jr {
background-color: #F0E9E0;
border: 1px solid #ad795b;
}
/*Table styles*/
/*Datatable headers*/
#container .jr-mDatatable-header.jr .jr-mDatatable-row.jr .jr-mDatatable-cell.jr {
background-color: #8e5f40;
font-size: 1.24em;
font-weight: bold;
color: white;
}
/*Header for cell text*/
#container .jr-mDatatable-header.jr .jr-mDatatable-row.jr .jr-mDatatable-cell-text {
padding-top: .30em;
}
/*Header for cell numbers*/
#container .jr-mDatatable-header.jr .jr-mDatatable-row.jr .jr-mDatatable-cell-number {
padding-top: .60em;
}
/*Datatable cells*/
#container .jr-mDatatable-cell.jr {
color: black;
font-size: 1.14em;
border: none;
}
/*Datatable text style*/
#container .jr-mDatatable-cell-text.jr {
line-height: 25px;
}
/*Datatable odd row*/
#container...
JavaScript
visualize({
auth: {
name: "joeuser",
password: "joeuser"
}
}, function(v) {
var adv
function renderView() {
adv = v.adhocView({
resource: "/public/viz/Adhoc/Product_Sales1",
container: "#container",
success: function() {
//use to find available params (filters) for ad hoc view
console.log(adv.data().metadata.inputParameters);
},
//control ad hoc view parameters
params: {
product_category_1: ["Hot Beverages", "Bread"]
},
error: function() {
alert("error");
console.log(arguments);
}
});
}
//render initial view
renderView();
});