Hi,

I am using checkboxsetfield to categorize items. I manage items with Model Admin.

$categoriesCheckboxSetField = new CheckboxSetField(
   $name = "Category",
   $title = "Please select the related categories for this company",
   $source = array(
      "01" => "Category 01",
      "02" => "Category 02",
   ),
);

Is there a way to get an unordered list of all array values in the template? And filter the result when clicking on the related category?

Kind Regards

Well to get the list of Categories you could do raw SQl query like

$results = DB::query("SELECT DISTINCT Category FROM (insert DataObject Name) ORDER BY Category ASC");

That will get an Array of the Different Categories. Though you'll want/need the Array as a its own DataObject so it'll loop, or you could do a for each $result and run another query like this:

http://www.silverstripe.org/dataobjectmanager-module-forum/show/267505#post267505

Thank you very much. In the end, I decided to use complex table field.

Here is the link to the post http://www.silverstripe.org/general-questions/show/265149#post265149