Leveraging Enums on AM reports

Adam_Dzyacky

While I know Cireson gives customers the option to choose whether to use free text or drop downs for their Asset Management Manufacturer and Model it doesn't appear the same holds true in reports.

Is it possible to configure (Cireson's) stored procedures to leverage enums from AM instead of the free text choice that is available for Manufacturer and Model?

Brett_Moffett

Interesting thoughts there @Adam_Dzyacky.
The only limitation here would be the Type Projection that is used on the report. It could be possible to create a new type projection, or Join in the SQL query, to pull this information out of the Catalog Item class.

I wish I had time to test this and give you a more firm solution but just don't have the spare cycles at this point. Sorry I can't give you a specific example.

Brett_Moffett

Interesting thoughts there @Adam_Dzyacky.
The only limitation here would be the Type Projection that is used on the report. It could be possible to create a new type projection, or Join in the SQL query, to pull this information out of the Catalog Item class.

I wish I had time to test this and give you a more firm solution but just don't have the spare cycles at this point. Sorry I can't give you a specific example.

Adam_Dzyacky

Actually - I think that is really all I needed to hear for confirmation. I think I may know how to do this then. If I figure it out I'll be sure to share.