05-23-2011 12:37 AM
Hi all, I have developed a web application using TRIM SDK 6.2.5 in which there is a global search feature which will search for the search keyword either in record title or document content. Though my code is able to search across the huge dataset perfectly, but it is taking more time for few keywords where there are more than 100 resultsets. Is there any way to restrict the SDK to show only the top 100 records? So that, I can put a message asking the end user to narrow down the search or add more kewords.
If there is no way to do this using TRIM SDK, Can I use the database.getRecordset to run sql query? But unfortunately, I don't know to write query as I don't understand the complete databse schema. Can any one give me clue on the SQL QUERY for the following TRIM SDK code..
RecordSearch rSearch = db.NewRecordSearch();
Object publicValue = "P";
Object priValue = "V";
records = rSearch.GetRecords();