Forum Discussion

GenisDelPino's avatar
GenisDelPino
New Contributor
3 years ago

CertificationForWorkFlowUnit Data Adapter

Hi community

We are using Method Type CertificationForWorkFlowUnit in a data adapter for creating a Certification report 

This Method Type provides 3 data sources (as you see in the screen):

Currently, we have Profile Name, Question Name, etc in columns but all these fields are part of CertificationResults DataSource.

We are trying to include UserName filed column on Certification Result Dashboard, but we can’t because this line is part of another DataSource: CertificationResult_SignOff. 

Is there a way to include this Username Field? With a Join between data sources or another alternative?

Thanks

 

 

 

 

 

Dashboards
  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    Hello,

    The method query is a kind of SQL query build in OneStream for you. Now, if you do not see the value anywhere in the default method query then you should go back to SQL. 
    It is more challenging obviously, because that means that you have now to build your own SQL query. You can use JOIN like you suggested and put this into your data adaptor. 
    But has you can see, it is totally customized... and it is the case you are in. 
    If it helps, please give a kudo