On Wed, Sep 4, 2013 at 10:40 PM, <[email protected]> wrote: > Hi ~~helix84. > > Thank you for this quick reply. > > I'm testing version 3.2, xmlui, with Discovery enabled, as well. > > Beside trying to locate any request like yours (I could find something using > the inspect element of the broser and/or using a sniffer), I configured the > debugger and could see that it uses this test when I select a letter: > > 2013-09-04 15:58:03,103 DEBUG org.dspace.storage.rdbms.DatabaseManager @ > Running query "SELECT COUNT(sort_1) AS offset FROM bi_item WHERE sort_1<?" > with parameters: r > > and this one > > 2013-09-04 15:50:31,117 DEBUG org.dspace.storage.rdbms.DatabaseManager @ > Running query "SELECT COUNT(sort_1) AS offset FROM bi_item WHERE sort_1<?" > with p > arameters: luta > > when I tried to find sth using the first letters input box. > > I went to psql and tried to issue these same selects and got 0 as responses.
So was the number of results different when you did the search in the UI? > I couldn'd understand the < operator. Could this be the problem? "<" is a normal "less than" operator [1]. "?" is a parameter in a so-called prepared statement, which is simply a way to avoid SQL injection. One word of warning - the browse indices in 3.x are still backed by database tables, but in 4.0 (also in 3.x if you enable SolrBrowseDAO [2][3]) they will be backed by Solr by default. So try to experiment with SolrBrowseDAO, too, maybe it will suit you better. > Thanks, > > Ricardo [1] http://www.postgresql.org/docs/8.4/static/functions-comparison.html [2] https://jira.duraspace.org/browse/DS-1218 [3] https://wiki.duraspace.org/display/DSDOC3x/Configuration#Configuration-BrowseIndexConfiguration Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk _______________________________________________ Dspace-general mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-general
