How to Pass IN condition in displayParams > initial_filter in

💬 General Discussion
1

This is Old Code
array(
‘name’ => ‘assigned_user_name’,
‘displayParams’ => array (
‘initial_filter’ => ‘&status = {$status_custom}’,

         ), 
      ),

i want to Filter Users by their ID’s . so, how could i Apply IN filter in initial_filter ?

2

What are you talking about? Where is this?

Which version of SuiteCRM is it?

Please provide a minimum amount of context so we can try to help…

3

Version :
Version 7.9.11
Sugar Version 6.5.25 (Build 344)

In Related Module’s Assign to Field. I want to show users which is accepted by service and i got that users list from other tables. how could i want to show only that users. i was found that code to do custom Query but i want to pass multiple ID in Query and check that ID like ’ &id IN (‘1’,‘2’,‘3’) ’ like that. how could i do this?

4

Hmm…I doubt you can reach that level of complexity from the vardefs…

You need to look for a place to customize that, not by defining arrays in vardefs, but by directly using beans in PHP and SQL queries.

So I would look into a custom view for the module where you need this.

5

Try this:

‘initial_filter’ => ‘{$initial_filter}’,

and, in the view.edit.php, put this code on the function display():

$initial_filter=“”;
foreach($status_array as $key=>$value){
$initial_filter.=“&status=”.urlencode($value);
}
$this->ss->assign(‘initial_filter’,$initial_filter);