Skip to main content

Full Text Index in Dynamics AX 2012

By
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.....







Comments

Post a Comment

Popular posts from this blog

Using File path on a form getting Error in Axapta

By
Hi Folks, After a long time am coming  back to posting few new things here for AX Developer... When we want to select the file path in form level. Normally what we will do create one EDT and extends with filepath (EDT), but that time when you are trying to select the path we will get error like stack-trace/Error message .Don’t worry there is no problem with your ax application. Simple we need to provide the method to the form like filepathLookUpTitle (). Below method we need to add it into form level methods, i.e. str filePathLookupTitle() {     return "Select document folder"; } Thanks Happy Daxing....
20 comments
Read more

Convert word Documents into PDF report [using X++ in Dynamics AX 2009]

By
Hi Friends, This is the way we can convert word format report into PDF in ax2009 static void dsiple_PDS(Args _args) {     Args args;     ReportRun rr;     str reportName = "ReportName";     PurchRFQLine rfqLineTable;     str myPath;     str pdfFileName;     int i;     COM wordApplication;     COM wordDocuments;     COM wordDocument;     COM wordRange;     str a[];     str path;     str pdfPath;     str finalPath;     int length;     int minus;     ;     i = 1;     myPath = winApi::getTempPath();     info(myPath);     args = new Args(reportName);     args.caller(rr);     //rr =...
1 comment
Read more

AIF (Endpoint) Error : The user is not authorized to perform this action.

By
"The user is not authorized to perform this action."  We started getting this error message in our AX 2009 System, when ever we try to consume an XML file using an  Endpoint   thru a  File System  Channel to create a  Sales Order. We did not made any code changes / setup changes, but all of the sudden started getting this error. Solutions : 1. Validate the "SourceEndpointUser". in inbound XML  The User ID should be a valid user Id in DAX, in GNS Active Directory and the "\" should be back slash in the XML file or where you use this combination in entire process or setup. ex : Domain \ User Id. In our case when we had the above error, the SourceEndPointUser user id was deleted from the Active Directory in GNS, so we added it back to Active Directory then it solved the problem. NOTE : If nothing wrong with the User ID, try to add the user id in "Users" tab in Endpoints form for that End Point used by the process. 2. Verify th...
1 comment
Read more