# kexi__objectdata

o_sub_id: sql
o_data:
  SELECT firstname, lastname, address, wiki, email, city, state, yearsattend, sentspring2014 FROM public092215gnutokexi WHERE wiki = 'yes' AND sentspring2014 = '' AND yearsattend=""


o_data:
  <!DOCTYPE UI>
  <UI version="3.1" stdsetdef="1">
  <kfd:customHeader version="2"/>
  <pixmapinproject/>
  <class>QWidget</class>
  <widget class="QWidget">
  <property name="name">
  <string>form</string>
  </property>
  <property name="geometry">
  <rect>
  <x>0</x>
  <y>0</y>
  <width>1080</width>
  <height>750</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>211</red>
  <green>221</green>
  <blue>200</blue>
  </color>
  </property>
  <property name="dataSourcePartClass">
  <string>org.kexi-project.table</string>
  </property>
  <property name="dataSource">
  <string>public092215gnutokexi</string>
  </property>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>30</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>lastname</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>160</x>
  <y>30</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>firstname</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox3</string>
  </property>
  <property name="geometry">
  <rect>
  <x>400</x>
  <y>30</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>pass</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox4</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>80</y>
  <width>230</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>address</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox5</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>130</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>city</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox6</string>
  </property>
  <property name="geometry">
  <rect>
  <x>160</x>
  <y>130</y>
  <width>70</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>state</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox7</string>
  </property>
  <property name="geometry">
  <rect>
  <x>250</x>
  <y>130</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>zip</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox8</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>180</y>
  <width>220</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>email</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox9</string>
  </property>
  <property name="geometry">
  <rect>
  <x>260</x>
  <y>80</y>
  <width>630</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>yearsattend</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox10</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>310</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentfall2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox11</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>260</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentxmas2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox12</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>360</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>senthacs2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox13</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>410</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentspr2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox14</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>460</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentxmas2012</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox15</string>
  </property>
  <property name="geometry">
  <rect>
  <x>550</x>
  <y>30</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>wikipassnum</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox16</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>510</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentfall2012</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>10</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Last Name</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>164</x>
  <y>10</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>First Name</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label3</string>
  </property>
  <property name="geometry">
  <rect>
  <x>402</x>
  <y>10</y>
  <width>140</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Hacs Pass(how many)</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label4</string>
  </property>
  <property name="geometry">
  <rect>
  <x>555</x>
  <y>10</y>
  <width>139</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Wiki Pass (How many)</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label5</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>60</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Address</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label6</string>
  </property>
  <property name="geometry">
  <rect>
  <x>260</x>
  <y>60</y>
  <width>300</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Years Attended (See Legend below)</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label7</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>110</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>City</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label8</string>
  </property>
  <property name="geometry">
  <rect>
  <x>163</x>
  <y>110</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>State</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label9</string>
  </property>
  <property name="geometry">
  <rect>
  <x>254</x>
  <y>110</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Zipcode</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label10</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>160</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Email</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label11</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>293</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Fall 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label12</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>243</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Xmas 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label13</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>343</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Hacs 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label14</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>393</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Spring 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label15</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>443</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Xmas 2012</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label16</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>493</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Fall 2012</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label17</string>
  </property>
  <property name="geometry">
  <rect>
  <x>720</x>
  <y>140</y>
  <width>320</width>
  <height>50</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>67</green>
  <blue>138</blue>
  </color>
  </property>
  <property name="text">
  <string>Public Database</string>
  </property>
  <property name="font">
  <font>
  <family>Sans Serif</family>
  <pointsize>24</pointsize>
  <weight>75</weight>
  <bold>1</bold>
  <italic>0</italic>
  <underline>0</underline>
  <strikeout>0</strikeout>
  </font>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox17</string>
  </property>
  <property name="geometry">
  <rect>
  <x>260</x>
  <y>180</y>
  <width>70</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="font">
  <font>
  <family>Sans Serif</family>
  <pointsize>10</pointsize>
  <weight>75</weight>
  <bold>1</bold>
  <italic>0</italic>
  <underline>0</underline>
  <strikeout>0</strikeout>
  </font>
  </property>
  <property name="dataSource">
  <string>id</string>
  </property>
  </widget>
  <widget class="KexiDBPushButton">
  <property name="name">
  <string>button</string>
  </property>
  <property name="geometry">
  <rect>
  <x>440</x>
  <y>180</y>
  <width>90</width>
  <height>30</height>
  </rect>
  </property>
  <property name="onClickAction">
  <string>currentForm:edit_find</string>
  </property>
  <property name="text">
  <string>Find</string>
  </property>
  </widget>
  <widget class="KexiDBPushButton">
  <property name="name">
  <string>button2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>300</x>
  <y>670</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>249</red>
  <green>204</green>
  <blue>202</blue>
  </color>
  </property>
  <property name="onClickAction">
  <string>currentForm:edit_delete_row</string>
  </property>
  <property name="text">
  <string>Delete</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox18</string>
  </property>
  <property name="geometry">
  <rect>
  <x>900</x>
  <y>80</y>
  <width>80</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>wiki</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label18</string>
  </property>
  <property name="geometry">
  <rect>
  <x>900</x>
  <y>60</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Wiki Yes/No</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox19</string>
  </property>
  <property name="geometry">
  <rect>
  <x>600</x>
  <y>130</y>
  <width>110</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>ref</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label19</string>
  </property>
  <property name="geometry">
  <rect>
  <x>610</x>
  <y>110</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>ref</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox110</string>
  </property>
  <property name="geometry">
  <rect>
  <x>480</x>
  <y>260</y>
  <width>270</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>emailxmas2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label110</string>
  </property>
  <property name="geometry">
  <rect>
  <x>483</x>
  <y>243</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>email Xmas 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox111</string>
  </property>
  <property name="geometry">
  <rect>
  <x>480</x>
  <y>310</y>
  <width>270</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>emailfall2013</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label111</string>
  </property>
  <property name="geometry">
  <rect>
  <x>483</x>
  <y>293</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>email Fall 2013</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox112</string>
  </property>
  <property name="geometry">
  <rect>
  <x>480</x>
  <y>410</y>
  <width>270</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>addtoemaillist2013spr</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox20</string>
  </property>
  <property name="geometry">
  <rect>
  <x>490</x>
  <y>130</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>util</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label112</string>
  </property>
  <property name="geometry">
  <rect>
  <x>490</x>
  <y>110</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>util</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label113</string>
  </property>
  <property name="geometry">
  <rect>
  <x>265</x>
  <y>160</y>
  <width>70</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>ID</string>
  </property>
  </widget>
  <widget class="KexiDBPushButton">
  <property name="name">
  <string>button3</string>
  </property>
  <property name="geometry">
  <rect>
  <x>550</x>
  <y>180</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>192</red>
  <green>255</green>
  <blue>192</blue>
  </color>
  </property>
  <property name="onClickAction">
  <string>currentForm:data_save_row</string>
  </property>
  <property name="text">
  <string>Save</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox21</string>
  </property>
  <property name="geometry">
  <rect>
  <x>270</x>
  <y>30</y>
  <width>120</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>business_name</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label114</string>
  </property>
  <property name="geometry">
  <rect>
  <x>280</x>
  <y>10</y>
  <width>110</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Business Name</string>
  </property>
  </widget>
  <widget class="KexiDBPushButton">
  <property name="name">
  <string>button4</string>
  </property>
  <property name="geometry">
  <rect>
  <x>830</x>
  <y>250</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="onClickAction">
  <string>kaction:edit_findnext</string>
  </property>
  <property name="text">
  <string>Find Next</string>
  </property>
  </widget>
  <widget class="KexiDBPushButton">
  <property name="name">
  <string>button5</string>
  </property>
  <property name="geometry">
  <rect>
  <x>830</x>
  <y>210</y>
  <width>100</width>
  <height>30</height>
  </rect>
  </property>
  <property name="onClickAction">
  <string>kaction:edit_findprevious</string>
  </property>
  <property name="text">
  <string>Find Previous</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox22</string>
  </property>
  <property name="geometry">
  <rect>
  <x>340</x>
  <y>180</y>
  <width>90</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>phone</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label115</string>
  </property>
  <property name="geometry">
  <rect>
  <x>350</x>
  <y>160</y>
  <width>70</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Phone</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label116</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>295</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Comments</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox113</string>
  </property>
  <property name="geometry">
  <rect>
  <x>20</x>
  <y>560</y>
  <width>450</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>sentspring2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label117</string>
  </property>
  <property name="geometry">
  <rect>
  <x>23</x>
  <y>543</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Sent Spring 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label118</string>
  </property>
  <property name="geometry">
  <rect>
  <x>480</x>
  <y>390</y>
  <width>200</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Add to email list</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox24</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>360</y>
  <width>250</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>how_did_yo</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label1110</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>346</y>
  <width>220</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>How did you hear about show?</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox25</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>310</y>
  <width>250</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="frame">
  <bool>true</bool>
  </property>
  <property name="dataSource">
  <string>comments</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label22</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>500</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14s- Spring Wiki Wiki 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label23</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>520</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14j-  July Show 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label24</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>540</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14f-  Fall Wiki Wiki 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label25</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>560</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14x- Xmas Wiki Wiki 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label26</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>600</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14w- Waioli 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label27</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>470</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignHCenter|AlignTop</set>
  </property>
  <property name="text">
  <string>Years Attended Legend</string>
  </property>
  <property name="font">
  <font>
  <family>Sans Serif</family>
  <pointsize>9</pointsize>
  <weight>75</weight>
  <bold>1</bold>
  <italic>0</italic>
  <underline>0</underline>
  <strikeout>0</strikeout>
  </font>
  </property>
  </widget>
  <widget class="KexiFrame">
  <property name="name">
  <string>frame</string>
  </property>
  <property name="geometry">
  <rect>
  <x>500</x>
  <y>460</y>
  <width>260</width>
  <height>210</height>
  </rect>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label28</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>580</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14k- Fishcake 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label29</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>530</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>Deadbeats 2009 and earlier</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label210</string>
  </property>
  <property name="geometry">
  <rect>
  <x>510</x>
  <y>620</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>14c- Misc. Fairs 2014</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label211</string>
  </property>
  <property name="geometry">
  <rect>
  <x>800</x>
  <y>500</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignLeft|AlignTop</set>
  </property>
  <property name="text">
  <string>Send neighbor isles cards earlier</string>
  </property>
  </widget>
  <widget class="KexiFrame">
  <property name="name">
  <string>frame2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>790</x>
  <y>460</y>
  <width>260</width>
  <height>210</height>
  </rect>
  </property>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label212</string>
  </property>
  <property name="geometry">
  <rect>
  <x>10</x>
  <y>10</y>
  <width>240</width>
  <height>20</height>
  </rect>
  </property>
  <property name="alignment">
  <set>AlignHCenter|AlignTop</set>
  </property>
  <property name="text">
  <string>Notes</string>
  </property>
  <property name="font">
  <font>
  <family>Sans Serif</family>
  <pointsize>9</pointsize>
  <weight>75</weight>
  <bold>1</bold>
  <italic>0</italic>
  <underline>0</underline>
  <strikeout>0</strikeout>
  </font>
  </property>
  </widget>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox23</string>
  </property>
  <property name="geometry">
  <rect>
  <x>700</x>
  <y>30</y>
  <width>132</width>
  <height>30</height>
  </rect>
  </property>
  <property name="text">
  <string>wikiutil</string>
  </property>
  <property name="dataSource">
  <string>wikiutil</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label20</string>
  </property>
  <property name="geometry">
  <rect>
  <x>706</x>
  <y>10</y>
  <width>100</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Pass Ticket No.</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox26</string>
  </property>
  <property name="geometry">
  <rect>
  <x>390</x>
  <y>130</y>
  <width>80</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteBackgroundColor">
  <color>
  <red>255</red>
  <green>255</green>
  <blue>255</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>yearentered</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label119</string>
  </property>
  <property name="geometry">
  <rect>
  <x>390</x>
  <y>114</y>
  <width>84</width>
  <height>16</height>
  </rect>
  </property>
  <property name="text">
  <string>year entered</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox27</string>
  </property>
  <property name="geometry">
  <rect>
  <x>840</x>
  <y>30</y>
  <width>72</width>
  <height>30</height>
  </rect>
  </property>
  <property name="text">
  <string>pass15fused</string>
  </property>
  <property name="dataSource">
  <string>pass15fused</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label21</string>
  </property>
  <property name="geometry">
  <rect>
  <x>840</x>
  <y>10</y>
  <width>70</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>15f used</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox28</string>
  </property>
  <property name="geometry">
  <rect>
  <x>930</x>
  <y>30</y>
  <width>72</width>
  <height>30</height>
  </rect>
  </property>
  <property name="text">
  <string>pass15f</string>
  </property>
  <property name="dataSource">
  <string>pass15f</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label213</string>
  </property>
  <property name="geometry">
  <rect>
  <x>930</x>
  <y>10</y>
  <width>70</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>15f pass</string>
  </property>
  </widget>
  </widget>
  <includehints>
  <includehint>klineedit.h</includehint>
  <includehint>kpushbutton.h</includehint>
  </includehints>
  <layoutDefaults spacing="6" margin="11"/>
  <tabstops>
  <tabstop>label21</tabstop>
  <tabstop>label3</tabstop>
  <tabstop>label20</tabstop>
  <tabstop>label2</tabstop>
  <tabstop>label114</tabstop>
  <tabstop>label213</tabstop>
  <tabstop>label4</tabstop>
  <tabstop>label</tabstop>
  <tabstop>textBox27</tabstop>
  <tabstop>textBox15</tabstop>
  <tabstop>textBox21</tabstop>
  <tabstop>textBox23</tabstop>
  <tabstop>textBox2</tabstop>
  <tabstop>textBox3</tabstop>
  <tabstop>textBox28</tabstop>
  <tabstop>textBox</tabstop>
  <tabstop>label18</tabstop>
  <tabstop>label5</tabstop>
  <tabstop>label6</tabstop>
  <tabstop>textBox4</tabstop>
  <tabstop>textBox9</tabstop>
  <tabstop>textBox18</tabstop>
  <tabstop>label112</tabstop>
  <tabstop>label7</tabstop>
  <tabstop>label119</tabstop>
  <tabstop>label9</tabstop>
  <tabstop>label8</tabstop>
  <tabstop>label19</tabstop>
  <tabstop>textBox19</tabstop>
  <tabstop>textBox20</tabstop>
  <tabstop>textBox5</tabstop>
  <tabstop>textBox6</tabstop>
  <tabstop>label17</tabstop>
  <tabstop>textBox26</tabstop>
  <tabstop>textBox7</tabstop>
  <tabstop>label113</tabstop>
  <tabstop>label115</tabstop>
  <tabstop>label10</tabstop>
  <tabstop>textBox17</tabstop>
  <tabstop>button</tabstop>
  <tabstop>textBox22</tabstop>
  <tabstop>textBox8</tabstop>
  <tabstop>button3</tabstop>
  <tabstop>button5</tabstop>
  <tabstop>label12</tabstop>
  <tabstop>textBox110</tabstop>
  <tabstop>textBox11</tabstop>
  <tabstop>button4</tabstop>
  <tabstop>label110</tabstop>
  <tabstop>label11</tabstop>
  <tabstop>textBox111</tabstop>
  <tabstop>label116</tabstop>
  <tabstop>textBox25</tabstop>
  <tabstop>textBox10</tabstop>
  <tabstop>label111</tabstop>
  <tabstop>textBox24</tabstop>
  <tabstop>textBox12</tabstop>
  <tabstop>label1110</tabstop>
  <tabstop>label13</tabstop>
  <tabstop>label14</tabstop>
  <tabstop>label118</tabstop>
  <tabstop>textBox112</tabstop>
  <tabstop>textBox13</tabstop>
  <tabstop>textBox14</tabstop>
  <tabstop>label15</tabstop>
  <tabstop>label212</tabstop>
  <tabstop>label27</tabstop>
  <tabstop>label22</tabstop>
  <tabstop>label211</tabstop>
  <tabstop>textBox16</tabstop>
  <tabstop>label16</tabstop>
  <tabstop>label29</tabstop>
  <tabstop>label23</tabstop>
  <tabstop>label117</tabstop>
  <tabstop>label24</tabstop>
  <tabstop>textBox113</tabstop>
  <tabstop>label25</tabstop>
  <tabstop>label28</tabstop>
  <tabstop>label26</tabstop>
  <tabstop>label210</tabstop>
  <tabstop>button2</tabstop>
  </tabstops>
  </UI>


o_sub_id: sql
o_data:
  SELECT firstname, ' ' AS expr1, lastname, ' <' AS expr2, email, '>' AS expr3 FROM public092215gnutokexi WHERE NOT email = '' AND ((pass = 0 OR pass IS NULL) AND (wiki = 'yes') AND (wikipassnum IS NULL OR wikipassnum = 0)) ORDER BY email


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, wikipassnum, business_name, pass15f, pass15fused,pass15x FROM public092215gnutokexi WHERE wikipassnum > '0' ORDER BY pass15x


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, yearsattend, senthacs2013, senthacs2014, email FROM public092215gnutokexi WHERE email="" AND (yearsattend LIKE '%j%' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%s%' OR yearsattend LIKE '%x%') ORDER BY lastname


o_data:
  <!DOCTYPE UI>
  <UI version="3.1" stdsetdef="1">
  <kfd:customHeader version="2"/>
  <pixmapinproject/>
  <class>QWidget</class>
  <widget class="QWidget">
  <property name="name">
  <string>form</string>
  </property>
  <property name="geometry">
  <rect>
  <x>0</x>
  <y>0</y>
  <width>993</width>
  <height>804</height>
  </rect>
  </property>
  <property name="dataSourcePartClass">
  <string>org.kexi-project.query</string>
  </property>
  <property name="dataSource">
  <string>email</string>
  </property>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label4</string>
  </property>
  <property name="geometry">
  <rect>
  <x>550</x>
  <y>38</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Wiki Pass</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox15</string>
  </property>
  <property name="geometry">
  <rect>
  <x>550</x>
  <y>58</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>numwikipass</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox7</string>
  </property>
  <property name="geometry">
  <rect>
  <x>260</x>
  <y>158</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>zip</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox6</string>
  </property>
  <property name="geometry">
  <rect>
  <x>170</x>
  <y>158</y>
  <width>70</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>state</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label3</string>
  </property>
  <property name="geometry">
  <rect>
  <x>410</x>
  <y>38</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Hacs Pass</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label6</string>
  </property>
  <property name="geometry">
  <rect>
  <x>270</x>
  <y>88</y>
  <width>120</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Years Attended</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox9</string>
  </property>
  <property name="geometry">
  <rect>
  <x>270</x>
  <y>108</y>
  <width>320</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>yearsattend</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label9</string>
  </property>
  <property name="geometry">
  <rect>
  <x>260</x>
  <y>138</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Zipcode</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>58</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>lastname</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>170</x>
  <y>58</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>firstname</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label5</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>88</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Address</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox3</string>
  </property>
  <property name="geometry">
  <rect>
  <x>410</x>
  <y>58</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>pass</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox8</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>208</y>
  <width>220</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>email</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label7</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>138</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>City</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>38</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Last Name</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label10</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>188</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>Email</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox5</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>158</y>
  <width>130</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>city</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label8</string>
  </property>
  <property name="geometry">
  <rect>
  <x>170</x>
  <y>138</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>State</string>
  </property>
  </widget>
  <widget class="KexiDBLineEdit">
  <property name="name">
  <string>textBox4</string>
  </property>
  <property name="geometry">
  <rect>
  <x>30</x>
  <y>108</y>
  <width>180</width>
  <height>30</height>
  </rect>
  </property>
  <property name="paletteForegroundColor">
  <color>
  <red>0</red>
  <green>0</green>
  <blue>0</blue>
  </color>
  </property>
  <property name="dataSource">
  <string>address</string>
  </property>
  </widget>
  <widget class="KexiDBLabel">
  <property name="name">
  <string>label2</string>
  </property>
  <property name="geometry">
  <rect>
  <x>170</x>
  <y>38</y>
  <width>80</width>
  <height>20</height>
  </rect>
  </property>
  <property name="text">
  <string>First Name</string>
  </property>
  </widget>
  </widget>
  <includehints>
  <includehint>klineedit.h</includehint>
  </includehints>
  <layoutDefaults spacing="6" margin="11"/>
  <tabstops>
  <tabstop>label4</tabstop>
  <tabstop>textBox15</tabstop>
  <tabstop>textBox7</tabstop>
  <tabstop>textBox6</tabstop>
  <tabstop>label3</tabstop>
  <tabstop>label6</tabstop>
  <tabstop>textBox9</tabstop>
  <tabstop>label9</tabstop>
  <tabstop>textBox</tabstop>
  <tabstop>textBox2</tabstop>
  <tabstop>label5</tabstop>
  <tabstop>textBox3</tabstop>
  <tabstop>textBox8</tabstop>
  <tabstop>label7</tabstop>
  <tabstop>label</tabstop>
  <tabstop>label10</tabstop>
  <tabstop>textBox5</tabstop>
  <tabstop>label8</tabstop>
  <tabstop>textBox4</tabstop>
  <tabstop>label2</tabstop>
  </tabstops>
  </UI>


o_sub_id: sql
o_data:
  SELECT id, wiki, lastname, firstname, address, city, state, zip, yearsattend FROM public092215gnutokexi WHERE senthacs2013 IS NOT NULL AND yearsattend IS NULL ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, yearsattend, email FROM publicdatabase010614 WHERE address IS NOT NULL AND email IS NULL AND ((yearsattend LIKE '%13s%') OR (yearsattend LIKE '%13f%') OR (yearsattend LIKE '%13x%') OR (yearsattend LIKE '%12s%') OR (yearsattend LIKE '%12f%') OR (yearsattend LIKE '%12x%') OR (yearsattend LIKE '%11s%') OR (yearsattend LIKE '%11f%') OR (yearsattend LIKE '%11x%') OR (yearsattend LIKE '%10s%') OR (yearsattend LIKE '%10f%') OR (yearsattend LIKE '%10x%') OR (yearsattend LIKE '%09s%') OR (yearsattend LIKE '%09f%') OR (yearsattend LIKE '%09x%') OR (yearsattend LIKE '%08s%') OR (yearsattend LIKE '%08f%') OR (yearsattend LIKE '%08x%') OR (yearsattend LIKE '%13j%') OR (yearsattend LIKE '%12j%') OR (yearsattend LIKE '%11j%') OR (yearsattend LIKE '%10j%')) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT pass, lastname,firstname, business_name, address, city, state, zip,pass15j FROM public092215gnutokexi WHERE pass > 0 ORDER BY pass DESC, lastname


o_sub_id: layout
o_data:
  <!DOCTYPE kexireport>
  <kexireport>
   <report:content xmlns:report="http://kexi-project.org/report/2.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0">
    <report:title>Report</report:title>
    <report:script report:script-interpreter="javascript"></report:script>
    <report:grid report:grid-divisions="4" report:grid-snap="0" report:page-unit="in" report:grid-visible="1"/>
    <report:page-style report:print-orientation="portrait" fo:margin-bottom="25.199999999999989pt" fo:margin-top="21.599999999999994pt" fo:margin-left="28.346505799999999pt" fo:margin-right="28.346505799999999pt" report:page-size="Letter">predefined</report:page-style>
    <report:body>
     <report:section svg:height="39.519758700016659pt" fo:background-color="#ffffff" report:section-type="header-page-any">
      <report:label report:name="report:label13" report:horizontal-align="left" svg:x="472.536000000075717pt" svg:width="54.708479999999994pt" svg:y="21.256560000003404pt" report:caption="Passused" report:vertical-align="center" svg:height="10.496160000000000pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:line report:name="line10" svg:y1="35.248320000000000pt" svg:x1="4.251600000000000pt" svg:y2="35.248320000000000pt" svg:x2="542.551680000000033pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:label report:name="report:label7" report:horizontal-align="left" svg:x="172.080000000027582pt" svg:width="104.881680000000003pt" svg:y="21.259440000003394pt" report:caption="BusinessName" report:vertical-align="center" svg:height="10.499040000000001pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label1" report:horizontal-align="center" svg:x="185.102640000029623pt" svg:width="162.992160000000013pt" svg:y="0.000000000000000pt" report:caption="HACS Passes July 2015" report:vertical-align="center" svg:height="12.471840000000000pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label2" report:horizontal-align="left" svg:x="0.000000000000000pt" svg:width="63.779040000000002pt" svg:y="21.259440000003394pt" report:caption="Last Name" report:vertical-align="center" svg:height="10.499040000000001pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label3" report:horizontal-align="left" svg:x="88.560000000014156pt" svg:width="70.866000000000000pt" svg:y="21.259440000003394pt" report:caption="First Name" report:vertical-align="center" svg:height="10.499040000000001pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label4" report:horizontal-align="left" svg:x="386.640000000061775pt" svg:width="63.779040000000002pt" svg:y="21.259440000003394pt" report:caption="# of Passes" report:vertical-align="center" svg:height="10.499040000000001pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label12" report:horizontal-align="left" svg:x="317.520000000050800pt" svg:width="46.079999999999998pt" svg:y="21.259440000003394pt" report:caption="Pass#" report:vertical-align="center" svg:height="10.499040000000001pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
     </report:section>
     <report:detail>
      <report:group report:group-sort="descending" report:group-column="pass"/>
      <report:section svg:height="15.030000000006794pt" fo:background-color="#ffffff" report:section-type="detail">
       <report:field report:item-data-source="pass15j" report:name="report:field14" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="473.386320000075727pt" svg:width="71.280000000000001pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.902320000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:line report:name="line12" svg:y1="12.959999999999999pt" svg:x1="5.249520000000000pt" svg:y2="12.959999999999999pt" svg:x2="540.567360000000008pt" report:z-index="0">
        <report:line-style report:line-style="dot" report:line-weight="1" report:line-color="#000000"/>
       </report:line>
       <report:field report:item-data-source="business_name" report:name="report:field8" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="172.080000000027582pt" svg:width="135.212400000000002pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.905200000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="lastname" report:name="field5" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="0.850320000000000pt" svg:width="75.117599999999996pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.905200000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="firstname" report:name="field6" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="90.708480000014504pt" svg:width="70.866000000000000pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.905200000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="pass" report:name="field7" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="398.255760000063731pt" svg:width="65.993039999999993pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.905200000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="wikiutil" report:name="report:field12" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="318.960000000051025pt" svg:width="64.799999999999997pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="11.902320000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
      </report:section>
     </report:detail>
    </report:body>
   </report:content>
   <connection type="internal" source="hacpass15j"/>
  </kexireport>


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, yearsattend, email, wiki, sentspring2014 FROM public092215gnutokexi WHERE not sentspring2014="" ORDER BY yearsattend


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, util, wiki, wikipassnum, yearsattend, email FROM public092215gnutokexi WHERE util = '' AND email = '' AND wikipassnum IS NULL AND ((yearsattend LIKE '%s%') OR (yearsattend LIKE '%f%') OR (yearsattend LIKE '%x%') OR (yearsattend LIKE '%w%') OR (yearsattend LIKE '%k%') OR (yearsattend LIKE '%c%') or wiki="yes") ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, email, sentxmas2013, yearsattend FROM public092215gnutokexi WHERE (not sentxmas2013="" OR yearsattend LIKE '%13x%') ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT firstname, ' ' AS expr1, lastname, ' <' AS expr2, email, '>' AS expr3 FROM public092215gnutokexi WHERE city="web13" ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT firstname, ' ' AS expr1, lastname, ' <' AS expr2, email, '>' AS expr3 FROM public092215gnutokexi WHERE sentspring2014 IS NULL AND wiki = 'yes' AND email LIKE '%@%' AND (yearsattend LIKE '%j%' OR yearsattend LIKE '%s%' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%x%') ORDER BY email


o_sub_id: sql
o_data:
  SELECT lastname, ' ',firstname,' ', address,' ', email,' ', yearsattend FROM fromapproach031014 ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, email, sentfall2013, yearsattend, sentxmas2013 FROM public092215gnutokexi WHERE ref = 'printed13x' ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, yearsattend, senthacs2012 FROM public092215gnutokexi WHERE senthacs2012 IS NOT NULL AND yearsattend IS NOT NULL AND not address="" ORDER BY lastname, firstname


o_sub_id: layout
o_data:
  <!DOCTYPE kexireport>
  <kexireport>
   <report:content xmlns:report="http://kexi-project.org/report/2.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0">
    <report:title>Report</report:title>
    <report:script report:script-interpreter="javascript"></report:script>
    <report:grid report:grid-divisions="4" report:grid-snap="1" report:page-unit="in" report:grid-visible="1"/>
    <report:page-style report:print-orientation="landscape" fo:margin-bottom="28.346505799999999pt" fo:margin-top="28.346505799999999pt" fo:margin-left="0.000000000000000pt" fo:margin-right="0.000000000000000pt" report:page-size="A5">predefined</report:page-style>
    <report:body>
     <report:detail>
      <report:section svg:height="522.000000000041723pt" fo:background-color="#ffffff" report:section-type="detail">
       <report:field report:item-data-source="=field.value(&quot;firstname&quot;)+&quot; &quot;+field.value(&quot;lastname&quot;)+&quot;\n&quot;+field.value(&quot;address&quot;)+&quot;\n&quot;+field.value(&quot;city&quot;)+&quot;, &quot;+field.value(&quot;state&quot;)+&quot; &quot;+field.value(&quot;zip&quot;)" report:name="report:field1" report:word-wrap="1" report:can-grow="0" report:horizontal-align="left" svg:x="306.000000000000000pt" svg:width="233.997120000000024pt" svg:y="126.000000000000000pt" report:vertical-align="center" svg:height="90.000000000000000pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
      </report:section>
     </report:detail>
    </report:body>
   </report:content>
   <connection type="internal" source="test"/>
  </kexireport>


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, yearsattend, senthacs2012, email FROM public092215gnutokexi WHERE (NOT address = '' OR address IS NOT NULL) AND (email = '' or email is null) AND (yearsattend LIKE '%13j%' OR yearsattend LIKE '%12j%' OR yearsattend LIKE '%11j%' OR yearsattend LIKE '%10j%' OR yearsattend LIKE '%09j%' OR yearsattend LIKE '%08j%' OR yearsattend LIKE '%07j%' OR yearsattend LIKE '%06j%' OR yearsattend LIKE '%07f%' OR yearsattend LIKE '%08f%' OR yearsattend LIKE '%09f%' OR yearsattend LIKE '%10f%' OR yearsattend LIKE '%11f%' OR yearsattend LIKE '%12f%' OR yearsattend LIKE '%13f%' OR yearsattend LIKE '%09x%' OR yearsattend LIKE '%10x%' OR yearsattend LIKE '%11x%' OR yearsattend LIKE '%12x%' OR yearsattend LIKE '%13x%' OR yearsattend LIKE '%07s%' OR yearsattend LIKE '%08s%' OR yearsattend LIKE '%09s%' OR yearsattend LIKE '%10s%' OR yearsattend LIKE '%11s%' OR yearsattend LIKE '%12s%' OR yearsattend LIKE '%13s%' OR yearsattend LIKE '%14s%') ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, email, util, senthacs2013, yearsattend, wiki, wikipassnum, pass FROM public092215gnutokexi WHERE ((senthacs2013 IS NOT NULL OR NOT senthacs2013 = '') AND email IS NULL) AND (util = '' OR util IS NULL) OR yearsattend LIKE '%w%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%c%' ORDER BY yearsattend


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, yearsattend, senthacs2013, email, pass FROM public092215gnutokexi WHERE yearsattend IS NOT NULL


o_sub_id: sql
o_data:
  SELECT lastname, firstname, email, address, city, state, zip, yearsattend, how_did_yo, senthacs2012, senthacs2013, pass, comments FROM public092215gnutokexi WHERE (yearsattend = '12j' AND senthacs2013 IS NULL and email is null) OR (yearsattend = '13j' AND senthacs2013 IS NULL and email is null) OR (yearsattend = '11j' AND senthacs2013 IS NULL and email is null) order by lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, yearsattend, senthacs2013, email, pass FROM public092215gnutokexi WHERE (senthacs2013 IS NOT NULL AND NOT senthacs2013 = '' AND email IS NULL) OR (yearsattend like '%13j%' AND email IS NULL) OR (yearsattend like '%12j%' AND email IS NULL) OR (yearsattend like '%11j%' AND email IS NULL) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, email, wikipassnum, yearsattend, wiki, sentspring2014, pass, util FROM public092215gnutokexi WHERE sentspring2014 IS NOT NULL and not address="" ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, sentspring2014, yearsattend FROM publicdatabase010614 WHERE yearsattend LIKE '%14s%' and wiki="yes" AND sentspring2014 IS NULL ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, email, wiki, addtoemaillist2013spr, yearsattend, sentspring2014, wikipassnum FROM public092215gnutokexi WHERE (yearsattend LIKE '%14j%' OR yearsattend LIKE '%14s%' OR yearsattend LIKE '%13x%' OR yearsattend LIKE '%13f%') AND wiki = 'yes' AND email = '' AND (wikipassnum IS NULL OR wikipassnum="") ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip FROM public092215gnutokexi WHERE zip = '96822' AND email IS NULL AND wiki IS NULL AND util IS NULL AND yearsattend IS NULL AND pass IS NULL ORDER BY lastname, firstname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, util, email, wikipassnum, yearsattend, wiki, sentspring2014 FROM public092215gnutokexi WHERE sentspring2014 IS NOT NULL ORDER BY util


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, util, email, wikipassnum, yearsattend, wiki, sentspring2014 FROM public092215gnutokexi WHERE (address IS NOT NULL AND state = 'HI' AND email IS NULL AND wikipassnum IS NULL AND sentspring2014 IS NULL AND (yearsattend LIKE '%s%' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%x%' OR yearsattend LIKE '%w%' OR yearsattend LIKE '%c%' OR yearsattend LIKE '%k%')) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, yearsattend, id FROM public092215gnutokexi WHERE yearsattend LIKE '%14k%' ORDER BY id


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, email, wikipassnum, util, yearsattend, wiki, sentspring2014 FROM public092215gnutokexi WHERE wiki = 'yes' AND state = 'HI' AND NOT yearsattend = '' AND NOT email = '' AND wikipassnum IS NULL ORDER BY email


o_sub_id: sql
o_data:
  SELECT firstname, ' ' AS expr1, lastname, ' <' AS expr2, email, '>' AS expr3, util, yearsattend,wiki FROM public092215gnutokexi WHERE util = '' AND state = 'HI' AND NOT email = '' AND wikipassnum IS NULL AND (yearsattend LIKE '%s%' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%x%' OR yearsattend LIKE '%w%' OR yearsattend LIKE '%c%' OR yearsattend LIKE '%k%' OR wiki = 'yes') ORDER BY email


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, util, ref, yearsattend, wikipassnum, wiki, sentspring2014 FROM public092215gnutokexi WHERE sentspring2014 IS NOT NULL AND util = ']' ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id,sentspring2014,yearsattend,util,pass,email FROM public092215gnutokexi WHERE sentspring2014 IS NOT NULL AND (util = '' OR util IS NULL) ORDER BY lastname


o_sub_id: extended_schema
o_data:
  <!DOCTYPE EXTENDED_TABLE_SCHEMA>
  <EXTENDED_TABLE_SCHEMA version="2">
   <field name="name">
    <property name="maxLengthIsDefault">
     <bool>true</bool>
    </property>
   </field>
   <field name="city">
    <property name="maxLengthIsDefault">
     <bool>true</bool>
    </property>
   </field>
   <field name="state">
    <property name="maxLengthIsDefault">
     <bool>true</bool>
    </property>
   </field>
   <field name="util">
    <property name="maxLengthIsDefault">
     <bool>true</bool>
    </property>
   </field>
  </EXTENDED_TABLE_SCHEMA>


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, wikipassnum, yearsattend, email,senthacs2013 FROM public092215gnutokexi WHERE (address IS NOT NULL AND state = 'HI' AND email IS NULL AND wikipassnum IS NULL AND sentspring2014 IS NULL AND (yearsattend LIKE '%14x%' OR yearsattend LIKE '%14s%' OR (yearsattend LIKE '%14j%' AND wiki = 'yes') OR yearsattend LIKE '%13s%' OR (yearsattend LIKE '%13j%' AND wiki = 'yes') OR yearsattend LIKE '%12s%' OR (yearsattend LIKE '%12j%' AND wiki = 'yes') OR yearsattend LIKE '%11s%' OR (yearsattend LIKE '%11j%' AND wiki = 'yes') OR yearsattend LIKE '%10s%' OR (yearsattend LIKE '%10j%' AND wiki = 'yes') OR yearsattend LIKE '%14f%' OR yearsattend LIKE '%13f%' OR yearsattend LIKE '%12f%' OR yearsattend LIKE '%11f%' OR yearsattend LIKE '%10f%' OR yearsattend LIKE '%13x%' OR yearsattend LIKE '%12x%' OR yearsattend LIKE '%11x%' OR yearsattend LIKE '%10x%' OR yearsattend LIKE '%c%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%w%')) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip, id, util, email, wikipassnum, yearsattend, wiki, sentspring2014 FROM public092215gnutokexi WHERE (sentspring2014 IS NOT NULL AND util IS NULL) OR ((address IS NOT NULL AND state = 'HI' AND email IS NULL AND wikipassnum IS NULL AND sentspring2014 IS NULL AND (yearsattend LIKE '%14s%' OR yearsattend LIKE '%13s%' OR yearsattend LIKE '%12s%' OR yearsattend LIKE '%11s%' OR yearsattend LIKE '%10s%' OR yearsattend LIKE '%14f%' OR yearsattend LIKE '%13f%' OR yearsattend LIKE '%12f%' OR yearsattend LIKE '%11f%' OR yearsattend LIKE '%10f%' OR yearsattend LIKE '%13x%' OR yearsattend LIKE '%12x%' OR yearsattend LIKE '%11x%' OR yearsattend LIKE '%10x%' OR yearsattend LIKE '%c%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%w%'))) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip,util, id, wiki AS yearsattend, sentspring2014 FROM public092215gnutokexi WHERE (address IS NOT NULL AND state = 'HI' AND email IS NULL AND wikipassnum IS NULL AND wiki = 'yes' AND sentspring2014 IS NULL AND (yearsattend LIKE '%14j%' OR yearsattend LIKE '%13j%' OR yearsattend LIKE '%12j%' OR yearsattend LIKE '%11j%' OR yearsattend LIKE '%10j%')) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, yearsattend, state, zip, util, email, wiki, pass, wikipassnum, senthacs2013 FROM public092215gnutokexi WHERE not address="" AND email IS NULL AND (yearsattend LIKE '%07j%' OR yearsattend LIKE '%07s%' OR yearsattend LIKE '%07f%' OR yearsattend LIKE '%07x%' OR yearsattend LIKE '%08j%' OR yearsattend LIKE '%08s%' OR yearsattend LIKE '%08f%' OR yearsattend LIKE '%08x%' OR yearsattend LIKE '%09j%' OR yearsattend LIKE '%09s%' OR yearsattend LIKE '%09f%' OR yearsattend LIKE '%09x%' OR yearsattend LIKE '%10j%' OR yearsattend LIKE '%10s%' OR yearsattend LIKE '%10f%' OR yearsattend LIKE '%10x%' OR yearsattend LIKE '%11j%' OR yearsattend LIKE '%11s%' OR yearsattend LIKE '%11f%' OR yearsattend LIKE '%11x%' OR yearsattend LIKE '%12j%' OR yearsattend LIKE '%12s%' OR yearsattend LIKE '%12f%' OR yearsattend LIKE '%12x%' OR yearsattend LIKE '%13j%' OR yearsattend LIKE '%13s%' OR yearsattend LIKE '%13f%' OR yearsattend LIKE '%13x%' OR yearsattend LIKE '%14j%' OR yearsattend LIKE '%14s%' OR yearsattend LIKE '%14f%' OR yearsattend LIKE '%14x%' OR yearsattend LIKE '%14w%' OR yearsattend LIKE '%15s%') ORDER BY lastname, firstname


o_sub_id: sql
o_data:
  SELECT lastname, firstname,pass,wikipassnum,util,email,yearsattend FROM public092215gnutokexi WHERE yearsattend LIKE '%w%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%c%'


o_sub_id: sql
o_data:
  SELECT lastname, firstname, yearsattend, address, state, email, util, wiki, pass FROM public092215gnutokexi WHERE ((yearsattend LIKE '%s%') OR (yearsattend LIKE '%j%') OR (yearsattend LIKE '%f%') OR (yearsattend LIKE '%x%') OR (yearsattend LIKE '%W%') OR (yearsattend LIKE '%k%') OR (yearsattend LIKE '%c%')) AND (pass is null and state = 'HI' AND email IS NULL AND util IS NULL AND address IS NOT NULL) ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city, state, zip FROM public092215gnutokexi WHERE (yearsattend IS NOT NULL AND zip IS NOT NULL AND email IS NULL AND util IS NULL AND state = 'HI' AND pass IS NULL) OR (wiki = 'yes' AND yearsattend IS NULL AND pass IS NULL AND email IS NULL) ORDER BY lastname,firstname


o_sub_id: sql
o_data:
  SELECT id, lastname, firstname, address, city,state, yearsattend, zip FROM public092215gnutokexi WHERE id = 5368 OR id = 4918 OR id = 5257 ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT firstname, ' ' AS expr1, lastname, ' <' AS expr1, email, '>' AS expr2 FROM public092215gnutokexi WHERE email IS NOT NULL AND yearsattend IS NOT NULL and state="HI" ORDER BY email


o_sub_id: sql
o_data:
  SELECT id,lastname, firstname, address, city, state, zip FROM public092215gnutokexi WHERE ref = 'add' ORDER BY lastname


o_sub_id: sql
o_data:
  SELECT lastname, firstname, address, city, state, zip, id, util, wiki, wikipassnum, yearsattend, email FROM public092215gnutokexi WHERE (wikipassnum IS NULL OR wikipassnum < 1) AND state = 'HI' AND not address="" AND util = '' AND email = '' AND (wiki = 'yes' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%s%' OR yearsattend LIKE '%x%' OR yearsattend LIKE '%W%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%c%') ORDER BY lastname


o_sub_id: layout
o_data:
  <!DOCTYPE kexireport>
  <kexireport>
   <report:content xmlns:report="http://kexi-project.org/report/2.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0">
    <report:title>Report</report:title>
    <report:script report:script-interpreter="javascript"></report:script>
    <report:grid report:grid-divisions="4" report:grid-snap="0" report:page-unit="in" report:grid-visible="1"/>
    <report:page-style report:print-orientation="portrait" fo:margin-bottom="28.346505799999999pt" fo:margin-top="28.346505799999999pt" fo:margin-left="28.346505799999999pt" fo:margin-right="28.346505799999999pt" report:page-size="Letter">predefined</report:page-style>
    <report:body>
     <report:section svg:height="39.856385150050869pt" fo:background-color="#ffffff" report:section-type="header-page-any">
      <report:line report:name="line6" svg:y1="35.279999999999994pt" svg:x1="0.000000000000000pt" svg:y2="35.279999999999994pt" svg:x2="539.999999999999773pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:label report:name="label1" report:horizontal-align="left" svg:x="0.000000000000000pt" svg:width="64.346400000000003pt" svg:y="21.600000000003451pt" report:caption="Last Name" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label1" report:horizontal-align="left" svg:x="87.873840000014070pt" svg:width="64.346400000000003pt" svg:y="21.600000000003451pt" report:caption="First Name" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label2" report:horizontal-align="left" svg:x="170.078400000027244pt" svg:width="89.858159999999998pt" svg:y="21.600000000003451pt" report:caption="Business Name" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label3" report:horizontal-align="left" svg:x="283.464720000045361pt" svg:width="89.858159999999998pt" svg:y="21.600000000003451pt" report:caption="No. of Passes" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label4" report:horizontal-align="left" svg:x="389.764080000062393pt" svg:width="89.858159999999998pt" svg:y="21.600000000003451pt" report:caption="Pass Numbers" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:font-style="italic" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label12" report:horizontal-align="center" svg:x="210.747600000033771pt" svg:width="128.250720000000001pt" svg:y="0.748080000000120pt" report:caption="Wiki Wiki Passes" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
       <report:text-style fo:font-weight="bold" fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="10" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
     </report:section>
     <report:detail>
      <report:group report:group-sort="ascending" report:group-column="pass15x"/>
      <report:section svg:height="12.366264500230795pt" fo:background-color="#ffffff" report:section-type="detail">
       <report:field report:item-data-source="lastname" report:name="field7" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="0.720000000000000pt" svg:width="74.879999999999995pt" svg:y="0.720000000000000pt" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="firstname" report:name="report:field7" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="97.228080000015552pt" svg:width="74.879999999999995pt" svg:y="0.367200000000059pt" report:vertical-align="center" svg:height="11.998799999999999pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="business_name" report:name="report:field8" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="178.560000000028595pt" svg:width="123.840000000000003pt" svg:y="0.370080000000059pt" report:vertical-align="center" svg:height="11.995920000000000pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="wikipassnum" report:name="report:field9" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="318.330720000050974pt" svg:width="37.983599999999996pt" svg:y="0.370080000000059pt" report:vertical-align="center" svg:height="11.995920000000000pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="pass15x" report:name="report:field10" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="402.480000000064365pt" svg:width="80.503919999999994pt" svg:y="0.370080000000059pt" report:vertical-align="center" svg:height="11.995920000000000pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
      </report:section>
     </report:detail>
    </report:body>
   </report:content>
   <connection type="internal" source="wikipass"/>
  </kexireport>


o_sub_id: layout
o_data:
  <!DOCTYPE kexireport>
  <kexireport>
   <report:content xmlns:report="http://kexi-project.org/report/2.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0">
    <report:title>Report</report:title>
    <report:script report:script-interpreter="javascript"></report:script>
    <report:grid report:grid-divisions="4" report:grid-snap="0" report:page-unit="in" report:grid-visible="1"/>
    <report:page-style report:print-orientation="portrait" fo:margin-bottom="28.346505799999999pt" fo:margin-top="28.346505799999999pt" fo:margin-left="28.346505799999999pt" fo:margin-right="28.346505799999999pt" report:page-size="Letter">predefined</report:page-style>
    <report:body>
     <report:detail>
      <report:section svg:height="36.000000001351751pt" fo:background-color="#ffffff" report:section-type="detail">
       <report:field report:item-data-source="=field.value(&quot;lastname&quot;)+&quot;, &quot;+field.value(&quot;firstname&quot;)+&quot;- &quot;+field.value(&quot;wikipassnum&quot;)+&quot; passes. &quot;+field.value(&quot;pass15x&quot;)" report:name="field2" report:word-wrap="0" report:can-grow="0" report:horizontal-align="center" svg:x="137.248560000032967pt" svg:width="297.736560000023815pt" svg:y="8.998560000002158pt" report:vertical-align="center" svg:height="17.249760000001377pt" report:z-index="1">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="12" fo:foreground-color="#000000" fo:font-family="Swis721 Cn BT" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="" report:name="field1" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="198.000000000000000pt" svg:width="17.997119999999999pt" svg:y="0.000000000000000pt" report:vertical-align="center" svg:height="0.000000000000000pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Sans Serif" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:line report:name="line3" svg:y1="35.999999999999993pt" svg:x1="2.160000000000000pt" svg:y2="35.999999999999993pt" svg:x2="555.840000000000032pt" report:z-index="0">
        <report:line-style report:line-style="dash" report:line-weight="1" report:line-color="#000000"/>
       </report:line>
      </report:section>
     </report:detail>
    </report:body>
   </report:content>
   <connection type="internal" source="wikipass"/>
  </kexireport>


o_sub_id: sql
o_data:
  SELECT firstname, lastname, business_name, pass, pass15j,wikiutil FROM public092215gnutokexi WHERE (NOT wikiutil = '^' AND NOT wikiutil = '' AND NOT wikiutil = 'send' AND NOT wikiutil = 'w') ORDER BY wikiutil


o_sub_id: sql
o_data:
  SELECT firstname," ",lastname," <",email,">" FROM public092215gnutokexi WHERE (wikipassnum IS NULL OR wikipassnum < 1) AND state = 'HI' AND NOT address = '' AND util = '' AND NOT email = '' AND (wiki = 'yes' OR yearsattend LIKE '%f%' OR yearsattend LIKE '%s%' OR yearsattend LIKE '%x%' OR yearsattend LIKE '%W%' OR yearsattend LIKE '%k%' OR yearsattend LIKE '%c%') ORDER BY email


o_sub_id: layout
o_data:
  <!DOCTYPE kexireport>
  <kexireport>
   <report:content xmlns:report="http://kexi-project.org/report/2.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0">
    <report:title>Report</report:title>
    <report:script report:script-interpreter="javascript"></report:script>
    <report:grid report:grid-divisions="4" report:grid-snap="0" report:page-unit="in" report:grid-visible="1"/>
    <report:page-style report:print-orientation="portrait" fo:margin-bottom="28.346505799999999pt" fo:margin-top="28.346505799999999pt" fo:margin-left="28.346505799999999pt" fo:margin-right="28.346505799999999pt" report:page-size="Letter">predefined</report:page-style>
    <report:body>
     <report:section svg:height="48.750000000064865pt" fo:background-color="#ffffff" report:section-type="header-page-any">
      <report:label report:name="report:label10" report:horizontal-align="left" svg:x="377.249760000060405pt" svg:width="70.866000000000000pt" svg:y="29.250000000004682pt" report:caption="Passes Used" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label9" report:horizontal-align="left" svg:x="287.249760000045967pt" svg:width="70.866000000000000pt" svg:y="29.250000000004682pt" report:caption="Passes Issued" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label8" report:horizontal-align="left" svg:x="179.249760000028687pt" svg:width="70.866000000000000pt" svg:y="29.250000000004682pt" report:caption="Business Name" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="report:label7" report:horizontal-align="left" svg:x="107.249760000017162pt" svg:width="49.605840000000001pt" svg:y="29.250000000004682pt" report:caption="First Name" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label7" report:horizontal-align="left" svg:x="35.249760000005651pt" svg:width="49.605840000000001pt" svg:y="29.250000000004682pt" report:caption="Last Name" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:label report:name="label6" report:horizontal-align="center" svg:x="191.338560000000001pt" svg:width="162.992160000000013pt" svg:y="0.000000000000000pt" report:caption="Fall Wiki Wiki Pass Results" report:vertical-align="center" svg:height="13.498560000000001pt" report:z-index="0">
       <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
       <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
      </report:label>
      <report:line report:name="line12" svg:y1="45.360000000000007pt" svg:x1="35.280000000000463pt" svg:y2="45.359999999999999pt" svg:x2="94.320000000000022pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:line report:name="line13" svg:y1="45.660000000878433pt" svg:x1="107.249520004060003pt" svg:y2="45.739440000000002pt" svg:x2="166.301280000000020pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:line report:name="line14" svg:y1="46.410000001156341pt" svg:x1="179.999520004951165pt" svg:y2="45.359999999999999pt" svg:x2="264.959999999999411pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:line report:name="line15" svg:y1="45.359999999999999pt" svg:x1="288.000000000000057pt" svg:y2="45.357840000000003pt" svg:x2="360.720000000000255pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
      <report:line report:name="line16" svg:y1="45.360000000272038pt" svg:x1="376.500000001992419pt" svg:y2="45.354959999999998pt" svg:x2="449.195039999999949pt" report:z-index="0">
       <report:line-style report:line-style="solid" report:line-weight="1" report:line-color="#000000"/>
      </report:line>
     </report:section>
     <report:detail>
      <report:section svg:height="17.250000000202235pt" fo:background-color="#ffffff" report:section-type="detail">
       <report:line report:name="line17" svg:y1="13.680000000000000pt" svg:x1="26.640000000000004pt" svg:y2="13.680000000000000pt" svg:x2="449.280000000000030pt" report:z-index="0">
        <report:line-style report:line-style="dot" report:line-weight="1" report:line-color="#000000"/>
       </report:line>
       <report:field report:item-data-source="pass15fused" report:name="report:field4" report:word-wrap="0" report:can-grow="0" report:horizontal-align="center" svg:x="382.320000000061214pt" svg:width="42.519600000000004pt" svg:y="0.000000000000000pt" report:vertical-align="top" svg:height="13.498560000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="wikipassnum" report:name="report:field3" report:word-wrap="0" report:can-grow="0" report:horizontal-align="center" svg:x="283.680000000045368pt" svg:width="42.519600000000004pt" svg:y="0.000000000000000pt" report:vertical-align="top" svg:height="13.498560000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="business_name" report:name="report:field2" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="184.320000000029495pt" svg:width="90.929519999999997pt" svg:y="0.000000000000000pt" report:vertical-align="top" svg:height="13.498560000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="firstname" report:name="report:field1" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="106.299360000017018pt" svg:width="53.449919999999999pt" svg:y="0.000000000000000pt" report:vertical-align="top" svg:height="13.498560000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
       <report:field report:item-data-source="lastname" report:name="field1" report:word-wrap="0" report:can-grow="0" report:horizontal-align="left" svg:x="28.080000000004496pt" svg:width="61.169759999999997pt" svg:y="0.000000000000000pt" report:vertical-align="top" svg:height="13.498560000000001pt" report:z-index="0">
        <report:text-style fo:letter-spacing="0%" style:letter-kerning="true" fo:font-size="9" fo:foreground-color="#000000" fo:font-family="Noto Sans [monotype]" fo:background-color="#ffffff" fo:background-opacity="100%"/>
        <report:line-style report:line-style="nopen" report:line-weight="1" report:line-color="#000000"/>
       </report:field>
      </report:section>
     </report:detail>
    </report:body>
   </report:content>
   <connection type="internal" source="wikipass"/>
  </kexireport>


# kexi__userdata

d_sub_id: columnWidths
d_data:
  120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120


d_sub_id: columnWidths
d_data:
  62,93,78,158,71,49,42,48,99,62,37,71,45,63,35,40,38,42,164,34,69,62,61,64,66,73,74,67,68,65,71,68,66,46,59,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120


d_sub_id: columnWidths
d_data:
  120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120,120


# public090915gnutokexi

lastname: Suzuki
firstname: Anni
address: 1820 Waiola St Apt 201
city: Honolulu
state: HI
zip: 96826-2630
phone: 955-1698
how_did_yo: ATTENDED LAST YEAR
comments: Printed
printed: fall2012
wiki: yes
wikiutil: send
sentfall2006: wikiyes
sentspr2007: sendspring
senthacs2007: x
sentfall2007: sp07
sentspring2008: x
senthacs2009: update>1/1/04_addr=yes_state=HI_pass<1_dontsend=null_email=null
ref: printedx12
sentxmas09: wikiyes sentfall09no addressyes statehawaii
sentspr2010: sentxmas09
senthacs2010: update>1/1/04_addr=yes_state=HI_pass<1_dontsend=null_email=null_doesattend
sentfall2010: sentspr2010
sentxmas2010: sentfall2010
sentspring2011: sentxmas2010-yearsattended
senthacs2011: sentspring2011-nohacs2011
sentfall2011: sentspr2011noemail
sentxmas2011: sentfall2011
sentx2011check: done
sendspring2012: sentxmas2011
senthacs2012: noemail-nopass-attendedyes-2011hacs
sentfall2012: sentspr2012
yearsattend:
  99j01j03j04s05j05f06s06j06f07s07j07f08s08j09s09f09j09x10s10j10f10x11s11j11f11x12s12j12f12x13s13j13f13xs09f09j09x10s10j10f10x11s11j11f11x12s12j12f12x13s13j13f13x14s14j14x15s15j


# public092215gnutokexi

lastname: Suzuki
firstname: Anni
address: 1820 Waiola St Apt 201
city: Honolulu
state: HI
zip: 96826-2630
phone: 955-1698
how_did_yo: ATTENDED LAST YEAR
comments: Printed
printed: fall2012
wiki: yes
wikiutil: send
sentfall2006: wikiyes
sentspr2007: sendspring
senthacs2007: x
sentfall2007: sp07
sentspring2008: x
senthacs2009: update>1/1/04_addr=yes_state=HI_pass<1_dontsend=null_email=null
ref: printedx12
sentxmas09: wikiyes sentfall09no addressyes statehawaii
sentspr2010: sentxmas09
senthacs2010: update>1/1/04_addr=yes_state=HI_pass<1_dontsend=null_email=null_doesattend
sentfall2010: sentspr2010
sentxmas2010: sentfall2010
sentspring2011: sentxmas2010-yearsattended
senthacs2011: sentspring2011-nohacs2011
sentfall2011: sentspr2011noemail
sentxmas2011: sentfall2011
sentx2011check: done
sendspring2012: sentxmas2011
senthacs2012: noemail-nopass-attendedyes-2011hacs
sentfall2012: sentspr2012
yearsattend:
  99j01j03j04s05j05f06s06j06f07s07j07f08s08j09s09f09j09x10s10j10f10x11s11j11f11x12s12j12f12x13s13j13f13xs09f09j09x10s10j10f10x11s11j11f11x12s12j12f12x13s13j13f13x14s14j14x15s15j15f


