Full Text Index

Full Text Indexes:

           

 Full text index are very helpful in searching for words that are embedded in the midlle of string fields . This information can be used by queries to run more efficiently and bring more accurate results. This index can also be used on MEMO and EDT's .

There Can be only one Full Text Index per table.

 

How To Create a Full Text Index:

• First we need to create a table and the table must contain string fields.
• Set the Table group property of the table to Main.
• Expand the table and right click on it's Full Text Index node and create new Full Text Index.
• Drag and drop the table's string fields on the newly created Full Text Index.

Your project should look like this.

    
   

Using Full Text Index In Queries:

In order to Use Full Text index in queries we need to create a simple job like this.

Hope it was helpful to you.....






                                                                        

Ax 2012 Queries

Queries in AX2012

There are three types of queries in Dynamics Ax.

1.       INLINE QUERIES

2.       AOT QUERIES

3.       QUERY BUILD API

Each of them has their different usage and conditions in which they are suitable to use.

Usage of Inline Queries:

·         They are used when we require a query that isn’t reusable or is used for a specific condition or scenario.

Usage of AOT Queries:

·         They are used when we require a query that has to be reused on multiple scenarios.

     Usage Of Query Build API:

·         Mostly Used when we have to run existing AOT Queries with modification.

   

     EXAMPLE:     

                 In this Example I will Show simple jobs demonstrating a Single Query in all three Forms.

         

     Inline Query:

                           

The Image above shows a Simple Query in which there is a join between HcmBenefit & HcmBenefitPlan Tables.

     AOT Queries:

              We need to create a new Query under the Query node of the AOT.

                                     

                  

    Then to run this query we need to create a simple job as follows.

                

                                       

  Query Build API:

   Now to produce the same query with Query Build API we have to create a Job as shown below.

  

                               

    I hope It was helpful.