PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/2/2007 11:42 PM by  Rod Weir
Custom Fields defined against assets
 2 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Daryl Quadros
New Member
New Member
Posts:2
Points:4


--
11/2/2007 4:14 AM
    Hi,

    I'm trying to pull together a report that contains a set of specific assets and which clients they are linked to. In this report, I also need to pull out a specific custom field that is defined against the asset - in which tables can I find the custom field information and how is it linked to the assets?

    Thanks in advance,
    Daryl.
    Daryl Quadros
    New Member
    New Member
    Posts:2
    Points:4


    --
    11/2/2007 8:11 AM
    Never mind,

    i've managed to pull the detail through by modifying the view qryAssetConfigurationDetails
    and copying/inserting one of the existing statements modified as follows:

    CASE tblSystemCodes.Caption WHEN '' THEN detailValue ELSE NULL END

    Daryl.
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    11/2/2007 11:42 PM
    Hi Daryl,

    Good to hear that you've figured it out. You can also find custom asset information in the "qryCrossTabCustomDetails_Asset" view in the database. This view is a cross-tab query that displays all of the custom information is a very easy-to-use format. If you like you can link that view (or a copy of it) into any of the reporting views. Reporting view are those that are prefixed by "rpt".

    Often it's better to query information via a view rather than the base table. The advantage of using a view is that many of the links (if not all) are already defined and all you have to do is reference the view in your reporting solution.

    Hope this helps. Let me know if you need any further help and I'll be glad to help.

    Best regards,

    Rod
    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...