Need to run SQL queries. What is best way?
Need to run SQL queries. What is best way?
Just a thought, and probably overkill, but since you only have access to the DB through the application, and you are only wanting to query the system - not modify it - you could maybe build yourself a custom API
that runs the query you need using a
SugarQuery
or Prepared Statement
Use of prepared statements in Sugar 7.9
FrancescaS
Just a thought, and probably overkill, but since you only have access to the DB through the application, and you are only wanting to query the system - not modify it - you could maybe build yourself a custom API
that runs the query you need using a
SugarQuery
or Prepared Statement
Use of prepared statements in Sugar 7.9
FrancescaS