full text search in mobile sales?

[Former Member]

Hi!

CRM 4.0, Mobile sales, business partners, ...

I've to include a fulltextsearch in the search tile capsearch2. The search should look into the longtext-notes created for most partners. I think i need an enhanced bscapgen/capgen_query ... the real longtext seems to be in the field notes of bonote... a binary field... and i don't konow how to work with it in our mobile sales app

Are there any docs online how to work with these binary fieldcontent?

Thanks a lot for your help!

Best regards,

Ingo

[KaushalShah · Accepted solution]

I don't think it should be much complicated.

SQL queries like mentioned below will work for you:

select note, * from smonote where note like '%test%'

This will fetch you all notes which contains text "test". Try this in your SQL query analyzer.

So you can modify your bdoc / query object accordingly.

Hope this helps.

Regards,

Kaushal

[Former Member · Accepted solution]

Thanks a lot!

I'll try it.

But i think it's not so easy to put this select-syntax into the where-clauses of my query-bdoc "bscapgen"

But i'll try it - thanks again.

Best regards,

Ingo

[KaushalShah · Accepted solution]

No no, putting this in query bdoc is quite easy.

Define a new parameter in bdoc, say ZNOTE.

For table SMONOTE add a new where clause like:

NOTE.NOTE like :ZNOTE

That should be it. Hope it helps.

Regards,

Kaushal

[Former Member · Accepted solution]

One thing to note...

Doing a query like:

<i>select note, * from smonote where note like '%test%'</i>

It will work, but it is not utilizing the FullText indexing...it's just doing a standard SQL search.

A full text query would look something like:

<b>select note, * from smonote where contains(note, ' "test" ')</b>

AND...the table SMONOTE must have a FullText index setup for it.

We did something similar with our SMOMAKT (material description) table on field MAKTX.

[Former Member · Accepted solution]

Thanks a lot!