Microsoft Dynamics AX (Archived)

how to know table name in AX 2012

(0) Share

Report

Posted on by Ekrami Mikhail

Hi all ,

i need help ,,,

My case is : i imported release products using Data Import Export Framework

i found Search name empty

3173.1.JPG

how to solve this problem

should i update using SQL

I Need to know the table name in side database

how to find it ..there is any way to know any display name

how to find Search Name ,,,, what is the name in AOT

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (3)

Sort by

Verified answer

Sohaib Cheema 49,664 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Search name is saved in NameAlias(Field) of InventTable.

You can update data using excel add-in or using DIXF. interaction with direct SQL is non-healthy sometimes.

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

You can right click the field in AX for which you would like to know what table and field/display method does it belong to, and select the Personalize option. You will see the information in the bottom right text control.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,125 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Ekrami,

In AX2012 the search name is stored in the table EcoResProduct. The released products table (InventTable) has a field Product which is linked with the record ID of the EcoResProduct table.

Was this reply helpful? Yes No
Ekrami Mikhail 60 on at

Like (0)

Report
Copy link

Link copied!

Thank you Sohaib for your advise .. i will try using DIXF OR EXCEL

Was this reply helpful? Yes No
Ekrami Mikhail 60 on at

Like (0)

Report
Copy link

Link copied!

Thank you Sohaib for your advise ,, i will do this

Was this reply helpful? Yes No
Ekrami Mikhail 60 on at

Like (0)

Report
Copy link

Link copied!

Thank you Andre ,, i check the table in database & i found search name is have data but not shown .

Was this reply helpful? Yes No
Ekrami Mikhail 60 on at

Like (0)

Report
Copy link

Link copied!

Thanks Vilmos ,,,

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 305,125 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi Ekrami,

Your question was about a table name. The value was indeed empty, as it was already empty in the screenshot you provided.

You can use the Product entity in DIXF to update the Search name.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ekrami Mikhail,

Please try this JOB to update NameAlias Data. It will work.

static void UpdateNameAlias(Args _args)
{
     SysExcelApplication application;
     SysExcelWorkbooks workbooks;
     SysExcelWorkbook workbook;
     SysExcelWorksheets worksheets;
     SysExcelWorksheet worksheet;
     SysExcelCells cells;
     COMVariantType type;
     Name name;
     FileName filename;
     int row =1;
     int i=0;
     InventTable         inventTableLoc;
     ItemId              itemid;
     TransDate           transdate;
     str                 nameAlias;
     Dialog dialog;
     DialogField dialogField;
     ;
     application = SysExcelApplication::construct();
     workbooks = application.workbooks();
     dialog = new Dialog("FileOpen");
     dialogfield = dialog.addField(extendedTypeStr(Filenameopen), "File Name");
     dialog.run();

     if (dialog.run())
     {
        filename = (dialogfield.value());
     }
     try
     {
     workbooks.open(filename);
     }
     catch (Exception::Error)
     {
     throw error("File cannot be opened.");
     }
     workbook = workbooks.item(1);
     worksheets = workbook.worksheets();
     worksheet = worksheets.itemFromNum(1);
     cells = worksheet.cells();
     do
     {
         ttsBegin;
     row++;
     itemid    = cells.item(row, 1).value().bStr();
     nameAlias = cells.item(row, 2).value().bStr();
     inventTableLoc = InventTable::find(itemid,true);
     inventTableLoc.NameAlias = nameAlias;
     inventTableLoc.update();
         ttsCommit;
     i++;
     type = cells.item(row+1, 1).value().variantType();
     }
     while (type != COMVariantType::VT_EMPTY);
     application.quit();
     info("Done");
     info(strFmt("%1", i));
}

Thanks,

Suresh

Was this reply helpful? Yes No
Suggested answer

Ekrami Mikhail 60 on at

Like (0)

Report
Copy link

Link copied!

Dear Andre

can u help me i need SQL Query for updating field NAMEALIAS ( InventTable )

Dear Andre above image show NAMEALIAS empty except some i filled manually from AX Client

i have about 400 item i need to update

when i'm checking Released Product ( EcoResProductTranslation ) in Database i found all item duplicated like this image below

l

Appreciate

Was this reply helpful? Yes No