Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

formula property filters accept string instead of text. #248

Closed
Tracked by #243
KoditkarVedant opened this issue Jul 10, 2022 · 0 comments · Fixed by #266 or #276
Closed
Tracked by #243

formula property filters accept string instead of text. #248

KoditkarVedant opened this issue Jul 10, 2022 · 0 comments · Fixed by #266 or #276
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@KoditkarVedant
Copy link
Contributor

KoditkarVedant commented Jul 10, 2022

Rollup property filters must now be constructed with the string keyword instead of the text keyword if the value of the formula is a string.

Put concretely, if a page's formula property is rendered like so:

"formula property": {
    "id": "m%5D%3F%5C",
    "type": "formula",
    "formula": {
        "type": "string",
        "string": "update text 2,another text"
    }
}

This filter will no longer work in version 2022-02-22:

{
    "filter": {
        "property": "formula property",
        "formula": {
            "text": {
                "contains": "update text"
            }
        }
    }
}

Instead, write this:

{
    "filter": {
        "property": "formula property",
        "formula": {
            "string": {
                "contains": "update text"
            }
        }
    }
}

Notion changelog: https://developers.notion.com/changelog/releasing-notion-version-2022-02-22

@KoditkarVedant KoditkarVedant changed the title formula query database filters no longer accept the text keyword. Use string instead. formula property filters accept string instead of text. Jul 10, 2022
@KoditkarVedant KoditkarVedant added this to the 3.0.0 milestone Jul 10, 2022
@KoditkarVedant KoditkarVedant added enhancement New feature or request help wanted Extra attention is needed up for grabs labels Jul 10, 2022
@KoditkarVedant KoditkarVedant linked a pull request Jul 10, 2022 that will close this issue
10 tasks
@KoditkarVedant KoditkarVedant self-assigned this Jul 10, 2022
@KoditkarVedant KoditkarVedant removed help wanted Extra attention is needed up for grabs labels Jul 13, 2022
@KoditkarVedant KoditkarVedant linked a pull request Jul 17, 2022 that will close this issue
11 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
1 participant