CA Service Management

 View Only
  • 1.  Report Data Object Variable Solution Needed

    Posted Mar 01, 2017 02:22 PM

    I am fairly new to creating report data objects and have come across a small snag that I am hoping someone can get me through.  I will have three RDOs to pull back manager names, orgs and roles.  I have a relations table in the database to link them all.  I want to create a variable to pull back the org and role info based on the manager name that is selected.

    I have the below query which pulls back all results needs, yet when I add the variable it gives me no results, I get the popup box to test the variable but the results are none.

     

    SELECT DISTINCT org.org_name, org.id,rel.manager_id, mgr.resource_manager
    FROM clarity_org as org
    JOIN clarity_relations rel on rel.org_ID = org.ID
    JOIN clarity_manager mgr on mgr.id = rel.manager_id

    WHERE resource_manager = '%MANAGERNAME%'

     

    I thank you in advance for any guidance on what I may be missing here.



  • 2.  Re: Report Data Object Variable Solution Needed

    Posted Mar 01, 2017 03:40 PM

    Is data returned when executing the query in SQL management studio? If so, you could check %USMHOME%\logs\view.log and error.log after doing the 'Save & Test' for any errors. Perhaps the Catalog database user (i.e. mdbadmin) does not have access to these tables?