I want to add the tables sys_history_set and sys_history_line to the view and generate drop down list... How can I do that?

[srirampappagudi]

Hi Experts,

I want to add the tables sys_history_set and sys_history_line to the view and generate reports drop down list... How can I do that?

I understand that any custom table I create gets automatically added but these System Tables are not visible in the list.

Is there any option to manually add these tables to the reporting module?

Kindly check and help.

Thank you,

Sriram.

[sergiu_panaite]

There are some system tables that are not supposed to be used for reporting. What is the reason you need these tables for reporting? On top of that, these tables are rotated every month, so data is not kept forever.

[Chuck Tomasi]

Hi Sriram,

At this point, there is no option for doing this manually. This is done to avoid performance reasons. These are big tables - some of the biggest in the system.

If you must report on these tables, you can do so by going to the table list by typing tablename.list in the navigation filter and right clicking on the list header to create a new report there (e.g. Bar chart). Once you are there, you can change the report parameters all you like.

[Chuck Tomasi]

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thank you

[srirampappagudi]

Hi Chuck,

Thanks for your valuable answers.

I have one more requirement which is related to these audit tables.

I want to calculate how many times a ticket has been put "OnHold" with particular reason value.

This is a reporting requirement. Please help.

Regards,

Sriram.