Bug 1293891 - "Name" parameter does not work with category Collection for querying
Summary: "Name" parameter does not work with category Collection for querying
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: API
Version: 5.5.0
Hardware: x86_64
OS: Linux
medium
high
Target Milestone: GA
: 5.6.0
Assignee: Tim Wade
QA Contact: Taras Lehinevych
URL:
Whiteboard:
Depends On:
Blocks: 1302443
TreeView+ depends on / blocked
 
Reported: 2015-12-23 12:04 UTC by Prasad Mukhedkar
Modified: 2019-10-10 10:46 UTC (History)
8 users (show)

Fixed In Version: 5.6.0.0
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 1302443 (view as bug list)
Environment:
Last Closed: 2016-06-29 15:24:10 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2016:1348 0 normal SHIPPED_LIVE CFME 5.6.0 bug fixes and enhancement update 2016-06-29 18:50:04 UTC

Description Prasad Mukhedkar 2015-12-23 12:04:53 UTC
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.

Comment 2 Tim Wade 2016-01-07 16:29:02 UTC
PR: https://github.com/ManageIQ/manageiq/pull/6074

Comment 3 Taras Lehinevych 2016-04-08 13:40:43 UTC
Verified in 5.6.0.0-beta1.20160322143549_f7ea680

Comment 5 errata-xmlrpc 2016-06-29 15:24:10 UTC
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


Note You need to log in before you can comment on or make changes to this bug.