FilterZen: Feedback Forum > FilterZen Filtering Numbers?
Hi Moe,
when you expand the "Advanced Filter Properties" for your filter, you have two settings to apply numericality semantics. Have you played with those?
ROXORITY
I'm assuming this is where you put the format string such as N or n, or am i mistaken? Is there any documentation around what is to be used in those two fields?
Moe
Using the regular out of the box text filter I can get that column to filter properly but of course I'm limited to equals only, I have tried equals for this too but doesn't work, If i just put a number i get no results, if i put a number followed by a comma i get few results but in the listview i see the values for my column as 0 for each row/document.
Moe
Hi Moe,
we'll give this another good look over the weekend and get back to you shortly. As for documentation, the format strings are described here. We're still working on updating our own product documentation, as the numericality is a fairly recent feature addition. You may try specifying a locale and leaving it blank again to see how the results differ.
Generally speaking: those are mostly just about how numbers are displayed, they are always sent as pure, unformatted numbers in theory and SharePoint usually always understands those properly, in theory. You may also experiment some more by enabling or disablign CAML Filtering mode (not in the filter, in the Web Part settings themselves) -- of course, if you already got as far as enabling operators other than Equals (have you?) then this recommendation is not helpful. Otherwise, give it a go. Again, we'll get back to you on this by Monday at the latest, though.
ROXORITY
Thank you very much, I find the community here to be very helpful. I will keep experimenting with it.
Moe
Quick Update: I recreated the web part by first starting with the number column and then adding the rest. For the number column it works if its equal to but fails with contains. The other two columns are still using the contains and everything is working as expected so enabling the CAML filtering isn't the problem. If anything please look into the contains filtering for number columns and that might get me closer to making it work. Thanks again.
Moe
I get it. Contains is a textual operator, not a numeric one so it never occurred to us implementing it and I'm not sure yet SharePoint will "let us" apply such a filter esp for number columns. We'll try -- and get back to you. If it won't work, you'll have to create a calculated Column reflecting the numeric Column and Contains-filter against that one instead.
ROXORITY
Hi All,
I have a quick question regarding filtering columns containing numbers, I have gotten the webpart to work with text columns just fine and its working as expected but when it comes to filtering a column that has a number format it doesn't work. numbers are about 9 digits in length so when they are displayed they are displayed in the following format 999,999,999. Is there anything that i'm missing?