Custom Field

Discussions related to custom development with Select.
Post Reply
sanjay.mittal
Posts: 94
Joined: Mon Dec 28, 2009 3:43 pm

Custom Field

Post by sanjay.mittal »

Can you explain how does custom fields are stored in Select – Cameron? I see many entries in pfm.entity but not which one to use get the value out of a Custom Field.
John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Custom Field

Post by John Morris »

The custom fields on Cameron are stored in a the Custom# field of the pfm.Entity table. To find the field you want, you need to located the record using the GUID of the object where it was placed on.
John Morris
Sr. Software Architect
SoftPro
sanjay.mittal
Posts: 94
Joined: Mon Dec 28, 2009 3:43 pm

Re: Custom Field

Post by sanjay.mittal »

I have a custom field under Order object. How do I get the GUID of it?
John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Custom Field

Post by John Morris »

You need to use the guid of the order. There is a guid property on the order.
John Morris
Sr. Software Architect
SoftPro
sanjay.mittal
Posts: 94
Joined: Mon Dec 28, 2009 3:43 pm

Re: Custom Field

Post by sanjay.mittal »

I didn't find the GUID in the pfm.order table. Is it stored somewhere else?
John Morris
Posts: 411
Joined: Thu Sep 11, 2008 11:35 am
Location: Raleigh, NC, USA
Contact:

Re: Custom Field

Post by John Morris »

pf.Order
John Morris
Sr. Software Architect
SoftPro
Post Reply