| Summary: | "Name" parameter does not work with category Collection for querying | |||
|---|---|---|---|---|
| Product: | Red Hat CloudForms Management Engine | Reporter: | Prasad Mukhedkar <pmukhedk> | |
| Component: | API | Assignee: | Tim Wade <twade> | |
| Status: | CLOSED ERRATA | QA Contact: | Taras Lehinevych <tlehinev> | |
| Severity: | high | Docs Contact: | ||
| Priority: | medium | |||
| Version: | 5.5.0 | CC: | cpelland, dajohnso, gtanzill, jhardy, jprause, mfeifer, obarenbo, twade | |
| Target Milestone: | GA | Keywords: | ZStream | |
| Target Release: | 5.6.0 | |||
| Hardware: | x86_64 | |||
| OS: | Linux | |||
| Whiteboard: | ||||
| Fixed In Version: | 5.6.0.0 | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 1302443 (view as bug list) | Environment: | ||
| Last Closed: | 2016-06-29 15:24:10 UTC | Type: | Bug | |
| Regression: | --- | Mount Type: | --- | |
| Documentation: | --- | CRM: | ||
| Verified Versions: | Category: | --- | ||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | ||
| Cloudforms Team: | --- | Target Upstream Version: | ||
| Bug Depends On: | ||||
| Bug Blocks: | 1302443 | |||
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 |
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.