View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0020222 | MMW 5 | DB / Backup | public | 2023-09-07 15:46 | 2023-09-29 07:58 |
| Reporter | Ludek | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | reopened | ||
| Product Version | 5.1 | ||||
| Target Version | 5.1 | Fixed in Version | 5.1 | ||
| Summary | 0020222: Numeric operators for custom fields doesn't work correctly for date values | ||||
| Description | Numeric operators for custom fields have been added in 2814 ( 0018111 ) This works fine for integers, but not for date like '2023/05/12' = 2023/05/12 ==> True <= 2023/05/12 ==> False ... unexpected >= 2023/05/12 ==> True > 2023/05/11 ==> True < 2023/05/11 ==> False > 2023/05/13 ==> True ... unexpected < 2023/05/13 ==> False ... unexpected | ||||
| Additional Information | https://www.mediamonkey.com/forum/viewtopic.php?p=512797#p512797 | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 2817 | ||||
|
|
I see, this is because of the SQL constructed as SELECT Songs.* FROM Songs WHERE CAST(Songs.Custom1 AS INT)>2023/05/12 AND (Songs.Custom1 <> '' ) where '/' is actually a division operator. |
|
|
Fixed in 2815 |
|
|
Verified on 2815. 1) < and <= include all non-value files. I'm not sure this is desirable or not. (can be solved by using a second Criteria setting field to Is Known. 2) Second issue raised on forum was not fixed. Changing between operators like <, >= AND contains, equals removes user value on 2815. User should be left as set previously. |
|
|
1/2) fixed in 2817 |
|
|
Verified 2817 |
