how to put the '(All)' value in filter by using req_option
Describe the bug I have several filter put in report, the original view is setting filter as value 'a' and when I pulled the data through script, I want to include them all, I used req_option and set the value as '(All)', but there is no changes
To Reproduce.
po_req_option.vf('Risk Category', '(All)')
Results no thing different compare to the original view data
NOTE: Be careful not to post user names, passwords, auth tokens or any other private or sensitive information.
So you have a view that has this data
[Risk Category, A] [Risk Category, B]
and a filter on the view is set to show only A
I don't think using the special value '(All)' is accepted through the API. You probably need to explicitly pass in all the possible values, e.g. po_req_option.vf('Risk Category', 'A&B&C') This is based on the info at https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_concepts_filtering_and_sorting.htm#Filter-query-views