Is it possible retrieve time a record was last modified in addition to just the date?

Options
Pepper Hayes
Pepper Hayes ✭
Ninth Anniversary Photogenic First Reply
in Blackbaud Raiser's Edge NXT®: General Discussion
Hi All,


I'm trying to do a time comparison in Power BI of how our proposals change throughout the year, but I'm running into a problem where I can't pull the time a proposal was modified, just the date.  (Even though "date last changed" is a datetime field, it only pulls the dates and then 00:00 for the time).


Does RE track a time stamp on modifications?  If so, is there any way to retrieve that info via export?


Thanks so much if anyone has ideas!


Pepper
Tagged:

Comments

  • Steven Cinquegrana 2
    Steven Cinquegrana 2 ✭
    Ninth Anniversary Facilitator 3 Name Dropper Photogenic
    Hi Pepper,


    Are you self-hosted? If so, see if you can have a look at the appropriate SQL table column and see what actually stored.


    I just had a look at the RECORDS table (Constituent records) and the DATE_LAST_CHANGED column does have the actual time component.


    Maybe you can rejig your connector to use the SQL back-end.


    Cheers,

    Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

     
  • Pepper Hayes
    Pepper Hayes ✭
    Ninth Anniversary Photogenic First Reply
    Ooh, that is a clever idea!  Unfortunately, we aren't self-hosted so I can't access the tables. :(  
  • Aaron Rothberg
    Aaron Rothberg ✭
    Eighth Anniversary Facilitator 2 Name Dropper Photogenic
    Omatic has a product called RETRACE. I don't know if the product is available to hosted clients and I'm not sure how granular the timestamps are.

Categories