I don’t see it at
include/SugarQuery/SugarQuery.php
like it mentions here and a “sudo locate SugarQuery.php” returned nothing.
I don’t see it at
include/SugarQuery/SugarQuery.php
like it mentions here and a “sudo locate SugarQuery.php” returned nothing.
Where did you see that? In SugarCRM? If it was included in one of the paid versions, of after 6.5, you won’t find it in SuiteCRM.
What do you need to do with it?
I was just wanting to write some custom queries to calculate the number of tables filled for an event.
I was used to Laravel & CakePHP as of late with their cool little query wrappers, didn’t know if SuiteCRM might have something like that.
I ended up querying it with plain old SQL
$sql = 'SELECT
fp_events_cstm.capacity_c,
opportunities.id,
opportunities.`name`,
opportunities.amount_usdollar,
opportunities.sales_stage,
opportunities.probability,
opportunities_cstm.number_of_tables_c
FROM
fp_events_cstm,
opportunities
INNER JOIN fp_events_opportunities_1_c ON opportunities.id = fp_events_opportunities_1_c.fp_events_opportunities_1opportunities_idb
INNER JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c
WHERE
fp_events_opportunities_1_c.fp_events_opportunities_1fp_events_ida = "'.$record['ID'].'"
AND
fp_events_cstm.id_c = "'.$record['ID'].'"
AND
opportunities.deleted = 0
AND
opportunities.probability >= 90;';