Opened 8 months ago

Closed 8 months ago

Last modified 8 months ago

#650 closed defect (fixed)

In Fusion Query Widget, fields with Spaces and Brackets give FDO Filter Errors

Reported by: gluckett Owned by: jng
Priority: P2 Milestone: Future
Component: Widgets Version: 2.0.0-RC1
Severity: Major Keywords:
Cc: Browser: All
External ID: Operating System: All
state: New

Description

The Query widget fails in the underlying columns with unsupported characters such as brackets or spaces are found.

Solution, add Quotes around field name in Filter.

Main Size (m) > 50 becomes "Main Size (m)" > 50

Change \www\fusion\widgets\Query\classes\query.php

Around line: 261 from

 $propertyFilter = $this->args['PROPERTYNAME'];

to

 $propertyFilter = '"' . $this->args['PROPERTYNAME'] . '"';

Change History (3)

comment:1 Changed 8 months ago by jng

Owner: changed from madair to jng

comment:2 Changed 8 months ago by jng

Resolution: fixed
Status: newclosed

comment:3 Changed 8 months ago by jng

Fixed trunk (r2946), 3.1 (r2947), 3.0 (r2948) and 2.6 (r2949)

Note: See TracTickets for help on using tickets.