8000 csv_req_option can not filter if it's a boolean filter · Issue #1464 · tableau/server-client-python · GitHub
[go: up one dir, main page]
Skip to content

csv_req_option can not filter if it's a boolean filter #1464

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.

Sign up for GitHub

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

Jump to bottom
Closed
irisx0719 opened this issue Sep 17, 2024 · 3 comments
Closed

csv_req_option can not filter if it's a boolean filter #1464

irisx0719 opened this issue Sep 17, 2024 · 3 comments
Labels
help wanted A user needs help, may be a mistake, a bug or a feature request

Comments

@irisx0719
Copy link

Describe the bug
I tried to download the data from tableau and save it in csv format, but when I tried to filter data on a boolean filter, it doesn't work

Versions
Details of your environment, including:

  • Tableau Server version (or note if using Tableau Online): 2023.1.8
  • Python version: python 3.11.6
  • TSC library version: 0.30

To Reproduce
csv_req_option = tsc.CSVRequestOptions(maxage=5)
csv_req_option .vf('filter1', 'abc')
csv_req_option .vf('filter2', 'True')

Results

filter1 works good, because filter1 is a normal filter with option in text format, but filter2 doesn't work, because filter2 is a boolean filter. But I don't know how to put the value in req_option if I want to filter the data with boolean filter2 with filter2 =True. and I didn't see any instruction in document saying about this one.

NOTE: Be careful not to post user names, passwords, auth tokens or any other private or sensitive information.
@jacalata jacalata added the help wanted A user needs help, may be a mistake, a bug or a feature request label Sep 18, 2024
@bcantoni
Copy link
Contributor

@irisx0719 I was recently looking at boolean filters and I think you need to pass them in as lower-case strings, for example "true" or "false". It seems that the Tableau Server/Cloud backend treats those as case sensitive.

Let us know if that works for you and we can turn this into a documentation story to make that more clear.

@irisx0719
Copy link
Author

@irisx0719 I was recently looking at boolean filters and I think you need to pass them in as lower-case strings, for example "true" or "false". It seems that the Tableau Server/Cloud backend treats those as case sensitive.

Let us know if that works for you and we can turn this into a documentation story to make that more clear.

thank you @bcantoni, I tried put to the lower-case string and the problem solved.

@jacalata
Copy link
Contributor
jacalata commented Sep 20, 2024 •
edited
Loading

Added a note here - #1471

bcantoni pushed a commit that referenced this issue Sep 28, 2024
@jacalata
#1464 - docs update for filtering on boolean values (#1471)
9a31004 
Add docs mention of boolean values for filtering
jacalata added a commit that referenced this issue Oct 24, 2024
@renoyjohnm @bcantoni
@jorwoods @jacalata @Der-Henning @AlbertWangXu @TrimPeachu
0.34 development merge
6798b9e 
* Feature: export custom views #999 (#1506)
* feat(exceptions): separate failed signin error (#1478)
* refactor request_options, add language param (#1481)
* Set FILESIZE_LIMIT_MB via environment variables (#1466)
* added PulseMetricDefine cap (#1490)
* Adding project permissions handling for databases, tables and virtual connections (#1482)
* fix: queryset support for flowruns (#1460)
* fix: set unknown size to sys.maxsize
* fix: handle 0 item response in querysets (#1501)
* chore: support VizqlDataApiAccess capability (#1504)
* refactor(test): extract error factory to _utils
* chore(typing): flowruns.cancel can also accept a FlowRunItem
* chore: type hint default permissions endpoints (#1493)
* chore(versions): update remaining f-strings (#1477)
* Make urllib3 dependency more flexible (#1468)
* Update requests library for CVE CVE-2024-35195 (#1507)

* chore(versions): Upgrade minimum python version (#1465)
* ci: cache dependencies for faster builds (#1497)
* ci: build on python 3.13 (#1492)
* Update samples for Python 3.x compatibility (#1479)
* chore: remove  py2 holdover code (#1496)
* #Add 'description' to datasource sample code (#1475)
* Remove sample code showing group name encoding (#1486)
* chore(typing): include samples in type checks (#1455)

* fix: docstring on QuerySet
* docs: add docstrings to auth objects and endpoints (#1484)
* docs: docstrings for Server and ServerInfo (#1494)
* docs: docstrings for user item and endpoint (#1485)
* docs: docstrings for site item and endpoint (#1495)
* docs: workbook docstrings (#1488)
* #1464 - docs update for filtering on boolean values (#1471)

---------
Co-authored-by: Brian Cantoni <bcantoni@salesforce.com>
Co-authored-by: Jordan Woods <jorwoods@users.noreply.github.com>
Co-authored-by: Jordan Woods <13803242+jorwoods@users.noreply.github.com>
Co-authored-by: Jac <jacalata@users.noreply.github.com>
Co-authored-by: Henning Merklinger <henning.merklinger@gmail.com>
Co-authored-by: AlbertWangXu <albert.xuwang@yahoo.com>
Co-authored-by: TrimPeachu <77048868+TrimPeachu@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
help wanted A user needs help, may be a mistake, a bug or a feature request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@bcantoni @jacalata @irisx0719
0