Custom Table Visible on Reports

[Bhadley]

Hi All,

I've stumbled upon an issue i'm having and after a few days of stumbling around I figured I would ask the question here.

I have two custom tables, u_employee which is an extension off the Task Table and then a table called u_employeechange which extends off u_employee. My main goal is to get these tables visible in the reports so we can start reporting off these tickets that are submitted and various fields within them. As of right now neither of these tables are available in the drop down table selection for reporting.

A few avenues I've ventured down in trying to figure this out was first looking at the Access Control (ACL) and added a report_on entry along side the create, delete, read, and write entries. These are all set to itil role.

Next I tried looking at the Database views under System Definition, i created one but when I try to add either of these tables to this entry neither of these tables are visible as an option.

I am assuming I missed something when I created these tables, both of them were created in Calgary and we are currently in Eureka. I ran into this same issue following the wiki directions for text indexes to make this table searchable but neither of the tables was an option with this in the drop down. Anyone able to point me in the right direction on where I should be looking to get these tables visible in these functions?

Much appreciated!

[Mark Stanger]

The only thing that should be required to see the table in the drop down menu for reporting is the 'report_on' ACL.   Any other ACLs would just be to allow you to see the data in the tables.   Are you able to navigate to the tables normally outside of the reporting interface?   Can you see the data you want outside of the reporting interface?

[Bhadley]

Change to original post. The u_employeechange table is available on reporting. This doesn't have any added report_on ACL added to it. u_employee isn't showing up, even after creating a report_on ACL for this table. Compared both of these tables side by side and the only noticeable differences is that u_employeechange is an extension of u_employee.

I can access both tables through System Definition > Tables. I have both of them hooked up to an Employee module that holds these EMP tickets created through the Service Catalog. I can still create new records on both as well so they seem to be working fine.

Now that I see that u_employeechange is showing up in the reporting I am starting to wonder if there is something that was corrupt during the creation of u_employee table. It wouldn't be the first time that I've had data issues with a newly created table.

*edit: u_employee table shows up in System Definition > Tables but doesn't show up in System Definition > Tables & Columns

[Bhadley]

Further investigation on this I noticed within the System Definition > Dictionary there is no insert for the u_employee table for sys_id and the entry that is a collection. u_employeechange and the other tables seem to have this;

I came across these references when trying to figure out the Text Indexing as well so I am guessing it may all be related. Unfortunately I couldn't add these entries cause u_employee isnt in the drop down when using the New button on this page. Not sure if there is another way to create these or not, I would really like to avoid having to completely redo the table since it has been up and running for over a month in our Prod environment.