With the total shortcode, you use the “filter” attribute (which works the same as for the list shortcode) to determine which records are included in the count.
For your second question, how you approach this depends on what you expect to be present in the record that indicates there is no accountant. In other words, what exactly would you be looking for?
For instance, if there was a field named “accountant” where a name would be saved if there was an accountant, you could show all the records that have nothing stored in the “accountant” field with this:
[pdb_list filter="accountant="]
What that means is “find all records where the accountant field is equal to no value” This is explained where list filtering is explained on the Other Notes page.
Thanks – the total shortcode with the filter worked great.
For the second questions, I would like a drop down list where they choose an industry and I give back all the chapter that don’t have that industry.
Thanks and Happy New Year!
Oh, I see, were talking about a user search? That will be more difficult, it will entail building a custom search control for the list display. The plugin doesn’t have something like that built in.
How would it work if I used the code above. Would this give me all the chapters that don’t have an accountant. Do you have a link to the “other notes page”. Thanks
“For instance, if there was a field named “accountant” where a name would be saved if there was an accountant, you could show all the records that have nothing stored in the “accountant” field with this:
[pdb_list filter=”accountant=”]
What that means is “find all records where the accountant field is equal to no value” This is explained where list filtering is explained on the Other Notes page”
The Other Notes page is here on WordPress.org
Hi – I went through the other notes section. Instead of having a dropdown could I have a user key in an industry and then use this value in the filter to show chapters without this industry. (industry is a field in the database). In my old system , I had orginally coded this as a subselect. Could I add this custom code in.
Thanks
OK, to do this kind of thing, you need to create a custom search function. This is, unfortunately, not well documented at this point, mostly because I am preparing a major release of the plugin that offers new methods for creating custom search controls. I am waiting until this is released before I document the process of creating you own custom search function.
If you are a coder, have a look at the Plugin API, it will give you the methods currently available to implement your custom search controls.
If you want to contact me about doing some custom coding work, email me at support@xnau.com
Ok – thanks. Should I wait for the new release. Will it let me do this search easier?
On my listing page I want to display a bio. Right now the field is small and it is scrollable. Is there a way to increase the size of this field and decrease another field.
Thanks
Also is there a way to display a field on one listing but not the other. On the region listing I need to display chapter name but on the chapter listing page, I don’t have to display the chapter name since it is only displaying that particular chapter.
If you need help in testing the new version of the plugin I would be happy to help
Thanks
Unless you’re really not in a hurry, I wouldn’t recommend you wait…it will be several weeks before the new version comes out.
To control the width of a table columns, you can usually just set the width of the header row cell for that column, Doesn’t always work, though, because table cells will expand according to their content. The “bio” field gets around this by wrapping the text in another element that is sized. That gives it the scroll.
If you’re interested in testing the beta, send me an email: support@xnau.com
Thanks – I will look through the API. Is having the feature to searching for chapters that don’t have a particular industry something that can be done. When I orginally coded it I used a subselect.
Also for the search I have now on industy I would like to create a drop down. When I created the dropdown for the chapters I just keyed them in with commas separated them since is was only 30 of them. I have a few hundred industries – is there a quick way to cut and paste them.
What I do is use a spreadsheet to lay out all the values and titles in columns, and add a third column that concatenates them so you have a “title::value” for each one. Then I copy that column and paste it into a text editor. Replace the line returns with a comma and you’ve got your massive string to paste into the values field.
The nice thing about the spreadsheet is it allows you to maintain a huge list of options easily. Save it as a backup in case the field options setting gets borked.
Thanks – I got industry values in as a dropdown.
When I do a search how can I get the dropdown to display so they can pick an industry instead of typing it in
I was going through the APIs. I’m not sure where to begin to set it up so a person can search for chapters that have an opening in a particular field. Which one should I use. How much would the cost be if I had you do this. Thanks
OK, I believe we’re discussing thing via email at this point, so I’ll answer your questions that way.
