SQL string in AwareIM Query

lineamovil

Hello,

Im trying to create a query using MySQL string in AwareIM (SQL Tab)

It works fine in MySQL

SELECT MAX(  `ID` ) ,  `RemisionViaje_RID` ,  `Fecha` ,  `Cliente` 
FROM cargonet_viajessub
GROUP BY  `RemisionViaje_RID` 
LIMIT 0 , 30

It returns:

"5534";"4956";"2013-01-25";"Avon de Costa Rica, S.A. "
"6013";"5131";"2013-02-07";"Corporativo Swissco, S.A. de C.V."
"6016";"5415";"2013-02-19";"Corporativo Swissco, S.A. de C.V."
"6014";"5422";"2013-02-20";"Corporativo Swissco, S.A. de C.V."

just what I need. But when I post the SQL String in the AwareIM Query, it just seem to let me even finish my Query.

So far I made some changes, but still the same:

In AWAREIM Query

SELECT MAX(`ViajesSub.ID`),`ViajesSub.RemisionViaje_RID`,`ViajesSub.Fecha`,`ViajesSub.Cliente` FROM `viajessub` AS ViajesSub GROUP BY ViajesSub.RemisionViaje_RID

Thank you for your advise.

lineamovil

I even made a more easy to understand sample:

thank you!!

SAMPLE:

BO Involved
BO.Products
BO.Invoice
BO.InvoiceSub

Relationships
BO.Invoice has a "Owner of" relationship with BO.InvoiceSub
BO.Products has a "Peer" relationship with BO.InvoiceSub

There can be many invoices, also
Many Products related to Many BO.InvoiceSub

Needed
I need a Query to display the last BO.InvoiceSub where every product was related.

QUERY NEEDED:
INVOICE PRODUCT
IN260 P200
IN260 P100
IN260 P400
IN250 P500
IN250 P300
IN230 P600

aware_support

You need to create a stored procedure from this string inside MySQL (refer to MySQL documentation on this) and then get Aware IM query to use this stored procedure (EXEC_SP action). For more details please refer to the User Guide