I’m trying to add columns to the time phase screen in the time phase data grid.
I want to be able to populate these columns with data from the associated job.
I was able to do this with a UI customization and it works well however it’s a bit slow.
I’m iterating through each row and if there is a job number I use the Job Adapter to get the job and then pull what I need out of JobHead.
I thought this might be faster I do it in a BPM.
I created a Post Processing directive on GoProcessTimePhase.
I am trying to add DataColumns to result.TimePhas but I get an error that DataColumn cannot be converted to IceColumn. I can’t create IceColumn because it’s an abstract class.
Is what I’m trying to do even possible? If yes, how can I add columns to result.TimePhas
I’m not even sure if this will cause the UI to puke but I haven’t gotten that far.
You could add UD Fields to the TimePhas table, then populate them in the dataset using your BPM. The fields in the database itself would remain empty. They should then be available in a UI customization. Not sure if GoProcessTimePhase is the right choice for the method. Typically it would be a post-process on GetRows.
I have done this for PO Suggestions for a similar reason. Adding custom data to a large number of rows via Client Customization is too slow.
Thanks Andrew. I was thinking where the TimePhas table isn’t a table that holds data that I wouldn’t be able to add UD fields. I probably should have look. I will try this out.
So I tried Andrew’s approach. I added the UD Columns to table TimePhas, regen’d data model, recycled app pool.
The dataview for TimePhas does not have my UD columns so I can’t reference them
I wondered… thanks for confirming, sorry it didn’t work. The only other posts I’ve seen on here are completely re-doing the grid. It looked like a bit of customization.