We have a formula field that we want to change to a text field. We know we can't do this directly, so we need to create a new text field, then we'd remove the formula field.
What we'd like to do is programatically add the new field into any private list views that any of our 2500 users might have set up (getting them to do it manually wouldn't be palatable.)
We were hoping that we could run some SOQL against our Live Org to extract all the Private List views containing this field (or perhaps pull them from the server using Mavens Mate or similar) and then we could amend them with the new field then push them back up to Live using ANT.
However if doesn't appear that Private List views are available through the Metadata API.
Does anyone know if what we'd like to do is possible? Or is there another way? We're very comfortable with ANT, Apex, SOQL.
Any help or suggestions gratefully received!
Thanks in advance, Scott