Ax Dynamics AX2012: Table Full 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.

Example:

/* 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); } }

Happy Full indexing in 2012 ;)

Advertisements

About ShriShail Technologies Pvt Ltd

ShriShail Technologies is a company founded by a group of aspirants, from diversified domains and work experience. We provide smart, technology-enabled solutions to solve our clients' toughest challenges, demonstrating a commitment to not only excel, but also drive with our passion to exceed expectations. Our organization is efficient in delivering intelligent solutions that are cost effective on various work areas such as Business Management Solutions, Microsoft and Open Source platforms. ShriShail Technologies allows you to achieve the agility, flexibility and adaptability that are essential to succeed in today’s highly competitive global market.
This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s