SmartField and Suggestions while Typing [message #1575216] |
Tue, 20 January 2015 17:53 |
|
Hello,
I don't know why but I can't get a smart field to work properly. When I dropdown the list of a smart field I can see the entries as expected:
But when typing "Alfred" I'd expect at least the 3 entries shown in the above screenshot. But a shown below, nothing shows up:
Why is this?
The LookupCode looks like this:
@Override
protected String getConfiguredSqlSelect() {
return "SELECT F.ID, CONCAT(TRIM(F.FirstName), ' ', TRIM(F.Lastname)) AS ForrestHelperName FROM ForrestHelper F WHERE 1=1 "
+ "<key> AND F.ID = :key </key>"
+ "<text> AND UPPER(CONCAT(TRIM(F.FirstName), ' ', TRIM(F.Lastname))) LIKE UPPER(:text||'%') </text> "
+ "<all> </all> ";
}
Looking at the console log this is shown:
SQL with binds:
SELECT F.ID,
CONCAT(TRIM(F.FIRSTNAME), ' ', TRIM(F.LASTNAME))
AS FORRESTHELPERNAME
FROM FORRESTHELPER F
WHERE 1 = 1
AND UPPER(CONCAT(TRIM(F.FIRSTNAME), ' ', TRIM(F.LASTNAME))) LIKE UPPER(:text || '%')
IN :text => ? [VARCHAR alfred%]
Putting this output into MySQL Workbench works as expected...
I have no idea what's wrong with that.....
Peter
|
|
|
|
|
|
|
|
Re: SmartField and Suggestions while Typing [message #1578975 is a reply to message #1577199] |
Thu, 22 January 2015 18:34 |
|
Tore Van Grembergen wrote on Wed, 21 January 2015 19:23
Congratulations with the screen layouts you created with scout.
They really look very nice.
Thanks But as you can see, "Add" and "Delete" Button are not the same size. And Im Struggling that those buttons should always have a fixed size and be right aligned, while the table should horizontally grow/shrink depending on the screen size.
Peter
|
|
|
|
Powered by
FUDForum. Page generated in 0.04204 seconds