Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Query infolog data directly in sql

Posted on by 55

hi all,

Newby in AX 2012 forums.  

We are using AX 2012 R3. 

The question is : 

 Is it possible to query and transform an infolog data field from its infolog type to varchar type via a direct SQL??

Something like 

SELECT convert(varchar(1000), infologdata)  

from infologtable... 

It seems that I cannot convert from hex to varchar.  infolog might be a proprietary data type. 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans