Subscribe via Feed
, Aug 19, 2010 1:19:49 PM
9 responses to XPages multi-column filtering using a vector of non-categorized columns
Dick Stagnone, September 16, 2010 12:22 PM
Thank you for following up and providing this post. I will review it and share it with my team.
Ravi, September 12, 2010 4:54 PM
Thanks for the nice article. I tried implementing this code. I downloaded the application from openntf and copied the code provided to an xpage. But when I try to open the xpage, I get an error "Item not found exception". I am using 8.5.2 Client and server. All the other examples work fine in the application. What could be the probable reason?
Fredrik Stöckel, August 22, 2010 6:43 PM
Paul Hannan, August 22, 2010 6:19 PM
@Fredrik - the Multiple Category filter enhancement request is already in there - PHAN86FKHY - I might just tag in the multiple 'keys' there too with the multiple categoryFilter request. They're more or less in the same boat.
Fredrik Stöckel, August 22, 2010 4:24 PM
+1 on the "multiple category" filter enhancement :)
Paul Hannan, August 20, 2010 5:44 PM
Haven't tried it but I reckon it won't work. Right now it would fail - it won't find one match on the column and then continue down the column to get the next and so on. At best it would look for a match on the next column.
So it's an enhancement request. And this kinda falls into the multiple category filter (which I'd like to see ) enhancement request.
Can this be done in the eXtAPI and eXtLib? If you can do it that will save us a lot of trouble... ;-)
Nathan T. Freeman, August 19, 2010 9:34 PM
Paul, if one element of the Vector is itself a Vector or an array, can I get multiple value matches for that column? So, say...
Would that work?
If not, consider it an enhancement request. And one that I might even simply fulfill in the Extensibility Library. :-)
Paul Hannan, August 19, 2010 6:27 PM
Yes that will work in the sample above.
It'll also return if you just select something the 2nd and 3rd option and leaving the first null something will be filtered as long as something exists - but it may not return what you expect at first glance.
If you choose to filter the view by the 3rd option in the vector it will return the first find as it depends on the sorting of the preceding two columns. So a health warning I guess.
Sean Cull, August 19, 2010 4:10 PM
Paul, am i correct in thinking the filters need to be used sequentially ?
Can you choose to use filters 1 and 3 only ?