Hi,

I need to use the NOT LIKE operator in the Map, but when I put NOT LIKE in the operand of the map, the SQL is generated with an error, the field name an the 'not like' appear together...
I try to put a blank space before 'not like' in the map, and don?t work, the field just disappears.
How can I do this??

[EJB-QL Compiler]: where clause:
CocoPowder:: query = select F1,F2,F3,F4,F5,F6 from (SELECT SGI_CENTRO_RESULTADO.ID AS F1,SGI_CENTRO_RESULTADO.CODIGO AS F2,SGI_CENTRO_RESULTADO.NOME AS F3,SGI_CENTRO_RESULTADO.PRF_ID_GERENTE AS F4,SGI_CENTRO_RESULTADO.CR_ID_PAI AS F5,SGI_CENTRO_RESULTADO.CODIGO_REDUZIDO AS F6 FROM SGI_CENTRO_RESULTADO WHERE SGI_CENTRO_RESULTADO.CODIGOnot like'EXTINTO%') T0

CocoPowder:: Creating new Prepared SQL Statement
CocoPowder:: Exception encountered = java.sql.SQLException: ORA-00904: invalid column name
CocoPowder:: Exception occurred for operation=select mapname=null passedObject = null secondParam=nullException = java.sql.SQLException: ORA-00904: invalid column name

CocoPowder:: Exception occurred for operation=select mapname=$$CBQUERY_2020896_O passedObject = KeyField =CBSQLWHERE value=, secondParam=selectException = java.sql.SQLException: ORA-00904: invalid column name

CocoPowder:: Exception occurred for operation=select mapname=$$CBQUERY_2020896_O passedObject = KeyField =CBSQLWHERE value=, secondParam=selectException = thought.CocoBase.CocoBaseException: CBMessage=Select failed in Database SQL for map=<$$CBQUERY_2020896_O>.CoreMessage=ORA-00904: invalid column name

Did you hardcode "not like" in the map where clause
operand? It sounds like you did instead of clicking the NOT TRUE checkbox in the where clause, and the Operand should only contain the keyword LIKE.

As for ejb-ql, we tested the NOT LIKE operator with it and it did just fine...

Can you export and email an XML version of your map to our support@thoughtinc.com account so we can verify the setup?

Does this answer your question?

THOUGHT Support

Yes...this answer my question...

But today I think that I do the right thing. I put in the operand only 'like' and I checked the NOT TRUE checkbox, but doesn?t work.
First: I need to put a blank space before like operator or the field name and the 'like' operator still appearing together in the generated SQL.
Second: The NOT TRUE checkbox(checked) made no difference, I checked my XML Repository and the field has in the clause 'nottrue="1"', but the generated SQL doesn't have the negative.
Here is the generated SQL:
CocoPowder:: query = select F1,F2,F3,F4,F5,F6 from (SELECT SGI_CENTRO_RESULTADO.ID AS F1,SGI_CENTRO_RESULTADO.CODIGO AS F2,SGI_CENTRO_RESULTADO.NOME AS F3,SGI_CENTRO_RESULTADO.PRF_ID_GERENTE AS F4,SGI_CENTRO_RESULTADO.CR_ID_PAI AS F5,SGI_CENTRO_RESULTADO.CODIGO_REDUZIDO AS F6 FROM SGI_CENTRO_RESULTADO WHERE SGI_CENTRO_RESULTADO.CODIGO like'EXTINTO%') T0

Hi,

Are you using a database or an xml repository? Can you export this particular map to xml and send it to us so we can have engineering review it?

Thanks,
THOUGHT Support

I'm using an XML Repository.
I will send this map to support mail.

Thanks

Hi,

I have just exported this map and sent to mail support, and I would like to solve this problem as soon as possible.

Thanks,

The CBQuery needed updating to support the spacing you were using. An update has been sent to you for testing - and it will be included in the 4.5 SR6 release automatically. Let us know if you have any more questions or issues.

THOUGHT Support