21309 Posts in 5738 Topics by 2603 members
General Questions
SilverStripe Forums » General Questions » Using Checkboxsetfield values as categories, filtering records
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 1204 Views |
-
Using Checkboxsetfield values as categories, filtering records
16 September 2009 at 8:55am
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
-
Re: Using Checkboxsetfield values as categories, filtering records
17 September 2009 at 12:02pm
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
-
Re: Using Checkboxsetfield values as categories, filtering records
5 October 2009 at 11:02am
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
| 1204 Views | ||
|
Page:
1
|
Go to Top |
