Use of prepared statements in Sugar 7.9

RE: Use of prepared statements in Sugar 7.9

Enes Saridogan — Fri, 05 Nov 2021 20:34:33 GMT

Hello [mention:55684fd1b8674ea2961f0e7ada0dbb91:e9ed411860ed4f2ba0265705b8793d05]

Thanks for this article. I want to use the updateParams function, but it doesn't work on custom fields for custom tables, for example I want to update a field named status_proc_c on the table cases_cstm, but after debugging I noticed that the field isn't considered because it has the key source and it is not of type db :

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:2799030e-d33f-4bfe-9006-15925245afc2:type=php&text=if%20%28isset%28%24fieldDef%5B%27source%27%5D%29%20%26%26%20%24fieldDef%5B%27source%27%5D%20%21%3D%20%27db%27%29%20%7B%0D%0A%20%20%20%20continue%3B%0D%0A%7D]

Here is the code I tried to execute :

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:c1b2bcb9-5b51-426d-ad83-2a6128784492:type=php&text=global%20%24db%3B%0D%0A%24fieldDefs%20%3D%20%24GLOBALS%5B%27dictionary%27%5D%5B%27Case%27%5D%5B%27fields%27%5D%3B%0D%0A%24db_return%20%3D%20%24db-%3EupdateParams%28%27cases_cstm%27%2C%20%0D%0A%09%24fieldDefs%2C%20%0D%0A%09array%28%0D%0A%09%09%27status_proc_c%27%20%3D%3E%20%27status_proc_refused%27%0D%0A%09%29%2C%0D%0A%09array%28%0D%0A%09%09%27id_c%27%20%3D%3E%20%24taskBean-%3Eparent_id%2C%0D%0A%09%29%0D%0A%29%3B]

Is there a way to bypass that ? That's a pity if we can only set the values for the principle table.

Thanks in advance for your feedback !

Have a nice week end ! :-)

Enes

RE: Use of prepared statements in Sugar 7.9

SugarCRM Developers — Tue, 27 Jun 2017 09:16:47 GMT

Comment originally made by Ivan Tabarino.

I would like to know which one is the recommended form to create new custom queries on Sugar 7.9. Would be better to call directly Doctrine/QueryBuilder or SugarQuery?

Thank you.

RE: Use of prepared statements in Sugar 7.9

SugarCRM Developers — Sat, 06 May 2017 02:23:02 GMT

Comment originally made by Basu Ramanan.

thank you. This was a much-awaited feature in the out-of-the-box product.

1. Would Sugar now generate only prepared Statements out of the box for all SQLs?

2. Can this be configurable ?

3. For Debug purposes, Is there a way to log the Actual bind params passed in ?

RE: Use of prepared statements in Sugar 7.9

SugarCRM Developers — Sat, 22 Apr 2017 15:28:07 GMT

Comment originally made by Albert Trotter.

hello! please guide us all about the delete queries too

RE: Use of prepared statements in Sugar 7.9

SugarCRM Developers — Mon, 17 Apr 2017 13:52:24 GMT

Comment originally made by Bruno Smith Lopes Ribeiro.

Hi Matt,

I've seen that will be removed from the "joinRaw" in SugarQuery, could you provide an example of how to use LEFT JOIN without it? I want to anticipate myself because I use it a lot.

Thank you.