cancel
Showing results for 
Search instead for 
Did you mean: 

CertificationForWorkFlowUnit Data Adapter

GenisDelPino
New Contributor

Hi community

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

image006.png

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

image001.png

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. 

image004.png

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

Thanks

 

 

 

 

 

1 REPLY 1

NicolasArgente
Contributor II

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