Creating Custom Filters In Sugar 7

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Thu, 13 Jul 2017 08:51:26 GMT

Comment originally made by Venkatesh.

Sugar CRM Version: 7.8.2.0

I would need to modify the filter query string parameter for a specific field from `$starts` to `$equals`. Basically i would need to arrange the Search look up popup.

Any help would be highly appreciated.

Current query String -

&filter[1][$or][0][name-0][$starts]=USER__TYPED_INPUT

&filter[1][$or][1][name-1][$starts]=USER__TYPED_INPUT

&filter[1][$or][2][name-2][$starts]=USER__TYPED_INPUT

Query string should be updated like below -

&filter[1][$or][0][name-0][$equals]=USER__TYPED_INPUT

&filter[1][$or][1][name-1][$starts]=USER__TYPED_INPUT

&filter[1][$or][2][name-2][$starts]=USER__TYPED_INPUT

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Fri, 13 Jan 2017 14:54:06 GMT

Comment originally made by Abhishek Bhardwaj.

I'm using enterprise could based edition 7.7 & I want to create some new custom filter..

How it is possible when I have no access of code , file structure and database.

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Wed, 06 May 2015 15:48:29 GMT

Comment originally made by diegoalexDiegoAlex.

Is there any way to filter by a relate field?!

I've tried some ways but no fun =/

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Tue, 28 Apr 2015 22:11:40 GMT

Comment originally made by Jamie Soffer.

Can I accomplish this same task of creating custom filters that all users can see within my admin panel or is it only possible to create these filters as a developer?

Thanks,

Jamie

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Mon, 16 Mar 2015 14:24:41 GMT

Comment originally made by JD.

I am trying to add a dynamic filter on a relate field and performed all the steps as per the below mentioned link.

http://support.sugarcrm.com/02_Documentation/04_Sugar_Developer/Sugar_Developer_Guide_7.5/20_UI_Model/30_Views/05_Filters/

Now my problem is quick search working fine with my filter and getting dynamic value to return specif records but when I click on 'search for more' it pre-select my filter but never put dynamic value in the query string due to which filter does not work as expected. Can anyone help me out with this?

Thanks in advance!

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Mon, 09 Feb 2015 15:50:44 GMT

Comment originally made by chesk4.

Hi, I'm trying to create a filter for a integer field (stock) in a custom module and I've created the file stock.php as follows:

$module_name = "custom_module";

$viewdefs[$module_name]['base']['filter']['stock'] = array(

'create' => false,

'filters' => array(

array(

'id' => 'stock',

'name' => 'LBL_STOCK_FILTER',

'filter_definition' => array(

array(

'stock' => array(

$gt => '0'

'editable' => false,

);

The filter should show the records of the custom module which have stock > 0 but it's only showing those ones with stock = 0.

Any help with that will be very apreciated.

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Tue, 28 Oct 2014 03:07:40 GMT

Comment originally made by kuehltha.

Any way to make this work on a Portal List View?

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Fri, 10 Oct 2014 03:13:55 GMT

Comment originally made by Nabil Francis.

Is it possible to have the filter act in a dynamic way? I am looking at adding a new date range for the date (which I can use the Between option for) but would need to have the dates change dynamically once the filter is requested.

Thanks

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Fri, 19 Sep 2014 13:30:47 GMT

Comment originally made by Karl Metum.

Set 'create' => true in all filters if you are having issues on SugarCRM 7.2.2.0

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Tue, 09 Sep 2014 16:54:19 GMT

Comment originally made by Gustav Lindström.

Great post! How do you add filtering on current user in php code?

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Mon, 21 Jul 2014 13:35:45 GMT

Comment originally made by karan.

This works like charm for me but recently i have faced one issue and I just want to know from others if anyone has faced same problem or not :

If i have created a filter as per the method described above then I don't see a "Create" button in filters part in recordlist view

I verified by removing the filter and again "Create" button came

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Mon, 14 Jul 2014 14:43:16 GMT

Comment originally made by Scott.

One problem we are having is we have certain users we want to prevent from Editing Accounts but we want them to be able to create their own search filters. They can't. If you remove Edit of Account you can't create filters. Any work around?

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Wed, 16 Apr 2014 07:34:00 GMT

Comment originally made by Karl Metum.

How would one add a related_field to the available fields in a filter?

RE: Creating Custom Filters In Sugar 7

SugarCRM Developers — Thu, 13 Mar 2014 03:51:17 GMT

Comment originally made by yc.

Hi,

I've been trying to implement your example but with some extra customization. I need to create a "custom default filter" for a a relate field selection popup (which ends up using all the regular list code)

I need to get a date range already typed in by the user but not yet saved in order to filter the relate item the user can select. It's a rental customization so only items available for the entirity of a date range should show up.

How can I get the typed in values from the parent panel? I assume it's some javascript/document get value thing but how do I place that in the PHP filter file?

Thanks in advance for any input!