I have a question.
The SugarCRM version 7.6 has products module. A product has Status.
Our Client has got about 4500 products with the Shipped status in your Sugar GUI.
When I ask him to run the following SQL Query:
SELECT Count(*) FROM products WHERE status = "Shipped";
He says the result is 188.
Can you please tell me which field contains a product status in the SugarCRM Database ?
How can I get all Shipped products with an SQL Query?
Thanks a ton,