title: How to use @JDBCDBColumn for typ ahead in xpages
body: <p>Using Notes 9 and extension library's data controls...</p>
  
  <p>I want to use the @JDBCDbColumn() to get the type ahead values from an Oracle table.  </p>
  
  <p>Is that possible at all?  Does it work the same way the standard DBColumn in the type ahead?</p>
  
  <p>Note that the DBColumn is looking in a huge table, but I specify a where clause that should filter what the JDBCDBColumn returns.</p>
  
  <p>Somehow, nothing happens.  Work sfine with Notes data though, but I need to get this working with the Oracle data.</p>
  
  <p>Thanks!</p>
  
  <p>Update 1: Code I have...</p>
  
  <pre><code>@JdbcExecuteQuery(
      "oracle",
      "select distinct postal_code from cifadmin.postal_codes where postal_code like '"
        + getComponent("CodePostal").getValue() + "%'")
  </code></pre>
  
  <p>Update 2: Here is the code I have right now, but it doesn't return anything: </p>
  
  <pre><code>var CodePostal = getComponent("rsSearchQuery").getValue();
  if(!!CodePostal) {
      var params = [CodePostal];
      var a = @JdbcDbColumn("oracle", "postal_codes", "postal_code", "postal_code like ?", params); 
      return @Unique(a);
  } else {
      return "--";
  }
  </code></pre>