How to replace default advsearch query with custom query in webtop 6.5 sp2

snunna

Hi All,

We have a requirement to replace default advsearch query with custom query in webtop 6.5 sp2

Using below code getting default query and able to add where clause, but need to replace default query with custom query, it would be great if you could advise on how to do this

SearchInfo info = getSearchInfo();

IDfQueryBuilder qb = info.getQueryBuilder();

String query = ((DfQueryBuilder)qb).getDocbaseQueryDescription(getDfSession().getDocbaseName(), getDfSession().getSessionManager()) .getQueryStatement();

System.out.println("query  = "+query);

IDfExpressionSet rootSet = qb.getRootExpressionSet();

IDfExpressionSet setAnd = rootSet.addExpressionSet (IDfExpressionSet.LOGICAL_OP_AND); setAnd.addSimpleAttrExpression("r_modifier", IDfValue.DF_STRING, IDfSimpleAttrExpression.SEARCH_OP_CONTAINS, true, false, "john");

Thanks

RajalakshmiGautam

Hi,

In advanced search, you override buildQuery to access the user’s query. The search class is as follows:

  package com.mycompany;import com.documentum.fc.common.IDfValue;import com.documentum.fc.client.search.IDfSimpleAttrExpression;import com.documentum.fc.client.search.IDfExpressionSet;import com.documentum.fc.client.search.IDfQueryBuilder;public class AdvSearchEx extendscom.documentum.webtop.webcomponent.advsearch.AdvSearchEx{protected IDfQueryBuilder buildQuery() throws Exception{IDfQueryBuilder qb = super.buildQuery();IDfExpressionSet rootSet = qb.getRootExpressionSet();IDfExpressionSet setAnd = rootSet.addExpressionSet(IDfExpressionSet.LOGICAL_OP_AND);setAnd.addSimpleAttrExpression("object_name", IDfValue.DF_STRING,IDfSimpleAttrExpression.SEARCH_OP_CONTAINS, true, false, "xpath");return qb;}}

You can change the location, including the source and folder path in the repository with query builderAPIs. The following example adds a source repository to IDfQueryBuilder instance and sets a pathwithin the repository for the query. The examples for basic and advanced search show you how to getthe query builder instance (variable qb in this example):  qb.clearSelectedSources();qb.addSelectedSource("dm_notes");// set source, path, descend flagqb.addLocationScope("dm_notes", "/Temp", false);

The resulting query is similar to the following:

SELECT r_object_id,text,object_name,FROM dm_documentSEARCH DOCUMENT CONTAINS testing WHERE (object_nameLIKE %testing% ESCAPE \) AND FOLDER(/Temp) AND (a_is_hidden = FALSE) Hope this helps you. Please mark answer as correct/helpful if it has helped you. Rajalakshmi