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.

[Chuck Tomasi]

Hi Sriram,

For that requirement I would build the counter in to the record (like a modified count) and update it with a business rule.

Example: field label='Hold Count", name=u_hold_count, default value 0.

Business rule

Name: update hold count

When: before

Table: incident (or other table as appropriate)

Update; true

Insert: true

Advanced: true

Condition: current.state.changesTo(999) // change 999 to the value of your hold state

Script:

(function executeRule(current, previous /*null when async*/) {

        var holdCount = parseInt(current.getValue('u_hold_count'));

        holdCount++;

        current.u_hold_count = holdCount

})(current, previous);

[Chuck Tomasi]

Let me know if that answers your question or not.