Topic
  • 1 reply
  • Latest Post - ‏2010-08-12T18:08:06Z by SystemAdmin
SystemAdmin
SystemAdmin
53 Posts

Pinned topic How do you display a FileNet CE choice list on an eForm?

‏2010-08-12T16:06:57Z |
We have huge amount of dyanmic choice lists, and I trying to use the lookup feature to display the choices within an eForm so I will not have to maintain them in 2 locations. Has anyone attempted this option? I can get the look LOOKUP to display all results from the CvlElement table but I am unable to get the results from the lookup to filter by the Parent_Id field so I only have the results from a specific choice list.
Updated on 2010-08-12T18:08:06Z at 2010-08-12T18:08:06Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    53 Posts

    Re: How do you display a FileNet CE choice list on an eForm?

    ‏2010-08-12T18:08:06Z  
    I figured out the look up to do this, the only issue is as follows:

    To trigger the lookup you must type something in the cell and hit tab. Does anyone know how to automatically trigger the lookup without the typing?

    here is the code to pull the choice list from the CE

    select val_string
    from CvlElement
    where parent_id = 'PARENT_ID GUID' order by val_string;
    <<1@Cell8>>