We are trying to move our Clinical Nurse evaluation process into an electronic format and one of the pieces is a simple little table that shows about a third of the criteria evaluated and a Y/N on whether they are eligible to move up on the clinical ladder. All I am trying to do right now is pull that list of criteria from the appraisal into a form that I can include in the PDF. I would even be happy if I could pull all the criteria, even the ones I don't want to see! My results so far are either one item or nothing. Mostly nothing.
The data I need is stored in the EmployeeAppraisalCriteriaResponse business class, and I can see all the data elements I want to display if I modify the EmployeeAppraisalCriteriaResponseList.
In order to get that data onto a form on the appraisal PDF, I am going to need that data in either the AppraisalFormSection or the AppraisalForm business class. AppraisalFormSection seems to offer more flexibility in terms of forms/places to put it.
I feel like the best results I had (don't quote me, I have tried a lot of things) were with a custom relation and a label, inside a derived field, something along these lines:
if CustomRelationRel.CrtieriaName = "CriteriaName"
return text of untranslatable:"<CustomRelationRel.CrtieriaName>-<CustomRelationRel.CrtieriaScore>"
but that is only going to return one criteria, and I need 13.
Thirteen** derived fields for this simple little list just seems ridiculous, there has to be a better way! **It will actually be 26, because then I need the score translated into the Y/N.
We are On Premise GHR, CU 25.
If you have done this, something like this, or have ideas I would love to hear them!
Thanks!
