• SugarQuery with a Where clause field LIKE '%58%'

    I have a field in my DB, it is type INT. Lets call it test_int so <?php $query = new SugarQuery ( ) ; $query - > from ( BeanFactory : : getBean ( 'Accounts' ) ) ; $query - > select ( array ( 'id' , 'name' , 'test_int' ) ) ; $query - > where ( ) - > contains…
  • where clause in selection-list view

    Hi All, I would like to filter a related record when users tried to link between the two. I saw orderBy clause inside root/modules/modulename/clients/base/views/selection-list.php I was able to modify the orderBy clause but I couldn't modify the where…