Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Created and modified d...
Microsoft Dynamics AX (Archived)

Created and modified date time fields

(0) ShareShare
ReportReport
Posted on by AdnDalhi 316

Hi All,

I have a quick technical question about 2 standard fields in AX ( Created date time & Modified date Time ),

I'm working now on a SQL Query, and i'm using " LOGISTICSELECTRONICADDRESS " table, but i didn't find these 2 fields,

PS: I'm obliged to use SQL, and i need to know the date of creation and modification of the customer contact, im wondering if there is any alternative to do that, or other fields to trieve Creation / Modification date.

Here is my SQL Query:

SELECT

CUSTTABLE.ACCOUNTNUM                               AS [Customer account],
LOGISTICSELECTRONICADDRESS.DESCRIPTION             AS [Description],
LOGISTICSELECTRONICADDRESS.TYPE                    AS [Type],
LOGISTICSELECTRONICADDRESS.LOCATOR                 AS [Contact Number/Address],
LOGISTICSELECTRONICADDRESS.ISPRIMARY               AS [Primary],
CUSTTABLE.DATAAREAID                               AS [Data Area Id]

FROM CUSTTABLE, DIRPARTYLOCATION, LOGISTICSELECTRONICADDRESS

WHERE CUSTTABLE.PARTY = DIRPARTYLOCATION.PARTY
AND LOGISTICSELECTRONICADDRESS.LOCATION = DIRPARTYLOCATION.LOCATION

ORDER BY CUSTTABLE.ACCOUNTNUM, CUSTTABLE.CREATEDDATETIME

*This post is locked for comments

  • AdnDalhi Profile Picture
    AdnDalhi 316 on at
    RE: Created and modified date time fields

    Hi Moahmed I'll do for sure :) , i'm just testing some results, and comparing the dates between customers and their contacts

    Thanks again :)

  • Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at
    RE: Created and modified date time fields

    Adax, can you please mark this as verified answer to close the topic.

    Thanks

  • Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at
    RE: Created and modified date time fields

    That is correct

  • AdnDalhi Profile Picture
    AdnDalhi 316 on at
    RE: Created and modified date time fields

    Thanks a lot Mohamed, for your answer,

    Could you please validate me, that createdDatetime and ModifiedDateTime fields, represent exactly the dates of the creation/modification of customers contact

    Thank you :)

  • Verified answer
    Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at
    RE: Created and modified date time fields

    SELECT

    CUSTTABLE.ACCOUNTNUM                               AS [Customer account],

    LOGISTICSELECTRONICADDRESS.DESCRIPTION             AS [Description],

    LOGISTICSELECTRONICADDRESS.TYPE                    AS [Type],

    LOGISTICSELECTRONICADDRESS.LOCATOR                 AS [Contact Number/Address],

    LOGISTICSELECTRONICADDRESS.ISPRIMARY               AS [Primary],

    CUSTTABLE.DATAAREAID                               AS [Data Area Id],

    LogisticsLocation.CREATEDDATETIME   AS [Created Date Time],

    LogisticsLocation.MODIFIEDDATETIME   AS [Modified Date Time]

    FROM CUSTTABLE

    inner join DIRPARTYLOCATION

    on DIRPARTYLOCATION.PARTY = CustTable.PARTY

    inner join LOGISTICSLOCATION

    on LogisticsLocation.RECID = DIRPARTYLOCATION.LOCATION

    and LogisticsLocation.ISPOSTALADDRESS = 0

    inner join LOGISTICSELECTRONICADDRESS

    on LOGISTICSELECTRONICADDRESS.LOCATION = LogisticsLocation.RECID

    ORDER BY CUSTTABLE.ACCOUNTNUM, CUSTTABLE.CREATEDDATETIME

  • AdnDalhi Profile Picture
    AdnDalhi 316 on at
    RE: Created and modified date time fields

    Thanks Mohammed for you reply,

    But my records is in LogisticsEletronicAddress table,

    Do you mean, i need to add a join between LogisticsElctronicAddress table and LogisticsLocation?

    If yes, in this case i will get the CreatedDateTime & ModifiedDateTime for the records in LogisticsLocation table and not EletronicAddress,

    Can you provide an example please by modifiyin my Query

    .

    Thanks in advance.

  • Suggested answer
    Mohammed Khatib Profile Picture
    Mohammed Khatib 430 on at
    RE: Created and modified date time fields

    Hi Adax,

    It is much better to join your query to LogisticsLocation table which already has these fields.

    Note: Every Electronic address will have one Location record (1:1) relation

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Created and modified date time fields

    You need to synchronize the database. Please talk to developers in your company, you need to follow the dev process that is defined for your project / company. Otherwise your changes might be wiped out with next code deployment.

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,647 on at
    RE: Created and modified date time fields

    did you complete sync?

  • AdnDalhi Profile Picture
    AdnDalhi 316 on at
    RE: Created and modified date time fields

    I've just changed the 2 table properties in AX Test Environement, but i cannot see the fields yet @SQL

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans