Posted: 18 Jan 2018 21:09 EST Last activity: 19 Jan 2018 14:24 EST
How to add custom columns to Assign-WorkList
Can some one help me with how to add few columns (which are in pyWorkPage) to Assign-Worklist.
I have a requirement to generate the report. For this i need to join pyWorkPage with Assign-. But when i do this i am getting duplicate records due to some design issues. At this point of time i am not able to do the changes to the existing design. I feel if few columns related to pyWorkPage were available in Assign-Worklist then i can directly fetch the data from Assign-Worklist with out any join.
So i want to add few columns for each assignment in to Assign-Worklist.
Appreciate if some one can provide me step by step to achieve this.
I know its not suggested to customize Assign- but to me there is no other way.
***Updated by moderator: Lochan to add Categories***
Adding the columns to the class is easy enough. You just need to add the appropriate properties to the class and expose them in the database. I think where you will run into trouble is making sure they are populated. Flow processing doesn't set those values out of the box so you will need to own mapping the data there and keeping it up to date. Since the assignment objects get created and deleted each time you hit a new assignment shape in a flow, you will need to either manage this for the assignments you care about or do something like add a declare onChange or declare trigger to update the values automatically. Honestly, I think it will be less work and avoid the potential pitfalls associated with the above if you just fix your report to return the values you want after the join.