Источник:
http://axblog4u.wordpress.com/2011/0...-text-indexes/
==============
Microsoft Dynamics AX 2012 provides full-text functionality that enables Microsoft Dynamics AX to search business data over a large volume of text data or documents.
Please refer the following link which explains on the same.
http://dynamicsaxgyan.wordpress.com/.../#comment-203/
Also refer ‘AX Wonders’ blog which explains on setting up ‘Full Text Index’ Setup in SQL Server 2008 R2
http://axwonders.blogspot.com/2011/0...ch-setup.html/
Example:
X++:
/*
Two important rules for creating Full Text Indexes
[Technet]
TableGroup property.
A table can have a full text index only if the TableGroup property
is set to Main or Group on the table.
A full text index can only be created on a table with RecId index.
So make sure 'CreateRecIdIndex' property flag on table is set to Yes
*/
static void FullTextIndexesDemo()
{
Query query = new Query();
QueryBuildDataSource queryBuildDatasource;
QueryRun queryRun;
QueryBuildRange queryRange;
FullTextIndexesDemo fullTextIndexes;
queryBuildDatasource = query.addDataSource(tableNum(FullTextIndexesDemo));
queryRange = queryBuildDatasource.addRange(fieldNum(FullTextIndexesDemo,
AxVersion));
queryRange.rangeType(QueryRangeType::FullText);
/*
[Technet] Space characters are treated as implicit Boolean OR operators.
There is a space character in the string parameter in call
queryBRange4.value("dynamics 0");.
*/
queryRange.value('dynamics 0');
queryRun = new QueryRun(query);
while (queryRun.next())
{
fullTextIndexes = queryRun.get(tableNum(FullTextIndexesDemo));
Debug::printTab(DebugPrintTab::ActiveX, fullTextIndexes.AxVersion);
}
}
Источник:
http://axblog4u.wordpress.com/2011/0...-text-indexes/