Problem with ID in query after upgrade

Posted by smartsysISV on 01-May-2016 07:24

After upgrade to 4.2 no of my query using {!id} give correct result.

Ex:

"select sum(price) from orderlines where Rxxxx={!id}"

How can this be fixed???

If i try this: "select id, price, Rxxxx from orderlines where id=123123123"

it always return "0" at the Rxxx field, and this have in earlier version returned the id of the relatet record.

Rollbase - Forum

All Replies

Posted by Anoop Premachandran on 01-May-2016 11:13

We are looking into this

Posted by Anoop Premachandran on 01-May-2016 11:43

Can you share the IDs of the customers (tenants)  where you are facing this issue ?

Posted by smartsysISV on 01-May-2016 11:50

You can see details on the support case: 00345906

Customer tenant: 58885486

Posted by murali_pacific on 01-May-2016 12:23

Can you please enable Support Access for tenant: 58885486

Posted by smartsysISV on 01-May-2016 12:39

This tenant has enabled supportaccess

Posted by smartsysISV on 01-May-2016 14:05

Is there any new info?

Posted by Varun Tayal on 01-May-2016 16:10

Will have an update soon. Still working on it.

Posted by bakar on 01-May-2016 17:49

We had installed 4.2 on our test servers, now the binaries are not available anymore. Also, the public version has been reverted back to 4.1. What happened? Should we also deinstall these 4.2 version?

Posted by Santosh Patel on 01-May-2016 22:49

Due to some critical issues we had to revert back to 4.1. Please do not use the 4.2 binaries that you have already downloaded. Further update on this will be posted soon.

This thread is closed