<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt;color:#000000;"><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">Hi,</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">I have up to now used a hand written combobox to set search paramters (code below)</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">it works fine, but needs to be manually updated if something changes.</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0,
0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">Is there a simple way to dynamically fill the searchbox with values taken from the postgis db?</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">thanks,</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; ">Rob</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "><code></div><div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif">items: [{xtype:'combo',</font></div><div><font class="Apple-style-span" face="arial,
helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>id:"textfield_combo",</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> store: new Ext.data.SimpleStore({</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span>id: "0",</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> fields: ['abbr',
'action'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> data : [</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['*', '*'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['BS 1', 'BS 1'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 10', 'GF 10'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 12', 'GF
12'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 1a', 'GF 1a'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 2', 'GF 2'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 3', 'GF 3'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 4', 'GF 4'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 5', 'GF 5'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span
class="Apple-tab-span" style="white-space:pre"> </span>['GF 7', 'GF 7'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GF 9', 'GF 9'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS 2', 'GS 2'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS 3', 'GS 3'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS 4', 'GS 4'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS A', 'GS A'],</font></div><div><font
class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS B', 'GS B'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['GS C', 'GS C'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE 1', 'HE 1'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE 2', 'HE 2'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE 4', 'HE 4'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span"
style="white-space:pre"> </span>['HE 5', 'HE 5'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE 9', 'HE 9'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE B ehe-mals HE 6', 'HE B ehe-mals HE 6'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['HE B ehe-mals HE 8', 'HE B ehe-mals HE 8'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> ['PE 1', 'PE 1'],</font></div><div><font class="Apple-style-span" face="arial,
helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> ['PE 2', 'PE 2'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> ['PE 3', 'PE 3'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> ['PE 4', 'PE 4'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 5', 'PE 5'],</font></div><div><font
class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 6', 'PE 6'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 7', 'PE 7'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 8', 'PE 8'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 9', 'PE 9'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['PE 10', 'PE 10'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span"
style="white-space:pre"> </span>['PE 11', 'PE 11'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['SZ 1', 'SZ 1'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['SZ 2', 'SZ 2'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF A', 'WF A'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF D', 'WF D'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF E', 'WF E'],</font></div><div><font class="Apple-style-span"
face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF F', 'WF F'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF G', 'WF G'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF 4', 'WF 4'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF 5', 'WF 5'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF 7', 'WF 7'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WF
10', 'WF 10'],</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span>['WOB 1', 'WOB 1']</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space:pre"> </span> ]</font></div><div><font class="Apple-style-span" face="arial, helvetica, sans-serif"><span class="Apple-tab-span" style="white-space: pre; "> </span> }),</font></div></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; "></code></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 12pt; position: fixed; "></div>
</div></body></html>