Description of problem: Problem with API : Unable to filter the resources using name parameter /api/categories?expand=resources&filter[]=name='location' if I execute above query we are getting following error {"error": { "kind": "internal_server_error", "message": "ERROR: column classifications.name does not exist\nLINE 1: ...ns\" WHERE \"classifications\".\"parent_id\" = $1 AND (\"classific...\n ^\n", "klass": "PG::UndefinedColumn" }} Version-Release number of selected component (if applicable): 5.5.0.13.20151201120956_653c0d4 How reproducible: always Actual results: Error, Filtering does not work Expected results: Filtering should work and desired output should shown Additional info: vmdb_production#select * from classification; id | 99000000000001 description | Location icon | read_only | f syntax | string single_value | t example_text | The geographic location of the resource, such as New York, Chicago, or London. tag_id | 99000000000004 parent_id | 0 show | t default | t perf_by_tag | "Name" column is not there in the table. Hence, The failure.
PR: https://github.com/ManageIQ/manageiq/pull/6074
Verified in 5.6.0.0-beta1.20160322143549_f7ea680
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2016:1348