I am trying to run a FT serach using the JSP Tags with Domino 6…I can access a view on this server and simply iterate thru the view, but now I want to get a subset of docs for display.
The help file for the ftsearch tag is not very detailed nor does it have an example. All I want to do is find all docs where the Subject field starts with the “@” symbol.
I tried the following:
<domino:session id=“dSession” host=“www2.mhflaptop.com” user=“Administrator” password=“redskins”>
<domino:db id=“db” dbname=“help\help6_designer.nsf”>
<domino:ftsearch query=“@Left(Subject;1)="@"” max=“50”>
</domino:ftsearch>
just to see if I could get a ftsearch to return values. However, when I try to run the JSP I get the following in the browser…
"Error 500: Unable to read documents in the database. Check ACL: current level- ‘Editor access’. "
Any ideas where I may be going wrong. It sure would help if IBM provided better examples for these JSP tags.
Subject: JSP FT Search
The query attribute of the domino:ftsearch is simply the text you are searching for, “@” in your case, and not an expression that will be evaluated on the server.
It is designed to give you the functionality you get in the Notes client when you do a Search, and supply a simple string to search for. It won’t be limited to the values in just one field. Your search is more specific, and you have a number of choices on how to implement it.
There’s always brute force: Your jsp could iterate the view contents itself, checking for Subject fields which start with the “@” symbol, and possibly paginate the results.
You could get Notesy, use a formula in the view selection that will look for the “@”. There’s bound to be many more ways to skin this cat.
-sl
Subject: RE: JSP FT Search
Thanks for the help - I appreciate it…I think creating a view to extract the data in need is likely the best approach for my application.