v.2.5 Contains function info

Many thanks Greg!  I think this means that this function can not be used to detect whether a mutli-list (checkbox, radiobox, list) pulled from a record in CMSB contains certain values. 
i.e.: a multi-list has had some values checked/present but not others.

Is that correct?

Hi,

You could use this function to check if an item has been checked in in a list, something like this would work:

// load records from 'blog'
  list($blog, $blogMetaData) = getRecords(array(
  'tableName' => 'blog',
  'perPage' => '10',
  'loadUploads' => true,
  'allowSearch' => false,
));

foreach($blog as $item){
  if(contains("option one\t",$item['listField'])){
    echo 'true';
  }else{
    echo 'false';
  }
    echo '<br>';
}

You would need to change the listField variable to the name of the field that contains your list options. So this would return a list of true or false depending on if the list field has the 'option one' value selected. CMS Builder stores list fields as a string that is tab seperated.

If your using getRecord to return your records, then you might be better using the PHP in_array function instead:

foreach($blog as $item){
  if(in_array("option one",$item['listField:values'])){
    echo 'true';
  }else{
    echo 'false';
  }
  echo '<br>';
}

This will check if the meta field listField:values -which is an array of all of the selected values for a drop down- contains the value 'option one'.

Thanks!

Greg

Thank you Greg. That's exceptionally helpful. I really appreciate you going through the "what if" process in your response.

Be well!