Opened 4 years ago

Closed 4 years ago

#2731 closed defect (invalid)

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

Reported by: gluckett Owned by:
Priority: medium Milestone:
Component: General Version: 3.0.0
Severity: trivial Keywords: query
Cc: External ID:

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 (1)

comment:1 Changed 4 years ago by jng

Resolution: invalid
Status: newclosed

Can you move this ticket over to the Fusion trac instance? Thanks.

Note: See TracTickets for help on using tickets.