Jump to content
View in the app

A better way to browse. Learn more.

Learn more

How do database filters work?

Featured Replies

I'm creating a database, I tried to add the database filter widget but it says "This block cannot be shown. This could be because it needs configuring, is unable to show on this page, or will show after reloading this page."

After reloading the page, the block is hidden.

The only settings for that block are Visibility/Advanced, none of them make the widget work.

Not sure what I'm missing?

  • Author

I have a couple of custom fields, that I would like to filter. Not sure if there's something specific to do to make the fields "filterable"?

  • Community Expert

Please screenshot them and I can let you know what it is you have wrong there

  • Author

Here's one field. Note that I have to reselect the Listing View Format (=Value) every time I edit anything else and before I save again, as it's always deselected, as you can see on the screenshot.

screenshot 6.jpg

screenshot 5.jpg

  • Community Expert

Ah, its because its a text field. You would need something the filter block can actually add filters to. For example a select field, or radio field.

  • Author

I've set it to "Select Box", gave it a few key/value, saved, chose some values for each record, and the database filter widget still doesn't appear.

screenshot.jpg

  • Author

Nevermind I finally saw the Allow filtering checkbox. Thanks!

Now, whenever I make an edit to a field, and attempt to save it, I get the following error. I have to click the Display Options tab and re-select a Listing View Format for both the listing view and display view before I can save my changes. Every time.

screenshot (1).jpg

  • Community Expert

Click on the display options tab and fill in whatever is highlighted

  • Author
39 minutes ago, Marc said:

Click on the display options tab and fill in whatever is highlighted

Yes, I know, but every time I edit anything I have to do this again.

Say for example I want to add a new Key/Value pair. I edit the field, add my Key/Value pair, and I have to click the display option and RE-select a listing view format for both views. Then I can save. I have to RE-select listing view formats for both views every time I edit any other setting.

  • Community Expert

It depends on what you change. Some you will have to, as the options change.

  • Author
18 minutes ago, Marc said:

It depends on what you change. Some you will have to, as the options change.

No matter what I change, I get prompted to reselect the listing view formats, even though the options are the same and I always reselect the same.

For example if I click edit and toggle Multiple Selection, I get the error.

In fact even if I don't make any changes at all, I get the error when trying to save.

  • Author
4 minutes ago, Ryan Ashbrook said:

We released a patch for that. Go to System > Get Support and make sure all patches are applied.

Patch installed, problem solved. Thanks!

Recently Browsing 0

  • No registered users viewing this page.

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.