Search Worksite documents with more than one parameters

George0207

I wrote a c# code to search worksite documents.  It works fine when I only provide one single parameter, however, if I provide more than one, it will return no result (result count=0).  I would like to search either (author=srchKey) OR (fulltext=srchKey).  I have been banging my head, could anyone please help? Thanks a lot.

 

Below is my code:

 

public List<iManageVO> RunSearch(string srchKey)
{

   try
   {

         iManageSearch rds = new iManageSearch(isession);

        // Populate searchparameters
        IManProfileSearchParameters searchparams = Utility.CreateUnpopulatedProfileParams(idms);
        

        // the code works, if there is only one searchparams, but if I un-comments one, it will return no result.

        // i would like to search either author = srchKey OR Description = srchKey
        //searchparams.Add(imProfileAttributeID.imProfileAuthor, srchKey);
        //searchparams.Add(imProfileAttributeID.imProfileFullText, srchKey);
        searchparams.Add(imProfileAttributeID.imProfileDocNum, srchKey);
        //searchparams.Add(imProfileAttributeID.imProfileDescription, srchKey);

 

       // Search documents
        IManDocuments results = rds.GetDocuments(Utility.BuildDatabaseList(isession.Databases), searchparams);

        List<iManageVO> foundDocuments = null;
        // Check results
        if (results != null)
         {
                foundDocuments = new List<iManageVO>();
                strResult = "Search returned " + results.Count + " document(s).";
                foreach (IManDocument document in results)
                  {
                        
                                 iManageVO doc = new iManageVO();
                                 doc.Description = document.Description;
                                 doc.Author = document.Author.FullName;
                                 doc.DocId = document.Number;

                                  doc.iManageNrl = document.ObjectID;

                                  foundDocuments.Add(doc);
                             
                     }

             }

               return foundDocuments;
    }
    catch (ApplicationException ae)
    {
                 throw ae;
     }


}

RKnott1

Hi,

There's a section in the API document "WorkSite COM Developers Reference Guide (8.5, English)" about using complex queries. I used it a long time ago, can't find any examples from my current code base so here's the example from the book which I think will best help you:

 

Example C – Search Query: (CLIENT="5679") OR (MATTER="91003") OR (CLASS="LETTER" AND PRACTICE="C29ALIAS")
private void ExampleC(IManSession sess, ManStrings dblist)
{
// Search Query: (CLIENT="5679") OR (MATTER="91003") OR
// (CLASS="LETTER" AND PRACTICE="C29ALIAS")
// Create OrQuery
IManOrQuery orQuery = new ManOrQueryClass();
// Use AddOrQuery to build an Or query between two different attribute
// IDs (CLIENT="5679") OR (MATTER="91003")
IManOrQuery oq = orQuery.AddOrQuery();
IManFieldQuery oqC1 = _
oq.AddFieldQuery(imProfileAttributeID.imProfileCustom1);
oqC1.Values.Add("5679");
IManFieldQuery oqC2 = oq.AddFieldQuery(imProfileAttributeID.imProfileCustom2);
oqC2.Values.Add("91003");
// Use AddAndQuery to build an And subquery between two different
// attributeIDs (CLASS="LETTER" AND PRACTICE="C29ALIAS")
IManAndQuery aq = orQuery.AddAndQuery();
IManFieldQuery aqC = _
aq.AddFieldQuery(imProfileAttributeID.imProfileClass);
aqC.Values.Add("LETTER");
IManFieldQuery aqC29 = _
aq.AddFieldQuery(imProfileAttributeID.imProfileCustom29);
aqC29.Values.Add("C29ALIAS");
try
{
string strResults= string.Empty;

int ct = 0;
// Pass in the ManOrQuery parameter to run the search
IManDocuments results = _
(IManDocuments)sess.WorkArea.SearchDocumentsEx(dblist, orQuery);
...
}