Eclipse Community Forums: Eclipse Scout

Home

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

Lookupservice [message #783235]

Wed, 25 January 2012 05:30

Eclipse User

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

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

Wed, 25 January 2012 06:58

Eclipse User

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

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

Wed, 25 January 2012 07:44

Eclipse User

Works, thanks for the quick reply.

Regards Bertin

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

Wed, 25 January 2012 10:39

Eclipse User

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

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

Wed, 25 January 2012 11:14

Eclipse User

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.

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

Wed, 25 January 2012 11:25

Eclipse User

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

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

Wed, 25 January 2012 11:29

Eclipse User

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.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 03:07:44 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter