Solved

Database.search in a webservice (domino designer): need a reference

Posted on 2008-10-27
3
522 Views
Last Modified: 2013-12-18
I'm writing webservice and i need a reference on how to build a search string in domino designer. I'm doing it in java.

As an exemple, i got that one works,

DocColl=ContactDB.search("Form=\"Contact\" & LastName=\""+LastName+"\"", null, 0);

ContactDB is a Database
DocColl is a DocumentCollection
LastName is a string parameter.

So I want more detail on how it work, ex how could i get all the ones that sart with a "A"
(the TSQL equivalent to " like 'A%' ")
 

      
0
Comment
Question by:David Robitaille
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 22817174
There are many functions in the formula language. The string you have to build for searching all docs with lastname like A% would be

Form="Contact" & @Left(LastName; 1)="A"

There are too many functions, so you'd better look 'em up in the Domino Designer Help database.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22817206
0
 
LVL 18

Author Closing Comment

by:David Robitaille
ID: 31510515
Thanks!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question