DB crawler returns count, but no records?

Help
2014-01-07
2014-01-23
  • Darco Lalevic
    Darco Lalevic
    2014-01-07

    Hello, having problems setting up a DB search. The select is straightforward and works, when I 'check' it, it finds all four columns. But when I run the crawler it returns 0 results (although the count is correct). Any ideas?
    crawler:
    productBasic 1/7/14 11:31:09 AM 0:00:05 Complete 0 (0) / 470992 (0)
    the query:
    select id, productName, Manufacturer, brandName From myTable

     
  • Naveen A.N
    Naveen A.N
    2014-01-08

    Hello Darco,

    Can u give us more information?A screenshot would be useful.

    May i know what "Isolation level" do you use ? and what is the "SQL Update" action you use(It will be in a combo box below the Textarea for "SQL Update")?

    Naveen.A.N

     
  • Naveen A.N
    Naveen A.N
    2014-01-23

    Hello Carlos,

    Sorry for the delay in the reply,

    There is one issue in the "Field Map" tab .
    The primary key field from the database should be mapped with the default field in the schema.
    That way you can have unique documents.

    Naveen.A.N