Mailing List Archive

I have RT 4.2.3 and PostgreSQL database.

When user creates new ticket in field "Depends on" there is such attribute:

exclude="new"

as result such request for autocomplete generates:

http://localhost:9090/ticket/Helpers/Autocomplete/Tickets?exclude=new
<http://localhost:9090/ticket/Helpers/Autocomplete/Tickets?exclude=new&term=
825467> &term=825467

In share/html/Helpers/Autocomplete/Tickets there are such lines:

98 if ( @excludes ) { # exclude ids already these

99 $sql = join ' AND ', "($sql)", map { qq{id != '$_'} } @excludes;

100 }

As result I have such SQL

SELECT main.* FROM Tickets main WHERE (main.IsMerged IS NULL) AND
(main.Status != 'deleted') AND (main.Type = 'ticket') AND ( ( main.Subject
ILIKE '%825467%' OR CAST(main.id AS TEXT) LIKE '825467%' ) AND main.id !=
'new') LIMIT 10'

And then I have database error:

ERROR: invalid input syntax for integer: "new"

LINE 10: AND main.id != 'new'

^

********** ïÛÉÂËÁ **********



ERROR: invalid input syntax for integer: "new"

As I see problem in comparison integer and string with operator !=. But few
symbols upper above RT adds 'cast(: as text)'.

I think problem that RT add cast as text only if see
MATCHES|ENDSWITH|STARTSWITH|LIKE

For modification existing tickets autocomplete works fine.

May be in file share/html/Helpers/Autocomplete/Tickets change line

$sql = join ' AND ', "($sql)", map { qq{id != '$_'} } @excludes;

to

$sql = join ' AND ', "($sql)", map { qq{id not like '$_'} } @excludes;

?