Chicago
Ability to Query Arrays
Hello, first time examining this Git and I'd like to look into this. Is there are trail one could follow to look into this?
Hello @qholness, we don't have a trail, but for some background we would like the ability to display child rows in the grid view. Something like what can be found here: https://datatables.net/examples/api/row_details.html We would also like to have users be able to query these child rows as well. We still haven't determined how to implement this in our UI with different datasets. We welcome your feedback! Thanks! cc: @tomschenkjr if you would like to add anything else.
To help define the issue a bit more, here is a real scenario:
In the case of ordinance violations, people often need to search across violations. For instance, to see if there are any violations for deficient porches. Since there are many violations associated with a single record, the search would need to happen across the entire array. Also, as part of the problem landlord project, we found ourselves in a situation of searching for violations where anyone was issued citations for critical violations 3 or more times. Ideally, we should be able to search for violations that meet these sorts of criteria (violation 1 OR violation 2 OR violation 3, etc.)
I need to do a bit of research to see how deep the parent-child relationship needs to go.
Also, going to pull in @geneorama on this conversation. Another project, https://github.com/Chicago/sdp-business.json, will be introducing deeper levels of nesting that would take advantage of this.
Reopening this due to one issue found where array display on the table is "deactivated" when columns are selected/deselected.
