I have values saved in the order information screen custom fields. I need to retrieve them from the database, but I can't seem to find them. (Label, value)
The custom fields from the other screens are in the entity table but these are not there.
Thanks
Accessing custom fields in order information screen
Moderator: Lisa Ennis
-
- Posts: 18
- Joined: Thu Jun 16, 2016 2:45 pm
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Accessing custom fields in order information screen
The order information screen has lots of business objects (Order, Loan, Property, Contacts), so they may be on a different object than Order. In your custom field manager, double check which object they were added to. Also, you will only see the tags in the XML if there is data actually entered in the field, it won't be there for every order. Once you determine the object, you will use the type# field to determine the object in the Entity table.
Lisa Ennis
Senior Report Developer
SoftPro
Senior Report Developer
SoftPro