Skip to main content
H
hoaphan
Newcomer
February 18, 2022

Confirmation rule - display Information

  • February 18, 2022
  • 2 replies
  • 0 views

Hi everyone, 

When we run a confirmation step, we have a DB to show all confirmation passed or failed 

and when it failed we have Information 1, 2, 3, but with this DB we can only see confirmation rule by confirmation rule. This point is very inconvenient if you have more than 10 entities in your WF

I have a another DB to show all confirmation rule by entity, this is very helpful for the user but I would like to add Information 1,2,3 from table 1 to the table 2 (as image) 

Do you have any idea with which table I can take these column ? maybe I can joint 2 tables of sql and create a new one with all information 

Table 1: I dont know where I can find it

Table 2: this table is native in Onestream 

hoaphan_2-1645202759776.png

 

Thank you for your help 

Have a nice weekend 🙂

Hoa PHAN 

 

 

 

 

2 replies

D
db_pdx
Contributor
February 21, 2022

Hi Hoa Phan: I believe the data you are after can be obtained using a Method Query.

You'll need a: Data Adapter (Command Type: Method Query, Method Type: ConfirmationForWorkflowUnit). The method query syntax is {Workflow Profile Name}{Scenario Name}{Time Name}{IncludeDescendants}{Filter}.  More information and an example can be found in the Design and Reference Guide > Presentation > Method Query section.

The output of this will be a datatable that you can then use in a GridView or Studio Report.

Hope this helps.  Cheers -DB

H
hoaphanAuthor
Newcomer
February 22, 2022

Hi DB, 

Thankyou for your answer

Your data adapter is my second table, the information I need comes from the first table : args.ConfirmationRuleArgs.Info1 (from confirmation rule) 

And I would like to connect 2 tables but I dont know where the first table comes from

thanks 

Hoa PHAN

N
OneStream Employee
NickKroppeOneStream Employee
OneStream Employee
February 22, 2022

Hi, the custom fields can be exposed via the ConfirmEntityInstanceInfo object in a dashboard dataset rule. This information also naturally lives in the application database table called ConfirmRuleInstances.

 

Regards,

 

Nick Kroppe

Terms & ConditionsAccessibility statement