Alternative to Database.search()

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: Alternative to Database.search()

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5.2

Reproducible: Always

Hi everyone,
I have a widget that shows documents based from the username. Ex.
Username = Pedro Penduko
Document Field = pedro.penduko@pinoymovies.com,enteng.kabisote@pinoymovies.com

Here's a partial code.
String processor = session.getCommonUserName();
StringBuilder builder = new StringBuilder();
builder.setLength(0);
// change processor to email format code here. Ex. Pedro Penduko to pedro.penduko
builder.append("Form = \"Pending\" & AppName = \"someApp\" & @Contains(@Lowercase(Processor); @Lowercase(\""); builder.append(processor); builder.append("\"))");
DocumentCollection coll = ctlDB.search(builder.toString());

I tried getAllDocumentsByKey() but the problem is Lotus Notes only does first initial match.

Is there a way I can use contains on getAllDocumentsByKey rather that just first initial match?

Regards,
Philip

Feedback number WEBB8NE4WF created by ~Tate Desfreekonyings on 11/08/2011

Status: Open
Comments: