RE:QueryView: change SelectionQuery in XPages

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

Hi Tim and thanks for your hint!

excuse my ingorance in xpages developing, i'm totally a newbie in this world..

the point I don't understand is if is there some way to work with the property "selectionQuery" of the view used in the datasource of my ViewPanel (or repeat, or Data table).

My situation is:
I'm ve got a query view called "qvUser" with a selectionQuery = "SELECT * FROM DBDB2.MYDAV"; this fetch more than 100.000 records...

With LS, to get quick response, i used to do this:
<< LS CODE >>
v = db.getView("qvUser")
v.selectionQuery = "SELECT * FROM DBDB2.MYDAV WHERE FIELD1 = '" & param1 & "'"
v.Refresh()
<< END LS CODE >>
i do this everytime i do a search in the view.

Now with xPages i'd like to do the same:
suppose a editable textbox in the top used as search field.
Underneath i've got a Data Table which displays all the data from the view "QVUser".
I want to automatically update the Data Table when the user type the search term.

I don't know how to change the selectionQuery from inside the xPage and then reload the Data Table...
Do you know if anyone already did it, and if i can find some nsf to study as example ?

Thank you very much for your time !!

Marco

Feedback response number WEBB7V4DUH created by ~Holly Cisreburoden on 08/20/2009