where for a list field problem

Hi, dlsweb. I get confused with those, too. The answer will depend on whether the multi-value checkbox list is in the same table or an external table.

If category list is in same table, use the category label for your 'where' in this manner, note the $ on either side:
If category list is in same table, use the category label for your 'where' in this manner, note the % on either side:

'where' => 'category = "%Winery%"',

If category list is in an external table, use the category record number. For example, if your Winery category recordn number was 5 in the external table, that would look like this:

'where' => 'category = "5"',

Let me know if that works.

~ Deborah

the $ did not work
'where' => 'category = "$Winery$"', 
Gets No records were found!

category is in the same table, and my value and label are exactly the same.

Thanks, Larry

Larry, so sorry. The $ was a typo. Did you try this with the %?

~ Deborah

Yes. The following is what I'm using:

list($items_inRecords, $items_inMetaData) = getRecords(array(
'tableName' => 'apples'
'loadUploads' => true,
'allowSearch' => false,
'where' => ' category LIKE "%Sweet%" ',
));

Then in the HTML:

<?php echo join(', ', $record['category:values']); ?>

Resulting display:
Red Delicious, Fuji, Golden Delicious

I had not tried the % and the LIKE
This works
'where' => 'category LIKE "%mycategory%"',

Thanks so very much for the help, you're terrific

Larry