Reporting and Analytics for Service

Get Involved. Join the Conversation.

Topic

    Scott Heidenreich
    Report information about custom objectsAnswered
    Topic posted December 17, 2018 by Scott HeidenreichGold Medal: 3,500+ Points 
    57 Views, 11 Comments
    Title:
    Report information about custom objects
    Summary:
    How do I report a list of all my custom objects and the descriptions
    Content:

    Hello,

    I'm trying to get a list of all the custom objects I've created, along with the fields in the objects and the description fields that were entered each time an object and field was created.

    It appears a lot of the information is stored in the co_classes table - but I don't see how to add that to the analytics, it refuses to let me use the table.

    Thanks for your help.

    Scott

     

    Version:
    19C

    Best Comment

    Sebastiaan Draaisma

    No, that is not a valid query. The table names mentioned in the data dictionary are different from those available in the CCOM

    I still believe your report can be made through custom scripts but it will require some coding...
    Unfortunately not something OOB...

    Comment

     

    • Sebastiaan Draaisma

      Hi Scott

      I'm afraid the default tables available for custom objects in Analytics won't be much of help here.
      I think you will hae to create your own report from scratch using ROQL. I will attach such a report created to report on Holidays set within the system.

      The ROQL query information for CO can be found in this documentation within the Sample Code -> Custom objects sample code

      $rmas = RNCPHP\ROQL::queryObject("SELECT CO.RMA from CO.RMA")->next();
      

       

    • Scott Heidenreich
      Thank you.  I appreciate the help.  It should help a lot.
      
    • Scott Heidenreich

      I looked around and tried a few things - with no success on the objects I'm interested in.

      What I want to do is create a report that provides a listing of my custom objects, their packages, the descriptions for each custom object.  I believe the objects I need for this are:

      Custom Attributes (co_attributes)

      Custom Class Packages (co_packages)

      Custom Classes (co_classes)

      Custom Object Descriptions (co_descriptions)

      Custom Object Labels (co_labels)

      But I haven't been able to get a simple query on co_classes to return just the name field as a starting point.  I also didn't see any documentation for co_classes. So maybe it just isn't a table that can be queried?

    • Sebastiaan Draaisma

      Hi Scott

      Yes, they can be queried, I have not done this myself (yet) but this page sugests you can.
      It will give you all the package names in an array after which you should be able to dig deeper into your data (once you have your package & object name)

      https://<YOUR_SITE>.custhelp.com/ci/admin/explorer

    • Scott Heidenreich

      I see that might get me the metadata for a single object, but I may not be understanding what I'm seeing.  What I'm trying to do is build a report that will provide selected metadata for all my custom objects.  I'm trying to create an object listing with the package information and description something like this:

      Package Class Description
      OPA PropertyInfo Contains information about each physical location associated with an incident
      OPA Material Contains information about the materials spilled, stored, or dumped on the property
      OPA NearByItems Contains information about nearby items of interest for siting and risk assessments
      OPA2 GrantOpenAndClose Used to define the annual open and close period for each OPA grant model.
      etc.    

      Eventually, I'd like to be able to add all the field names to the report for each object along with the description for each field.

      Then I would slice the report by class and add docked filters to create an interactive data dictionary of sorts for my Admins, developers, and analytics editors.  I was hoping to do this as a report in OSvC so that it is available on demand as the system is being configured or analytics being created.

      The objects I would be using to get the metadata are not custom objects, they are system objects managed by OSvC that include the metadata for the custom objects I've built, at least that seems to be how I would do it, just join the system objects I listed above.

    • Scott Heidenreich

      This query doesn't work:

      Select ID from co_classes LIMIT 25

       

    • Sebastiaan Draaisma

      No, that is not a valid query. The table names mentioned in the data dictionary are different from those available in the CCOM

      I still believe your report can be made through custom scripts but it will require some coding...
      Unfortunately not something OOB...

    • Scott Heidenreich

      That's too bad.  It's frustrating that OSvC doesn't give us the ability out of the box to provide information about our custom queries.  The description information for each custom object and field is stored in there, and it is extremely useful to be able to aggregate it from all the objects and fields for creating a searchable data dictionary, so admins, developers, and analytics creators can more easily find which custom objects they are looking for.

      Thank you for your help.

      best regards,

      Scott

    • Sebastiaan Draaisma

      I agree Analytics should not have any constrains and allow all data from the data dictionary to be used.
      All I can advice you is to create and vote for ideas in the idea lab...

      If you do create an idea in the lab, be sure to place a comment with the link in this topic to increase exposure.
      I myself would vote for it.

    • Scott Heidenreich

      Ok.  I added an idea in the idea lab:

      https://cloudcustomerconnect.oracle.com/posts/bfdc473659