Eclipse Community Forums: scout

Help

Home

Home » Eclipse Projects » scout » Lookupservice (How to combine fixed sql with lookup)

Show: Today's Messages :: Show Polls :: Message Navigator

Lookupservice [message #783235]

Wed, 25 January 2012 05:30

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

Hi,

I have a sql lookUpService like below that works fine

  @Override
  public String getConfiguredSqlSelect() {
    return "SELECT bestandsnaam, bestandsnaam " +
        " FROM geluid " +
        " <key>where bestandsnaam = :key</key>  " +
        " <text>where upper(bestandsnaam) LIKE CONCAT(UPPER(:text), '%')</text>";
  }

but now I want to combine this with some fixed SQL like "where obsolete = 0". Whatever I do I always get an SQL error.

So can I combine a fixed sql part with a lookup service and if yes, how should I do it.

Regards Bertin

Report message to a moderator

Re: Lookupservice [message #783273 is a reply to message #783235]

Wed, 25 January 2012 06:58

Bruno Köferli
Messages: 8
Registered: January 2012

Junior Member

Hi Bertin

You have to move your WHERE keyword out of the special tags.

  @Override
  public String getConfiguredSqlSelect() {
    return "SELECT bestandsnaam, bestandsnaam " +
        " FROM geluid " +
        " WHERE obsolete = 0 " +
        " <key>AND bestandsnaam = :key</key>  " +
        " <text>AND upper(bestandsnaam) LIKE CONCAT(UPPER(:text), '%')</text>";
  }

Regards
Bruno

Report message to a moderator

Re: Lookupservice [message #783292 is a reply to message #783273]

Wed, 25 January 2012 07:44

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

Works, thanks for the quick reply.

Regards Bertin

Report message to a moderator

Re: Lookupservice [message #783366 is a reply to message #783292]

Wed, 25 January 2012 10:39

Jeremie Bresson
Messages: 108
Registered: November 2010

Senior Member

Is there a need to change or to clarify the documentation :
http://wiki.eclipse.org/Scout/Concepts/Sql_Lookup_Service
?

Report message to a moderator

Re: Lookupservice [message #783385 is a reply to message #783366]

Wed, 25 January 2012 11:14

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

The documentation is too little, it does not tell everything, so a litlle more info would be welcome or some more complex examples.

I can change the documentation with whatever I know.

Report message to a moderator

Re: Lookupservice [message #783391 is a reply to message #783385]

Wed, 25 January 2012 11:25

Bruno Köferli
Messages: 8
Registered: January 2012

Junior Member

Indeed, we will update the documentation to clarify this - especially by providing some more examples.

Report message to a moderator

Re: Lookupservice [message #783393 is a reply to message #783391]

Wed, 25 January 2012 11:29

Bertin Kiekebosch
Messages: 223
Registered: August 2011

Senior Member

I just noticed that the example I needed in the minicrm tutorial. But you only get there when you run through that example, not by looking at the concept pages.

Report message to a moderator

Previous Topic:	CalenderField
Next Topic:	Server /process HTML page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 21:31:30 EDT 2013