Home Home
  login

Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Dynamic refresh of dropdown list

custom-fields

I have a drop down custom field based on a view. The underlying table data changes, and the view changes accordingly but the drop down doesn't refresh. However I can make it refresh by clicking the cog icon on the custom fields admin page. How can i make it refresh dynamically?
cpf_jg
· 1 		cpf_jg
Tuesday, November 13, 2012, 4:11:07 PM
Replies (7)
helpful
0
not helpful

Which version of Gemini? The dropdown should refresh when the table does.
Mark Wing
· 9108 		Mark Wing
Tuesday, November 13, 2012, 5:18:57 PM
helpful
0
not helpful

Gemini 5.1.1
cpf_jg
· 1 		cpf_jg
Tuesday, November 13, 2012, 5:29:48 PM
helpful
0
not helpful

Can you try and recycle the application pool? Does it refresh?
Mark Wing
· 9108 		Mark Wing
Tuesday, November 13, 2012, 5:42:18 PM
helpful
0
not helpful

No. Neither recycling nor stopping and restarting the gemini application pool makes any difference.


cpf_jg
· 1 		cpf_jg
Tuesday, November 13, 2012, 6:08:38 PM
helpful
0
not helpful

Ok, please run the following SQL (replacing the custom field name) and post the result:

select lookupdata,* from gemini_customfielddefinitions where customfieldname='YOUR CUSTOM FIELD NAME HERE'

Mark Wing
· 9108 		Mark Wing
Tuesday, November 13, 2012, 6:13:18 PM
helpful
0
not helpful

lookupdata customfieldid customfieldname screenorder screenlabel screendescription screentooltip maxlen canmultiselect regularexp customfieldtype lookupname lookupvaluefield lookuptextfield lookupsortfield projectidfilter created tstamp showinline lookupdata maxvalue minvalue listlimiter usedin templateid usestaticdata canfilter 37006 IN ACE2 37006 OUT not allocated 42600 IN not allocated 42600 OUT not allocated (... many more lines...) 56 JEJourney 0 Journey reference Select the affected journey 0 0 C customjejourneys bookingId PCSref PCS_ref 0 2012-10-19 11:40:05.710 0x00000000003D533D 0 NULL NULL 0 18 0 1

Meanwhile the top rows of the table have moved on to BookingID PCS_ref 33199 IN 33199 IN APLEREG2 33199 OUT 33199 OUT not allocated 34534 IN 34534 IN APLEREG2 34534 OUT 34534 OUT not allocated

So column lookupdata is not being refreshed when the table changes
cpf_jg
· 1 		cpf_jg
Thursday, November 15, 2012, 8:56:32 AM
helpful
0
not helpful

We cannot read this properly can you send an attachment to support@countersoft.com?
Mark Wing
· 9108 		Mark Wing
Thursday, November 15, 2012, 9:15:04 AM