Skip to main content
December 26, 2022
Question

How to store task report data into DB

  • December 26, 2022
  • 9 replies
  • 0 views

Hi Everyone,

I have the requirement to capture the task report data into the database. Can anyone please help me out?

Thank you

    9 replies

    susmethaasirir1117
    December 26, 2022

    We have execute process report smart service or Query process analytics to get data from TasksReportand design a batch process to save data

    December 28, 2022

    Thanks Susmetha,

    Could you please explain it a bit more?

    gopalk2865
    December 28, 2022

    hi, You can use query process analytics to get the report data and then create a table to store required fields from this report data. once you have these two then create a batch process and configure the timing based on your convenience and run this process to store report data to db. This process will have the script task which will pull the report data and a write to db node which will store this data to the table.