topic Re: Native query api missing methods? in Alfresco Archive

Native query api missing methods?

andreasa — Mon, 11 Feb 2013 13:13:39 GMT

The user guide (http://www.activiti.org/userguide/index.html#queryAPI) states that I should be able to do native queries using a fluent builder. However the .select() or .from() methods on all of the NativeQuery interfaces seems to be missing.

Re: Native query api missing methods?

frederikherema1 — Tue, 12 Feb 2013 15:15:19 GMT

Looks like user guide is out of date. You should use the full SQL-statement instead:


/**
   * Hand in the SQL statement you want to execute. BEWARE: if you need a count you have to hand in a count() statement
   * yourself, otherwise the result will be treated as lost of Activiti entities.
   * 
   * If you need paging you have to insert the pagination code yourself. We skipped doing this for you
   * as this is done really different on some databases (especially MS-SQL / DB2)
   */
  T sql(String selectClause);

Re: Native query api missing methods?

andreasa — Wed, 13 Feb 2013 12:10:10 GMT

Thanks, I resorted to doing that.