Displaying list items by category

Hi Nigel,

I think you only have to make a few amendments to your store page to get the filtering working, I've made these changes on line 59 of store.php:

  $where = '';
  $number = getLastNumberInUrl(0);

  if($number > 0){
    $where = "name_of_list_field = $number";
  }

  list($catalogueRecords, $catalogueMetaData) = getRecords(array(
    'tableName'   => 'catalogue',
    'perPage'     => '10',
    'where'       => $where,
    'loadUploads' => true,
    'allowSearch' => false,
    'orderBy'     => 'dragSortOrder DESC ',
  ));

The only change I think you'll need to make is set name_of_list_field to field name of the list field that is populated by using "Get options from database (advanced)".

So the getLastNumberInUrl function will retrieve the last number in the URL if one is set. If a number exists, then a where string is created will filter out only records with the specific list field.

Finally this where string is added to the getRecords function.

Let me know if you have any questions.

Thanks!

Greg

What about adding a 'hidden' check box to the category section, and hiding categories that you havn't added items too yet?

If you create a checkbox called 'hidden' in the category section, the getRecords function will automatically not retrieve records with it checked. 

If you wanted to add a counter for the number of records, you could implement the code from this post: http://www.interactivetools.com/forum/forum-posts.php?postNum=2229899#post2229899

Let me know if you have any questions.

Thanks!

Greg

The hidden checkbox is so obvious, I don't know why I didn't think of it! Thanks, Greg.