searching records

4 posts by 3 authors in: Forums > CMS Builder
Last Post: August 12, 2013   (RSS)

By rez - August 4, 2013 - edited: August 4, 2013

http://www.interactivetools.com/forum/forum-posts.php?postNum=2205029#post2205029

Hello. I was told at one point that this was on the list to be developed but that it could take a year. It has been 3. Will it happen? :) 

I want to manage a larger amount of records. I still can't search them with CMSB. :(

By rez - August 7, 2013 - edited: August 7, 2013

Interesting! That sounds like it could work. One challenge might be that it's more than one category selected per item? I need to search/sort all of them.

example:

  • Brewery Table: Flying Dog, Budweiser, Brew Fist, Burley Oak, etc
  • Style Table: Bock, Lager, Pale Ale, Pilsener, etc
  • Then for a beer record / table  there is various info and you select a brewery and style per record.

Also, I'm talking about 3,000 beers currently and more daily. So if I was to change a misspelled brewery or Lauger to Lager for instance, it might need to update hundreds of beers? I don't know if that's a problem, I'm just trying to think things through.

It sounds like the Brewery and Styles would show up twice in the records when using this plug-in? If there is a way to hide this from Editor level admins it would be less confusing. I don't mind seeing all these fields for a fix in my Admin section but I hope I can set things to not show for the site owner who is an "Editor" admin. I would imagine that in the record editor list for the site owner where searching and sorting, i could just show the plug in text fields and not the original duplicates. In the details of the record when modifying, if they have to show, I could make a "Do Not Modify below here" type of separator like the long and lat of the maps plug. Or can these be hidden? Hidden would be less confusing for he site owner.

Am I following you correctly? :)

Thanks for help with this.  Currently, with 3k beers and trying to search "flying dog" in the cms list,  there are zero results. :( As you can imagine, that has never made sense to the site owner. I would love any kind of fix like you mentioned!

By Daryl - August 12, 2013 - edited: August 12, 2013

Hi rez,

Attached here is the listFieldCached plugin that will enable you to sort by the titles or names of records loaded from another table. 

We included the instruction on how to set it up.

Let us know if you have any more question.

Cheers,

Daryl

Daryl Maximo
PHP Programmer - interactivetools.com
Attachments:

listfieldlabelcache.php 7K