Possible Query bug?

ab042

Attempting to do a simple QUERY and nothing is returned. It appears to be a bug.

I can't get the following query to return any data.
FIND Account WHERE Account.Company CONTAINS ?Company AND Account.RefBy<>'LOCK' ORDER BY Account.Company

I've also tried and this doesn't work
FIND Account WHERE Account.Company CONTAINS ?Company AND NOT(Account.RefBy CONTAINS 'LOCK') ORDER BY Account.Company

I've also tried this and it doesn't work
FIND Account WHERE Account.Company CONTAINS ?Company AND NOT(Account.RefBy='LOCK') ORDER BY Account.Company

This works:
FIND Account WERE Account.Company CONTAINS ?Company ORDER BY Account.Company

I would hope that if the syntax is wrong in any of the above that the Integrity checker would find it. However, I've spent not less than 2 hours trying to get a simple query to work.

Is this a bug? Or does anyone see something I'm doing wrong?
Thanks

aware_support

Have you considered case sensitivity here? For example, are you sure the data has "LOCK" in capital letters? That is, if you are using Derby, which is case sensitive

ab042

Yes I have. We are using MySQL and the data is all caps and so is the query.

aware_support

What's the type of RefBy attribute?

ab042

Thanks for the fast reply.

Type: Plain Text
Max Length: 5 Standard Format

aware_support

Can you check if this query works:
FIND Account WHERE Account.RefBy<>'LOCK' ORDER BY Account.Company

aware_support

What is the status of this one? Have you been able to find the problem or you are convinced it's a bug? We are finalising the list of fixes for the next build, so if there is a problem let us know ASAP.

ab042

I believe it is a bug but still trying to figure it out.

One thing I've noticed that I'm not sure is related. If you IMPORT data it doesn't remove the BLANK SPACES from the end of the attribute.
For example: If I import a name into a PLAIN TEXT (Max length: 30) field that is only 5 characters long. It imports the 5 characters and 25 blank spaces or 25 characters that show up on the screen as blank characters. This WITHOUT QUESTION is an issue with importing that is cause several other issues but I'm not sure it is related to the above issue because I attempted the CONTAINS logic and that should have worked reqardless.

aware_support

ARE YOU SURE about the import? Aware IM definitely does not pad with blank spaces. Please double check.

ab042

Yes I'm sure. If its not padding, then its not trimming and it should.

There are several IMPORT file that are VERY LARGE and created by another app and they have blank spaces in them. There is no options in the app creating the files to change it and the files are to large to load into excel.

Is it possible for you to TRIM the blanks at the end of each field when doing an import? I can't ever think of a reason anyone would want them.