| Parameters |
{
"adhoc_filters": [
{
"clause": "WHERE",
"comparator": [
"OB12026016875"
],
"expressionType": "SIMPLE",
"filterOptionName": "a47a4d0b-2ea2-49d8-b5bc-067ca875ccad",
"operator": "in",
"subject": "ORDER_BOOK_NO"
},
{
"clause": "WHERE",
"comparator": [
"CMP013"
],
"expressionType": "SIMPLE",
"filterOptionName": "b93b7d0a-c20a-4a01-8857-1ef5bfdae6c0",
"operator": "in",
"subject": "COMPONENT_CODE"
}
],
"align_pn": false,
"all_columns": [
"ORDER_BOOK_NO",
"ORDR_BK_VRSN",
"COMPONENT_CODE",
"INSTALLMENT_NO",
"DUE_DATE",
"BASE_FEE",
"DISCOUNT_FEE",
"PAYABLE_AMOUNT",
"PAID_AMOUNT",
"PAID_DATE",
"PAYMENT_STATUS",
"CURRENCYCODE",
"RECIEPT_NO",
"ACTIVE",
"SRC_ICD",
"DST_ICD",
"CREATED_ON",
"CREATED_BY",
"CHANGED_ON",
"CHANGED_BY",
"serverip",
"clientip",
"countryname",
"createdon_gmt",
"changedon_gmt",
"INR_BASE_FEE",
"INR_DISCOUNT_FEE",
"INR_PAYBLE_AMOUNT",
"INR_PAID_AMOUNT",
"EXCHANGE_RATE",
"DUE_DATE_UTC",
"ORG_ID",
"ParentOrgId",
"Location",
"Theme",
"Currency",
"Locale",
"TimeZone",
"LastUpdatedon"
],
"color_pn": true,
"datasource": "1680__table",
"granularity_sqla": "DUE_DATE",
"groupby": [],
"include_search": false,
"include_time": false,
"metrics": [],
"order_by_cols": [
"[\"INSTALLMENT_NO\", false]"
],
"order_desc": true,
"page_length": 0,
"percent_metrics": [],
"row_limit": 1000,
"slice_id": 2763,
"table_filter": false,
"table_timestamp_format": "%Y-%m-%d %H:%M:%S",
"time_grain_sqla": "P1D",
"time_range": "100 years ago : ",
"timeseries_limit_metric": null,
"viz_type": "table"
}
|
