Question

I successfully used the "Data-From Text" function in Excel to create a refreshable view of FB cases using this url as source:

https://myfbod.fogbugz.com/default.asp?pg=pgPluginBinary&ixPlugin=1

However, this method just picks up the "current filter" so I was wondering if there is a way to get the csv exporter plugin to use a specific filter?

I tried appending &ixFilter=3 but it didn't work

Answer 1

As of version 1.2.1, you can append

&P[ixPlugin]_ixFilter=[ixFilter]

to the URL, where ixPlugin is the plugin id (you can get it from the URL that it takes you to when you export a filter), and ixFilter is the filter id (you can get this from the URL of a filter). For example:

http://my.fogbugz.com/default.asp?pg=pgPluginBinary&ixPlugin=1&P1_ixFilter=4

You can also append a search string in version <1.2.1:

&P[ixPlugin]_sSearch=[search]

For example

http://my.fogbugz.com/default.asp?pg=pgPluginBinary&ixPlugin=1&P1_sSearch=assignedto%3a%22me%22