Full Text Index in Dynamics AX 2012

Hi Friends,

Full text index supports to quickly query words that are embedded in the middle of a string field of a table. Well, this is a very nice enhancement to query on Database table fields for the developers who work with the latest vesion [Microsoft Dynamics AX 2012]

Good thing is we can use this Index on Memo fields and also Extended data type.

Let me explain with an example. Create a new table as shown below and add a new field of type string “Name” to it – On the field use EDT – Name. In the below example, my table Name is SR_FullTextExample.

Once you are done with your table, Go to FullTextIndex Node >> Right click and create a new FullTextIndex.
Rename it to NameFullTextIndex. Drag and drop Name field from the fields to the newly created index.

The table with index should look like below.

The following X++ Job uses a full text index that exists on a table and field that it queries.

static void FullTextExamp(Args _args)

{

    FullTextExample fullTextExample_obj;

    Query qr;

    QueryBuildDataSource qbds;

    QueryBuildRange qbr;

    QueryRun qrun;

    ;

    qr = new Query();

    qbds = qr.addDataSource(tableNum(FullTextExample));

    qbr = qbds.addRange(fieldNum(FullTextExample,Name));

    qbr.rangeType(QueryRangeType::FullText);

    qbr.value("Brahma Kumar");

    qrun = new QueryRun(qr);

    while(qrun.next())

    {

        fullTextExample_obj = qrun.get(tableNum(FullTextExample));

        info(fullTextExample_obj.Name);

    }

}

Output:

Happy

Daxing.....