First and foremost – It is a great tool. Thank you for making this available.
I have an issue with querying the following database fields from the maximo.dbo.workorder table:
percentcomplete, projectmanager, projectstreetaddress, projectamt
The query won’t return me the values for these fields for any given workorder. Once the values are retrieved, I plan to modify it, if needed and add sync / sync it back with the maximo application. I tried adding some test values to send the data back and it wont update/add either.
Can you please guide why would these values not update in Maximo. Possibly there are some settings in application that are ignoring these fields? If so, where should I check and what should I change?
Thank you