Full text on forms builder search template

We are facing a problem with full text search on a forms builder template because we can't find a way to use search operators. E.g.

select * from dm_document SEARCH DOCUMENT CONTAINS '$words$'

if I search for "test AND document" the result query would be select * from dm_document SEARCH DOCUMENT CONTAINS 'test AND document'

and would return the same as select * from dm_document SEARCH DOCUMENT CONTAINS 'test' or 'AND' or 'document' when in fact I want select * from dm_document SEARCH DOCUMENT CONTAINS 'test' AND 'document'. How could I generate the desired query on forms builder if I cannot parse the user input to insert the ' on the correct places?

Find more posts tagged with

Comments

Julien.Fontaine

Hi Tiago, First, you can try to enable the Global Search for your full text query.

tiago.schumann

Well in fact I have simplified the query for better understanding, but I combine fulltext with specific attributes on the search so the global search would not be an option for us.

the real query is sometihng like:

select * from my_custom_type SEARCH DOCUMENT CONTAINS '$words$' where my_custom_attribute1 like '$field1$' and ... my_custom_attributen like '$fieldn$'.

As the user is supposed to insert how many search words he needs, I could not find a way to address this on forms builder.

DCTM_Guru

Have a look at the advance search xcelerator:

https://community.emc.com/docs/DOC-6143

tiago.schumann

In fact the advanced search is not we want in this case because the idea is set the mostly used attributes to simplify the search use, so users don't have to pick up the desired ones from a combo and manually adding the others. .Still, we want the advanced search on another tab and tried to use for more advanced users and it did not work correctly (was showing only 1 result.On Log there was a warn saying some results were filtered, but there was no configuration setting any filter). But the xcelerator are not supported by EMC and we could not solve this problem. We are migrating to xPlore now and the problem doesn't seems to occur on the new enviroment, but advanced search still is not for any user. Most of them gets confused with it.

DCTM_Guru

The problem with simple search customization as you described is that you cant easily translate a variable number of search term to variable number of search clauses.

As for searching attributes directly in xPlore, you can do this by using xQuery against the indexed attributes. You will need to write your own code to do this, since xQuery interface is not supported out of box in Taskspace.