Hi everyone,
Advanced filtering is now live on heatpumpmonitor.org - here’s what’s new!
-
Additional filtering operators
-
New side panel for viewing and editing filters
- Search or look up filter fields/columns
- Choose an operator
- Enter or select values
- Define ranges (using two filters - greater than X, less than Y)
- Enable/disable filters
- Edit/delete filters
- Share filters via URL - all parameters encoded in the URL & “filter” field
-
Backwards compatible with the original “filter” string
Additional operators
There is one additional text operator:
- Does not contain (
ne)
The additional numeric operators are:
- Greater than (
gt) - Less than (
lt) - Greater than or equal (
gte) - Less than or equal (
lte) - Not equal (
ne)
Anything else defaults to equals (the original behaviour).
The format is backwards compatible and works in URLs:
- all previous query strings will work as before
- mixed default (equals) and new operator:
query:hp_output:5:gt,UFH:0(output to be greater than 5, UFH quals to 0)
Other examples:
query:hp_output:5:gt,UFH:0,old_radiators:1,combined_cop:4:lt,combined_cop:3:gtquery:hp_output:5:gt,UFH:0,old_radiators:1,combined_cop:4:lt,combined_cop:3:gt,combined_flowT_mean:35:lt
You can also specify ranges, e.g.:
query:combined_flowT_mean:35:lt,combined_flowT_mean:33:gt
New “Filters” panel (here is a view without any filters - notice the “Filters” box below “Add fields”):
Adding a new filter (after pressing the big “+” button; selecting a column using a dropdown or typing in the name)
Entering a value (typing it in or picking up an existing value)
Viewing active filters
Editing an existing filter (after pressing the yellow edit button)
Disabling a filter (using the checkbox)
That’s all I think.
Big shoutout to the team for building such a solid foundation and making heatpumpmonitor.org so easy to extend!
Please give it a try and let us know what you think! Keen to hear your feedback and ideas for improvements.
Kind regards,
Kamil
