Posted by echo on Tue, Apr 26, 2022 - 4:19pm

I have a view listing a content type using one repeating_dates field (thx @indigoxela). The content type has some nodes choosing repeating, and some nodes choosing "Do not repeat". It is the same field.

What I can't get to work is a node disappears from the view after it's date has passed.

This is because the the only way I have found to get a multiple field node to display only one instance, is to filter thedatefield:delta (= 0).

But that includes all the single dated nodes, past + future, as all are delta = 0.

What works for the single dated node, is using the filter of either thedatefield start or end >= now.

But that keeps multiples with delta = 0 showing up, since their delta = 0 is in the past.

I've tested many filter group options, grouping variations of these filters with -And Or- Operators.

Enabling Distinct or aggregation is no help.

In D7, it worked by filtering Date (node). This only includes core date fields to check, the repeating_dates field doesn't show up.

What are other ways to get a multi repeating_dates field to show only one?

Accepted answer

Thanks for posting. This helps me understand a bit better your situation. I think your best chance is to post an "enhancement" or "feature request" issue in the Repeating Date github issue queue.

I noticed this module uses Views "standard" date handlers. Since this is a special field, it would make sense for the maintainers to extend some of those to support features like what you are asking. Since this is a module that was created for Backdrop and the maintainer is a very active developer, you have a good chance to get heard. 

Comments

Tue, Apr 26, 2022 - 5:59pm by argiepiano

Hi echo. This sounds like a job for a custom views field and/or filter handler. Probably best done as a custom field handler (rather than a custom filter handler), since that would allow for post-query processing to show/hide repetitions that are in the past. It may be helpful if you posted a simplified export of your view.

Tue, Apr 26, 2022 - 6:10pm by echo

Thanks for responding!

Anywhere I could upload as a file rather than text?

Tue, Apr 26, 2022 - 6:38pm by argiepiano

Pasting as text here should be fine - modify the view to its simplest version first. 

Tue, Apr 26, 2022 - 6:55pm by echo

Ugh, I don't know what to take out, and I tried all here with formatting code block json, and it resulted in an error that it was too long. Suggestions?

Tue, Apr 26, 2022 - 8:21pm by echo 

{
    "_config_name": "views.view.clone_of_trainings",
    "name": "clone_of_trainings",
    "description": "",
    "tag": "default",
    "disabled": false,
    "base_table": "node",
    "human_name": "Clone of Trainings",
    "core": "1.21.4",
    "display": {
        "default": {
            "display_title": "Master",
            "display_plugin": "default",
            "display_options": {
                "query": {
                    "type": "views_query",
                    "options": []
                },
                "access": {
                    "type": "perm",
                    "perm": "access content"
                },
                "cache": {
                    "type": "none"
                },
                "exposed_form": {
                    "type": "basic",
                    "options": []
                },
                "pager": {
                    "type": "none",
                    "options": {
                        "items_per_page": ""
                    }
                },
                "style_plugin": "default",
                "row_plugin": "fields",
                "fields": {
                    "title": {
                        "id": "title",
                        "table": "node",
                        "field": "title",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 0,
                            "ellipsis": 0,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "h2",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": false,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "link_to_node": 1
                    },
                    "field_date_time": {
                        "id": "field_date_time",
                        "table": "field_data_field_date_time",
                        "field": "field_date_time",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "label": "",
                        "exclude": 0,
                        "alter": {
                            "alter_text": 0,
                            "text": "",
                            "make_link": 0,
                            "path": "",
                            "absolute": 0,
                            "external": 0,
                            "replace_spaces": 0,
                            "path_case": "none",
                            "trim_whitespace": 0,
                            "alt": "",
                            "rel": "",
                            "link_class": "",
                            "prefix": "",
                            "suffix": "",
                            "target": "",
                            "nl2br": 0,
                            "max_length": "",
                            "word_boundary": 1,
                            "ellipsis": 1,
                            "more_link": 0,
                            "more_link_text": "",
                            "more_link_path": "",
                            "strip_tags": 0,
                            "trim": 0,
                            "preserve_tags": "",
                            "html": 0
                        },
                        "element_type": "",
                        "element_class": "",
                        "element_label_type": "",
                        "element_label_class": "",
                        "element_label_colon": false,
                        "element_wrapper_type": "",
                        "element_wrapper_class": "",
                        "element_default_classes": 1,
                        "empty": "",
                        "hide_empty": 0,
                        "empty_zero": 0,
                        "hide_alter_empty": 1,
                        "click_sort_column": "dtstart",
                        "type": "repeating_date_list",
                        "settings": {
                            "hide_description": 0,
                            "datetime_format": "medium",
                            "dateonly_format": "html_date",
                            "timeonly_format": "time_only"
                        },
                        "group_column": "",
                        "group_columns": [],
                        "group_rows": 0,
                        "delta_limit": "1",
                        "delta_offset": "0",
                        "delta_reversed": 0,
                        "delta_first_last": 0,
                        "multi_type": "separator",
                        "separator": ", ",
                        "field_api_classes": 0
                    }
                },
                "filters": {
                    "status": {
                        "value": 1,
                        "table": "node",
                        "field": "status",
                        "id": "status",
                        "expose": {
                            "operator": false
                        },
                        "group": 1
                    },
                    "type": {
                        "id": "type",
                        "table": "node",
                        "field": "type",
                        "value": {
                            "training": "training"
                        }
                    },
                    "delta": {
                        "id": "delta",
                        "table": "field_data_field_date_time",
                        "field": "delta",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "operator": "=",
                        "value": {
                            "min": "",
                            "max": "",
                            "value": "0"
                        },
                        "group": "1",
                        "exposed": false,
                        "expose": {
                            "operator_id": false,
                            "label": "",
                            "description": "",
                            "use_operator": false,
                            "operator": "",
                            "identifier": "",
                            "required": false,
                            "remember": false,
                            "multiple": false,
                            "remember_roles": {
                                "authenticated": "authenticated"
                            }
                        },
                        "is_grouped": false,
                        "group_info": {
                            "label": "",
                            "description": "",
                            "identifier": "",
                            "optional": true,
                            "widget": "select",
                            "multiple": false,
                            "remember": 0,
                            "default_group": "All",
                            "default_group_multiple": [],
                            "group_items": []
                        }
                    }
                },
                "sorts": {
                    "field_date_time_dtstart": {
                        "id": "field_date_time_dtstart",
                        "table": "field_data_field_date_time",
                        "field": "field_date_time_dtstart",
                        "relationship": "none",
                        "group_type": "group",
                        "ui_name": "",
                        "order": "ASC",
                        "exposed": false,
                        "expose": {
                            "label": ""
                        },
                        "granularity": "second"
                    }
                },
                "title": "Trainings",
                "row_options": {
                    "default_field_elements": 1,
                    "inline": [],
                    "separator": "",
                    "hide_empty": 1
                },
                "header": [],
                "empty": []
            }
        },
        "page": {
            "display_title": "Page",
            "display_plugin": "page",
            "display_options": {
                "query": {
                    "type": "views_query",
                    "options": []
                },
                "path": "trainings",
                "menu": {
                    "type": "none",
                    "title": "Trainings",
                    "description": "",
                    "name": "main-menu",
                    "weight": "0",
                    "context": 0,
                    "context_only_inline": 0
                }
            }
        }
    }
}

Tue, Apr 26, 2022 - 8:23pm by echo

There ya go, I took out irrelevant parts.

Wed, Apr 27, 2022 - 6:35am by argiepiano

Thanks for posting. This helps me understand a bit better your situation. I think your best chance is to post an "enhancement" or "feature request" issue in the Repeating Date github issue queue.

I noticed this module uses Views "standard" date handlers. Since this is a special field, it would make sense for the maintainers to extend some of those to support features like what you are asking. Since this is a module that was created for Backdrop and the maintainer is a very active developer, you have a good chance to get heard. 

indigoxela's picture

Thu, Apr 28, 2022 - 12:23am by indigoxela

I'd like to note that repeating dates filtered to those being in the future works out of the box for me.

Nothing with delta (what should that do, anyway).

Technically these dates are in individual rows in the db table. Whether they repeat or not isn't relevant for the view.

indigoxela's picture

Thu, Apr 28, 2022 - 12:45am by indigoxela

Ah, possibly I misunderstood... Only the first.

But hey, that also works out of the box for me, as soon as I filter for "delta = 0".