search

ljay79 / jira-tools

Project Aid for Jira - Google Spreadsheet Add-on for Jira Integration
GNU General Public License v3.0
112 stars 46 forks source link

List Issues from Filter Not Returning All Fields Requested (11 of 17) #205

Closed jeffrmanley closed 5 years ago

jeffrmanley commented 5 years ago

The List Issues from Filter is no longer returning all fields requested. It shows 12 headers when it should be 17. It is only displaying data for 11 of the 12 fields.

We recently renamed a fields from "Actual ETA" to "ETC" in Jira. I deleted the custom fields from Configure Custom Fields and then re-added them. I also created a new new clean worksheet and it gives the same result.

I turned on our temp user key: AANBUuXNismlhcD+t9PM+7mpDK0BGVZPDJjwIlJzWkmkwOLjMNu5D6JQAiQ7/pAOe8gfrgSkc8YU

I'll attach screen shots

jeffrmanley commented 5 years ago

ShowsOnly12FieldHeaders SelectedFilterandFields

jeffrmanley commented 5 years ago

I further tested further using =JST_search("project=IMPSMSM","key,created, workstream,updated,WIPCompletedTime",100,0)

See screenshot for what was returned

CustomField

Below is what Jira was showing....

FromJira

jeffrmanley commented 5 years ago

@ljay79 - we are still having issues with this....any suggestions?

ljay79 commented 5 years ago

Hi, sry for late reply. Im a little busy atm. Will investigate it over the next days and check if i am able to replicate it an/or fix it.

ljay79 commented 5 years ago

About 2)

...=JST_search("project=IMPSMSM","key,created, workstream,updated,WIPCompletedTime",100,0) Im sure this is because the custom functions like _JSTsearch() do not understand the names of custom fields. Yould need to use the actual jira key id. You can find it by looking up your field with the Jira Field Map over the add-on's menu.

It would then look like: =JST_search("project=IMPSMSM","key,created, workstream,updated,customfield_33901",100,0)

About 1) Im trying to replicate this. Any further details would be helpful. So far, i wasnt able to replicate. I created a new filter which do returns me 2 different jira issues from 2 different projects. 1 issue has a custom field, which the other issues scheme doest. In the google sheet it returns as expected, the value for one issue and an empty cell for the other.

ljay79 commented 5 years ago

Good news... I was able to reproduce it now. Apparently you are using different "Field Configurations" for your projects. Some project have certain fields hidden some now. Your filter is quering issues across multiple projects where not all of them have your desired custom fields available. My add-on apparently is not capable of working with such behavior in the data.

As i have now a way of reproducing and testing it, i will now start on working a solution for such cases. Please give me a little time :) (PS: This is a private low prio project to me still)

ljay79 commented 5 years ago

Hi @jeffrmanley in the latest release v1.3.4 i have applied a fix which should solve your issue now.

jeffrmanley commented 5 years ago

Hi @ljay79 ...thanks for the quick fix. I confirm it is working!! You are the BEST!!

ljay79 commented 5 years ago

Great. After all, bug reports are very important. It allows me to make this addon better for everyone.

I would appreciate a positive review in the Google marketplace ;)