Project

General

Profile

Custom Query to return specific columns: solved, not possible

Added by Nic Dev almost 7 years ago

Hello,

I'm trying to get only the id and due date columns of issues inside of a response but my approach using a custom query is not working. My custom query has

Filter set to "Due Date(any)" and
Options / Selected Columns set to "Due Date" (To only return the ID and the Due Date)

The response to /issues.xml?query_id=myqueryid contains every field of every issue found.

Pasting /issues?query_id=myqueryid directly in the browser returns a list as i want it, only showing the id and due date.

Any help is greatly appreciated.

  Redmine version                3.3.0.stable
  Ruby version                   2.2.1-p85 (2015-02-26) [x86_64-linux]
  Rails version                  4.2.6
  Environment                    production
  Database adapter               Mysql2

Other thread of me:
https://stackoverflow.com/questions/44886894/redmine-custom-query-to-return-only-specific-columns
Related thread: Redmine REST API possibility to select columns in response

// Edit:

My question got answered:
"Redmine's REST API (i.e. the JSON and XML APIs) always returns all base fields of filtered issues." Thanks.