Custom filters with range instead of all values

Archived from the Xataface Users forum.

Gwynnbleid1 — Wed Oct 31, 2012 4:22 am

Hi again.

Sorry for this questions but ideas are coming into my head constantly I have a column in a table which displays average temperatures. I would like to place a filter on this column, but with range instead of values. Something like:
5-10
11-20

or > 20 and < 25

Is it possible ?

---

shannah — Wed Oct 31, 2012 7:40 am

Not via the filters feature. However, you can manually filter using the column-header search feature (i.e. if you click on the column header, it will make a search field appear), then you can use Xataface search conventions for searching ranges. E.g. “5..10” to match values between 5 and 10 inclusive.

-Steve

---

Gwynnbleid1 — Wed Oct 31, 2012 7:51 am

shannah wrote:Not via the filters feature. However, you can manually filter using the column-header search feature (i.e. if you click on the column header, it will make a search field appear), then you can use Xataface search conventions for searching ranges. E.g. “5..10” to match values between 5 and 10 inclusive.

-Steve

When I click column header table gets sorted by that column. No search feature there ?

---

shannah — Wed Oct 31, 2012 7:56 am

Try not to click on the header text… click on the background of the header.

---

Gwynnbleid1 — Thu Nov 01, 2012 8:38 am

Still nothing. Mayby because I use 1.3 ver ?

---

shannah — Thu Nov 01, 2012 8:48 am

Hmm… It’s possible that this didn’t get added until 2.0…

---

m23k — Thu Nov 01, 2012 9:11 am

Looks like a 2.0 feature, not seeing it here either (sounds handy though!).