data truncated when searching for a single result

45 views
Skip to first unread message

Nigel Robbins

unread,
Dec 4, 2015, 12:07:54 PM12/4/15
to Constellio EN
Hi,
I've set up a DBConnecter which works fine with *:* in the search field (see SearchAll.png attachment).
However with "SR_NUMBER=15003" in the search field, the data gets truncated (e.g. data after SHORT_CODE is missing, see SearchOne.png attachment).
I'm not sure what I should enter in the search field to return the data untruncated or maybe I need to config something ?
Thanks,
Nigel
SearchAll.png
SearchOne.png

Nicolas Bélisle

unread,
Dec 4, 2015, 12:11:23 PM12/4/15
to const...@googlegroups.com
Hi, 

What's the config for your connector (please remove the credentials) ?

Regards, 

Nicolas

Nicolas Bélisle

964A, St-Laurent O
Longueuil, (QC) Canada
New York - Québec - Montréal - Ottawa
nicolas...@constellio.com

--
Vous recevez ce message, car vous êtes abonné au groupe Google Groupes "Constellio EN".
Pour vous désabonner de ce groupe et ne plus recevoir d'e-mails le concernant, envoyez un e-mail à l'adresse constellio+...@googlegroups.com.
Pour envoyer un message à ce groupe, envoyez un e-mail à l'adresse const...@googlegroups.com.
Visitez ce groupe à l'adresse http://groups.google.com/group/constellio.
Pour obtenir davantage d'options, consultez la page https://groups.google.com/d/optout.

Nigel Robbins

unread,
Dec 4, 2015, 12:31:59 PM12/4/15
to Constellio EN
Hi Nicolas,

I've added a screenshot which shows the connector config (please see ConnectorConfig.png).
The rest of the where clause that's not in the screenshot is:
(srs_service_center.client_id = srs_e4se_client.client_id)

Please note that ojdbc14.jar has been placed in the lib folder.

Thanks,
Nigel
ConnectorConfig.png

Nicolas Bélisle

unread,
Dec 4, 2015, 12:33:46 PM12/4/15
to const...@googlegroups.com
Nigel, 

Please add the XSLT part. 

Regards, 

Nicolas

Nicolas Bélisle

964A, St-Laurent O
Longueuil, (QC) Canada
New York - Québec - Montréal - Ottawa
nicolas...@constellio.com

--

Nigel Robbins

unread,
Dec 4, 2015, 3:50:38 PM12/4/15
to Constellio EN, nicolas...@constellio.com
Hi Nicolas,

The XSLT part is empty.

Thanks,
Nigel

Nicolas Bélisle

unread,
Dec 4, 2015, 3:59:48 PM12/4/15
to Nigel Robbins, Constellio EN
Try supplying an XSLT like the following : https://code.google.com/p/google-enterprise-connector-database/wiki/DBConnectorConfigurationDetails

The XSLT will generate an HTML page that will be indexed as a document for the connector. 
You'll be able to search the generated document.

Regards, 

Nicolas

Nicolas Bélisle

964A, St-Laurent O
Longueuil, (QC) Canada
New York - Québec - Montréal - Ottawa
nicolas...@constellio.com

Nigel Robbins

unread,
Dec 4, 2015, 4:12:28 PM12/4/15
to Constellio EN, nigel....@wallstreetsystems.com, nicolas...@constellio.com
Thank you Nicolas.

I will try out your suggestion.

Nigel

Nigel Robbins

unread,
Dec 7, 2015, 5:07:16 AM12/7/15
to Constellio EN, nigel....@wallstreetsystems.com, nicolas...@constellio.com
Hi Nicolas,

I added XSLT (see below) but couldn't see a generated HTML page.
Is there something else I need to configure ?

Thanks,
Nigel

<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
  <html>
  <body>
  <xsl:for-each select="database">
  <title><xsl:value-of select="title"/></title>
  </xsl:for-each>
    <table border="1">
      <tr bgcolor="#9acd32">
        <th>sr_number</th>
        <th>entry_date</th>
        <th>client_id</th>
        <th>short_code</th>
        <th>headline</th>
        <th>long_description</th>
        <th>solution</th>
        <th>customer_remarks</th>
      </tr>
      <xsl:for-each select="database">
      <tr>
        <td><xsl:value-of select="sr_number"/></td>
        <td><xsl:value-of select="entry_date"/></td>
        <td><xsl:value-of select="client_id"/></td>
        <td><xsl:value-of select="short_code"/></td>
        <td><xsl:value-of select="headline"/></td>
        <td><xsl:value-of select="long_description"/></td>
        <td><xsl:value-of select="solution"/></td>
        <td><xsl:value-of select="customer_remarks"/></td>
      </tr>
      </xsl:for-each>
    </table>
  </body>
  </html>
</xsl:template>
</xsl:stylesheet>
Reply all
Reply to author
Forward
0 new messages