2. PHPRunner General questions
  3. read only date won't show with picker in search?
This topic is locked

read only date won't show with picker in search?

 		2/2/2009 5:57:54 PM
PHPRunner General questions
U
 Urnso author

I have some pages where I have the date field set with now() in the default value and to readonly.
On the advanced search pages these fields do not show with the picker.
Is there a way to make the field read only on the add and edit page but still use the picker on the advanced search? Thx!
J
 		Jane 2/3/2009

Hi,
edit SQL query on the Edit SQL query tab for this purpose.

Here is a sample:

select field1,

field1 as field1_search,

...

from TableName


Then check off field1_search on the advanced search page only on the Choose fieldstab and set up it as text on the Visual Editor tab.