jro_apps/redmine Commit - r15815:14a98af864c1

976

"#{queried_table_name}.id #{not_in} IN (" +

976

"#{queried_table_name}.id #{not_in} IN (" +

977

"SELECT customized_id FROM #{CustomValue.table_name}" +

977

"SELECT customized_id FROM #{CustomValue.table_name}" +

978

" WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +

978

" WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +

979

" AND value ~~<> '' AND CAST(value AS integer~~) IN (" +

979

" AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +

980

" SELECT customized_id FROM #{CustomValue.table_name}" +

980

" SELECT customized_id FROM #{CustomValue.table_name}" +

981

" WHERE customized_type='#{target_class}' AND custom_field_id=#{chained_custom_field_id}" +

981

" WHERE customized_type='#{target_class}' AND custom_field_id=#{chained_custom_field_id}" +

982

" AND #{sql_for_field(field, operator, value, CustomValue.table_name, 'value')}))"

982

" AND #{sql_for_field(field, operator, value, CustomValue.table_name, 'value')}))"

998

"#{queried_table_name}.id #{not_in} IN (" +

998

"#{queried_table_name}.id #{not_in} IN (" +

999

"SELECT customized_id FROM #{CustomValue.table_name}" +

999

"SELECT customized_id FROM #{CustomValue.table_name}" +

1000

" WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +

1000

" WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +

1001

" AND value ~~<> '' AND CAST(value AS integer~~) IN (" +

1001

" AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +

1002

" SELECT id FROM #{target_table_name} WHERE #{sql_for_field(field, operator, value, filter[:field].format.target_class.table_name, attribute)}))"

1002

" SELECT id FROM #{target_table_name} WHERE #{sql_for_field(field, operator, value, filter[:field].format.target_class.table_name, attribute)}))"

1003

end

1003

end

1004

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

                 "#{queried_table_name}.id #{not_in} IN (" +
                   "SELECT customized_id FROM #{CustomValue.table_name}" +
                   " WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +
-                  "  AND value <> '' AND CAST(value AS integer) IN (" +
+                  "  AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +
                   "  SELECT customized_id FROM #{CustomValue.table_name}" +
                   "  WHERE customized_type='#{target_class}' AND custom_field_id=#{chained_custom_field_id}" +
                   "  AND #{sql_for_field(field, operator, value, CustomValue.table_name, 'value')}))"
                 "#{queried_table_name}.id #{not_in} IN (" +
                   "SELECT customized_id FROM #{CustomValue.table_name}" +
                   " WHERE customized_type='#{queried_class}' AND custom_field_id=#{custom_field_id}" +
-                  "  AND value <> '' AND CAST(value AS integer) IN (" +
+                  "  AND CAST(CASE value WHEN '' THEN '0' ELSE value END AS decimal(30,0)) IN (" +
                   "  SELECT id FROM #{target_table_name} WHERE #{sql_for_field(field, operator, value, filter[:field].format.target_class.table_name, attribute)}))"
               end