Versions Compared

Old Version 1

changes.mady.by.user Knowledge Assistant

Saved on

compared with

New Version Current

changes.mady.by.user Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

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

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleContext
  • Munis 2018.1 and later versions
  • SSRS reports
  • Crystal reports
  • SaaS, Tyler-hosted clients
  • OnPrem, Self-hosted clients
  • Asset Registry


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

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

...

theme

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'

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

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:

Code Block
languagesql
Confluence
linenumberstrue


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information


...