Forum Discussion

FlorisvdPoel's avatar
FlorisvdPoel
New Contributor III
2 months ago

Dashboard for certification question responses

Hi everyone,

I would like to create a table with an overview of the answers given to the certification questions in the certify steps per entity.

Does anybody have experience with this? I think this data is stored in one of the application tables. I was wondering if this is the 'CertifyQuestionInstances' table. Would there then be a way to translate the keys into readable data? 

Any help would be appreciated.

Thanks a lot.

Floris

Dashboards
Reports
  • db_pdx's avatar
    db_pdx
    2 months ago

    Hi FlorisvdPoel: yes, we do this for a month-end close review dashboard.  We use a grid view to display the question and response.

    The key piece is the data adapter which is:

    • Command Type: Method
    • Method Type: CertificationForWorkflowUnit
    • Method Query: {YourWorkflowName.YourWorkflowStep}{YourScenario}{TimePeriod}{True}{}
      • Tip: you can leave the method query blank and run the data adapter to get a hint on the syntax

    We also use this data adapter to create a print version of the same question/response for use in a PDF of the month-end close package.

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    2 months ago

    Hi FlorisvdPoel: yes, we do this for a month-end close review dashboard.  We use a grid view to display the question and response.

    The key piece is the data adapter which is:

    • Command Type: Method
    • Method Type: CertificationForWorkflowUnit
    • Method Query: {YourWorkflowName.YourWorkflowStep}{YourScenario}{TimePeriod}{True}{}
      • Tip: you can leave the method query blank and run the data adapter to get a hint on the syntax

    We also use this data adapter to create a print version of the same question/response for use in a PDF of the month-end close package.