I am adding a column to a native grid, iterating through all rows and inserting data into the column. It takes an absolute age especially when rows exceed a few hundred. I have tried adding following lines but doesn’t seem to make a difference:
I tried this a couple years ago and ran into the same thing. I think it was trying to get Part table info into a grid of JobMtl data in Job Tracker (or something similar). My code “worked” but was too slow to put into production.
I ended up scrapping the customization and using a BPM. The BPM ran on the GetByID method used in Job Tracker/Entry (forget the name). It queried the database with some LINQ code, and then wrote values to UD fields on ttJobMtl. The UD fields were already part of the JobMtl grid’s dataset, so no more need to add a column via customization. These UD fields were really just placeholders for this workaround; they served no purpose outside of the Job Tracker screen.
It felt like a bit of a hack at the time, but it worked and was fast. Would have preferred to keep everything in a customization, but I just wasn’t getting anywhere with that approach.
Thanks Tom, I explored BPM route but the grid is not directly linked to a table so not sure how to get access to a UD field. In the end I used an adapter to get the dataset a query to get additional data and a custom grid to display results. Not ideal but should be ok.