Fulltext Index

Dynamics AX 2012 supports now a fulltext-index.
You can now insert a memo field into an index, into a fulltext index.
But how can i take an advantage of this index?

Like previous versions, you can’t use a memo field inside a select-statement
or as query range.

But you can use it now as query range when you add the range with x++ code.
The property rangetype exists only as parameter in the addRange-Method of the QueryBuildDataSource,
and not as Property in the AOT query range.

qbr = qbds.addRange(fieldNum(Table1,field2),1,QueryRangeType::FullText);

As value, you
- can’t use joker ( *, ?)
- multiple values separated by spaces will be interpreted as OR
- can’t search parts inside of words

An empty range value will cause a runtime error!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">