Forgot password? | Forgot username? | Register

IMu Search Filter Using fields in a referenced table

IMu Search Filter Using fields in a referenced table

I'm hoping someone can help with me this search filter. I need to find matching ecatalogue items where the referenced module MulMultiMediaRef_tab.MulMimeType = "image". I tried the code below but I keep getting -1 for hits.

Code:


Module module = new Module("ecatalogue", imuApi.Session);

//Return Columns
string[] columns =
            {
                "irn",
                "SumCatalogIdNo",
                "SumCallNumber",
                "SumFullDescription",
                "MulHasMultiMedia",
                "SumTitle_tab",
                "SumObjectName_tab",
                "SumCreatorRef_tab.(NamFirst;NamLast;NamFullName;AdmDateInserted)",
                "SumCreatorRole_tab",
                "SumCreationDate_tab",
                "SumCollectionCategory_tab",
                "SubSubjects_tab",
                "MulMultiMediaRef_tab.(irn;MulMimeType,MulMimeFormat;MulTitle)"
            };

//I tried the following search.
Terms search = new Terms();
search.Add("MulMultiMediaRef_tab.MulMimeType", "image", "=");
hits = module.FindTerms(search);

But I get hits = -1. I've tried numerous different ways for search.add() but so far I haven't had any luck.

Thank you,
Ken

Administrator has disabled public posting. Please login or register in order to proceed.

Re: IMu Search Filter Using fields in a referenced table

Hi Ken,

To query for records on the ecatalogue module with multimedia use:

EMu 4.3:
search.add("MulMultiMediaRef_tab", "*");

EMu 5.0:
search.add("MulMultiMediaRef_tab", "\\*");

-Joel

Edited by: Joel Ramirez - 21-Oct-16 01:30:21

Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
601
Total Polls:
0
Total Posts:
1362
Posts today:
2
User Info
 
Total Users:
816
Newest User:
Gregory Brown
Members Online:
2
Guests Online:
179