Task SLA report Generation

siddeshkogundi
Tera Contributor

‎07-05-2023 07:33 AM

HI team,

 

We have an requirement as below,

 

1. There are task sla creation for catalog task

2. Need to generate dynamic report on the task sla table in the such a way that 

3. There is a select box variable for the item based on those options the report should be dynamic

 

I have tried the below scenario and if anything is wrong here please correct me and also open to have any other approach of achieving this

 

I have Created a data base view for the tables sc_req_item, sc_item_option, sc_item_option_mtom, sc_task, task_sla

 

and created report for the database view table and also created the Dynamic content for the variable option and attached the script for the dynamic content.

 

Please help me to achieve this requirement 

 

Open for any suggestions or new idea.

 

Thanks in Advance,

Siddesh

 

0 Helpfuls
  • 514 Views
1 REPLY 1

Ratnakar7
Mega Sage
Mega Sage

‎07-05-2023 08:54 AM

Hi @siddeshkogundi ,

 

You can follow these steps:

  1. Create a Database View:

    • Create a database view that joins the tables sc_req_item, sc_item_option, sc_item_option_mtom, sc_task, and task_sla. This view will combine the necessary data from these tables into a single view that can be used for reporting.

  2. Configure the Report:

    • Create a report using the database view you created in the previous step.
    • Define the columns and filters you want to include in the report.
    • Customize the report layout and formatting as needed.

  3. Dynamic Content for Variable Option:

    • In the catalog item, configure the select box variable that will be used to filter the report.
    • Create a new Dynamic Content script for the select box variable.
    • In the script, retrieve the available options for the select box based on your criteria (e.g., querying a table, using a data source).
    • Return the options as an array in the expected format for a select box variable.

  4. Attach Dynamic Content Script:

    • In the catalog item, navigate to the form section where the select box variable is defined.
    • Open the variable in question and go to the Advanced view.
    • In the Variable Attributes section, locate the "Dynamic content" field and select the Dynamic Content script you created in the previous step.

Thanks,

Ratnakar

0 Helpfuls