Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Description of Issue

Client wants to be able to write a custom report with the custom data found in the Asset Registry

Context
  • Munis 2018.1 and later versions
  • SSRS reports
  • Crystal reports
  • SaaS, Tyler-hosted clients
  • OnPrem, Self-hosted clients
  • Asset Registry
Cause

The view database column overlay shows custom data fields as derived.

Resolution

This custom data is located in the view wm_user_data.  Replace XXXX in the following query with the asset code to retrieve custom data for that specific asset code:

select distinct 
a_code, 
uf_label, 
ud_data
from wm_assets 
inner join wm_user_data
on a_hdr_id = a_header_id 
where uf_prog_type='A' 
and a_code='XXXX'
Additional Information






  • No labels