Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.
#607 - Products can not be search by product Category
As we are trying to find the products by category in advanced search view then it can't search products by category.As I find something which is wrong.Please check query...
SELECT aos_products.id ,aos_products_cstm.qty_in_demand_c,aos_products_cstm.quantity_in_stock_c,aos_products_cstm.quantity_unit_c,aos_products_cstm.reorder_level_c,aos_products_cstm.serial_number_c,aos_products_cstm.usage_unit_c,aos_products_cstm.user_id_c, aos_products.name , aos_products.part_number , aos_products.cost , aos_products.currency_id , aos_products.price , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , 'Users' created_by_name_mod, aos_products.date_entered , aos_products.assigned_user_id FROM aos_products LEFT JOIN aos_products_cstm ON aos_products.id = aos_products_cstm.id_c LEFT JOIN users jt0 ON jt0.id= aos_products.created_by AND jt0.deleted=0 AND jt0.deleted=0
where ((p.aos_product_category_name like 'Houseware%')) AND aos_products.deleted=0 ORDER BY aos_products.name ASC
Check "where" condition which is wrong. I think "aos_products.aos_product_category_id='56a2797d-d587-7ce6-f270-524d498f6c00'". What you think?
Thanks & Regards,
Other add-ons of interest
Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and e...
QuickCRM Mobile gives you access to Sugar ® or SuiteCRM on your mobile, your tablet (iPhone, iPad, Android) or your laptop with QuickCRM native apps available on App Store, Google Play and Windows Store.
Process Manager 4.5
Your Sugar Workflow Solution! Powerful Process Automation software for all editions of SugarCRM and SuiteCRM (Visit https://store.suitecrm.com/) that will allow you and your employees to spend more time doing what they do best: 'Selling To and Servicing Your Customers' and less time trying to manag...