Karlis,
Thanks for the quick response.
Yes, the list of filters would be what I would want.
Also, it would be nice to be able to specify/mark an ID col in the MetaData
part of the json, that way, the data structure of the event could also
include the id’s of the rows instead of the content of the rows.
This would allow us to
Save the filter applied so we can re-apply it later.
Quickly filter our dataset by the list of id’s so we can update our page.
Example event data structure
{
filters: [
{ col: "StartDate", op: "gte", val: "2010-01-01T00:00:00Z" },
{ col: "StartDate", op: "lt", val: "2016-01-01T00:00:00Z" },
{ col: "*", op: "contains", val: "full-text-search" },
{ col: "Category", op: "eq", val: "Cat1" },
{ col: "Category", op: "neq", val: "Cat2" },
],
ids : [1,2,4,11,100]
}
Example meta data with ID/Key column defined.
{
"Store Number": {
"id" : true,
"indexRaw": 1,
"indexDate": 0,
"indexNumber": 0,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "Store Number",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
"Store Name": {
"id" : false,
"indexRaw": 1,
"indexDate": 0,
"indexNumber": 0,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "Store Name",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
"Zip Code": {
"id" : false,
"indexRaw": 5,
"indexDate": 0,
"indexNumber": 0,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "Zip Code",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
"Region Name": {
"id" : false,
"indexRaw": 6,
"indexDate": 0,
"indexNumber": 0,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "Region Name",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
"21-LUMBER": {
"id" : false,
"indexRaw": 7,
"indexDate": 0,
"indexNumber": 1,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "21-LUMBER",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
"22-BUILDING MATERIALS": {
"indexRaw": 8,
"indexDate": 0,
"indexNumber": 2,
"indexLatitude": 0,
"indexLongitude": 0,
"existsPercentage": 0,
"column": "22-BUILDING MATERIALS",
"comment": null,
"date": null,
"hidden": false,
"value": null,
"coordinates": null,
"valuePercentage": 0,
"datePercentage": 0,
"coordinatesPercentage": 0,
"special": false
},
}
Thanks
Rick