Filtering issues with custom field (in date format)
I configured a new Issue Custom Field (with Date format) and I need to filter issues by this field where its value is overdue (less than today). I applied the filter type "more than days ago" with value "1 days" to this field and the query returned the overdue issues and issues with NULL value. I need only the first one, without the null values.
Applying the same filter to a native date field (like due date) the result is exactly the expected (only the overdue issues were listed, without null values).
Is there any difference between native and custom fields?
- Ruby implementation and version: Redmine 1.3.0.stable.6106
- Rails version: Rails 2.3.14
- Operating system: CentOS release 5.6
- Database used, and its version: MySQL 5.0.77
- Ruby-aware server used: Webrick
RE: Filtering issues with custom field (in date format) - Added by Alexander Molchanov over 5 years ago
I have the same situation.
Redmine version: 2.3.0.stable.11692
About your application's environment
Ruby version 1.9.3 (x86_64-linux)
RubyGems version 1.8.24
Rack version 1.4
Rails version 3.2.13
Active Record version 3.2.13
Action Pack version 3.2.13
Active Resource version 3.2.13
Action Mailer version 3.2.13
Active Support version 3.2.13
Middleware Rack::Cache, ActionDispatch::Static, Rack::Lock, #<ActiveSupport::Cache::Strategy::LocalCache::Middleware:0x00000002557a10>, Rack::Runtime, Rack::MethodOverride, ActionDispatch::RequestId, Rails::Rack::Logger, ActionDispatch::ShowExceptions, ActionDispatch::DebugExceptions, ActionDispatch::RemoteIp, ActionDispatch::Callbacks, ActiveRecord::ConnectionAdapters::ConnectionManagement, ActiveRecord::QueryCache, ActionDispatch::Cookies, ActionDispatch::Session::CookieStore, ActionDispatch::Flash, ActionDispatch::ParamsParser, ActionDispatch::Head, Rack::ConditionalGet, Rack::ETag, ActionDispatch::BestStandardsSupport, OpenIdAuthentication
Application root /usr/local/src/redmine
Database adapter postgresql
Database schema version 20130217094251