Can not find RecId in Table Field.

Finance and Operations/AX Developer Forum
1

Hi,

I am unable to fine RecId in theTable>Fields but when I opened in table browser I can see the RecId.

How to make visible RecId in the table field and the table is AOT>DataDictionary>Tables>LogisticPostalAddress .

Thank you

2

RecId , RecVersion, CreatedBY, modifiedBy, createdDateTime, modifiedDateTime are the system fields, they wont be visible on the fields node(in a table), but you can access and use them(you can find them as columns in SQL data base).

3

HI,

Rec Id is system generated columns . they won’t come under Fields node in table.Only User Defined fields only come under Field node. if u want to view RecID field under field node then place the table as data source of a form[:)].

4

Can’t we use the recID in select statement

eg:

select LogisticsPostalTable where LogisticsPostalTable.RecId == ‘123456’;

print LogisticsPostalTable.;

pause;

I tried it but its showing empty that means it didn’t fetch that record using RecId 123456. How to fetch the record using RecId then?

5

hi,

use this LogisticsPostalTable.RecId == 123456 instead of LogisticsPostalTable.RecId == ‘123456’;

6

It should have returned a compile error, as the recId is not of type string an interger(int64)

7

select LogisticsPostalTable where LogisticsPostalTable.RecId == 123456;
or
select LogisticsPostalTable where LogisticsPostalTable.RecId == str2int(‘123456’);