data-config.xml.in

<dataConfig>
  <dataSource type="JdbcDataSource" 
    driver="org.postgresql.Driver"
    url="jdbc:postgresql://${parts.settings['jdbc_url']}" 
    user="${parts.settings['jdbc_user']}" 
    password="${parts.settings['jdbc_password']}"/>
  <document>
    <entity name="timeentry" 
      query="select concat('timeentry:',id) as doc_id,'TimeEntry' as realm, time_entries.* from time_entries"
      deltaImportQuery="select concat('timeentry:',id) as doc_id, 'TimeEntry' as realm, time_entries.* from time_entries where id='$${dih.delta.id}'"
      deltaQuery="select id from time_entries where modification_date &gt; '$${dih.last_index_time}'">
        <field column="id" name="doc_id"/>
        <field column="project_id" name="project"/>
        <field column="realm" name="realm"/>
        <field column="id" name="id"/>
        <field column="description" name="title"/>
        <field column="customer_request_id" name="tags"/>
        <field column="author_id" name="involved"/>
        <entity name="user"
          query="select email from users where id ='$${timeentry.author_id}'">
          <field column="email" name="author"/>
        </entity>
        <field column="description" name="body"/>
        <field column="description" name="oneline"/>
    </entity>
  </document>
</dataConfig>