Description

r-richmond

opened on Nov 3, 2016

Issue body actions

Certain Datasources have query bands and it would be extremely helpful to be able to modify these programatically.

Activity

1. t8y8 commented on Nov 3, 2016

   

   t8y8

   on Nov 3, 2016

   Contributor

   More actions

   @r-richmond Thank you for opening a request!

   Would it be possible to include a dummy-tds or twb that already has a query band in it?
   It would also be great to include a sample query band update you might make.
   It's very helpful for us when building test cases and understand the requirements.

   (I'm marking this as an enhancement)
2. t8y8

   added

   enhancement

   on Nov 3, 2016
3. r-richmond commented on Nov 3, 2016

   

   r-richmond

   on Nov 3, 2016

   ContributorAuthor

   More actions

   Sure,

   I've attached a dummy workbook that contains both sample query bands & sample initial sql.

   As far as an example use case. I would like to be able to write something like

   for workbook in folder:
     for datasource in workbook:
       if datasource.query_band is none:
         datasource.query_band = 'TableauReport=<workbookname>';
      elif datasource.query_band does not contain 'TableauReport=<workbookname>':
         datasource.query_band += '\n TableauReport=<workbookname>';
   

   note: in this case I'd like to be the special value that you can use in query bands now and not a hardcoded string of the current workbook name.

   bands_initial_dummy_workbook.twb.zip
4. t8y8

   added a commit that references this issue on Jan 9, 2017

   Add `initial sql` and `query band` support (#123)

   cc97fc4
5. graysonarts

   added a commit that references this issue on Jan 11, 2017

   Release 0.6 (#126)

   65fbc80
6. r-richmond commented on Jan 20, 2017

   

   r-richmond

   on Jan 20, 2017

   ContributorAuthor

   More actions

   Marking this as closed with release 0.6 & the merging of #123
7. r-richmond

   closed this as completedon Jan 20, 2017

Issue actions