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

Report filters. Error: BAD_REQUEST: Some fields, including description and long text area fields, can't be included in filter logic. #110

Open
JacobNord opened this issue Sep 15, 2021 · 2 comments
Assignees
Labels
bug Unintended behavior that should be corrected
Milestone

Comments

@JacobNord
Copy link

Issue description

A brief description of the problem.

When filtering on the fly, I simply wish to change the date filter on the report as it comes into R. Currently the report shows me YESTERDAY in salesforce, along with other filters. When I pull it in I want to be able to change date that as needed.

When I try and change this one filter, it seems to not preserve any of the others.

vfilter1 <- list(column ="CREATED_DATE",
                operator = "equals",
                value = "LAST 7 Days")

This filter works, but when alone, the other filters already on the report seem to not be preserved.
So i tried to add all the filters so i could change one as needed.

When i attempt to add one of the filters, it gives me that above error.

 report_details$reportMetadata$reportFilters #tells me the fields
[[1]]
[[1]]$column
[1] "field_key"

[[1]]$filterType
[1] "fieldValue"

[[1]]$isRunPageEditable
[1] TRUE

[[1]]$operator
[1] "equals"

[[1]]$value
[1] "Dealer Name"

#filter based on the report details

vfilter3 <- list(column = "field_key",
                 operator = "equals",
                 value = "Dealer Name")

this filter is exactly what sales force shows, and what the report filter shows with the above command, but produces an error

@StevenMMortimer
Copy link
Owner

@JacobNord Thanks for raising. I'm not sure if you tried this, but have you passed a list of lists? Like this:

filters <- list(
  list(column = "field_key", operator = "equals", value = "Dealer Name"),
  list(column = "CREATED_DATE", operator = "equals", value = "LAST 7 Days")
)

@StevenMMortimer StevenMMortimer added the question or help Clarification or help may suffice to resolve label Sep 17, 2021
@JacobNord
Copy link
Author

JacobNord commented Sep 17, 2021

@StevenMMortimer I get the same error. "Error: BAD_REQUEST: Some fields, including description and long text area fields, can't be included in filter logic. See the help for more information."

@StevenMMortimer StevenMMortimer added bug Unintended behavior that should be corrected and removed question or help Clarification or help may suffice to resolve labels Dec 22, 2021
@StevenMMortimer StevenMMortimer added this to the v1.0.2 milestone Mar 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Unintended behavior that should be corrected
Projects
None yet
Development

No branches or pull requests

2 participants