Skip to main content
C
cap08
October 2, 2024

How to get UD1's Property AuditTime

  • October 2, 2024
  • 4 replies
  • 0 views

Hello -

I need to get the most recent Property change on our UD1's. I'm assuming I need to get the AuditTime from the AuditMemberProperty table. 

Would I use this function? If so, how do I find the textPropertyIndex value?

 BRApi.Finance.UD.Text(si, dimTypeId, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId) 

Your help is much appreciated! 

Thank you!

 

4 replies

T
T_Kress
October 2, 2024

I would suggest you download and install the "Standard Application Reports" which is available in the MarketPlace in the Solution Exchange.  It is likely you may already have it in your app.  

In there, there is a Metadata Change Audit > Member Property Changes Audit report that will have this info for you.

See here as an example:


T_Kress_0-1727895804669.png

 

C
cap08Author
October 2, 2024

HI Teresa, thanks for this suggestion - we do already have the application reports. I have to add this column to an existing custom UD1 report. Sorry, I should have been clearer.

K
KarlT
October 3, 2024

If you look at the underlying data source rules in standard application reports you can follow the same approach.

D
DanielWillis
Employee
October 2, 2024

I don't think there is a built-in function for it. The function you mentioned would return the text property of the member with textPropertyIndex selecting which of the 5 text properties to return. I can't think of a way other than looking it up in the table you mentioned.

C
cap08Author
October 3, 2024

I found that the RPTA_SolutionHelper as SQL which retrieves the AuditTime. As you suggested, KarlT, I'll copy this approach. 

Thank you all for responding! 

 

Terms & ConditionsAccessibility statement