Notes/Domino XPages Development Forum - Filtering view works only on first column???

~Alexis Opresaman

Nov 1, 2011, 7:39 AM

129 Posts

Re: Filtering view works only on first column???

Filter works more or less like NotesView.getAllEntriesByKey without exact match.

E.g.

someView.getAllEntriesByKey( "f", false ) -> returns all entries starting with the letter f.

It sounds like the search property might be what you're looking for. search works like NotesView.FTSearch.

~Autumn Kigeroburakoi

Nov 1, 2011, 9:04 AM

19 Posts

Re: Filtering view works only on first column???

Thank you Tommy for your reply. You were right. I could filter the view by search in all columns by "search".... but I still don't get how to search for example value "x" only in column2 and value "y" only in column 3.

Or maybe in NotesView.FTSearch I can give a query to search in a certain column... I will try that... be back soon.

~Anita Minasterings

Nov 1, 2011, 3:22 PM

298 Posts

*you can't filter on multiple columns, only the first sorted column

~Sanjay Minresaski

Nov 1, 2011, 9:43 AM

31 Posts

Re: Filtering view works only on first column???

Hi,

Try searching for a specific field: [<your column fieldname>] CONTAINS "<search string>"

E.g: [Category] CONTAINS "xpages"

//Petter

~Autumn Kigeroburakoi

Nov 2, 2011, 1:25 PM

19 Posts

Re: Filtering view works only on first column???

Thank you everybody. You are all right. I am using search and it is working great. Now I have another interesting issue which I think I create a new post for it.