https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38110 Bug ID: 38110 Summary: Staff interface tables with filters - date format needs to be YYYY-MM-DD, need to use authorized value codes Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Staff interface Assignee: koha-bugs@lists.koha-community.org Reporter: david@davidnind.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com When using filters on tables in the staff interface (for both "Search: ______ x Clear filter" and with "Show filters"): 1. Date fields: you need to enter the date in YYYY-MM-DD format, not the way it is displayed in the table 2. Fields using authorized values: you need to enter the code, rather than the description To replicate: 1. Go to a record in the staff interface with multiple items (for example record 146, The definitive guide to Catalyst : writing extensible, scalable, and maintainable Perl-based Web applications <staffinterfaceurl>/cgi-bin/koha/catalogue/detail.pl?biblionumber=146). 2. In the holdings table section, click "Show filters". 3. Using the "Search: ______ x Clear filter": 3.1 Enter "Midway" ==> no results 3.2 Enter "MPL" ==> one result 3.3 Enter "09/04" ==> no results 3.4 Enter "2014-09" ==> results Note: Bug 38071 fixes the "Clear filter" that is not working, in the meantime click "Hide filters" and "Show filters" or clear the text in the search box to clear. 4. Using the table column filters: 4.1 Click "Show filters" 4.2 In the "Last seen" column, start typing 09/04 ==> no results 4.2 In the "Last seen" column, start typing 2014-09 ==> no change as it matches data in the column, if you type 2014-09-01 you should get no results 4.3 In the "Collection" column, start typing "Reference" > no change until you get to "Refe", then you get no results as it is looking for the authorized value code 4.4 Note that the Item type, Current library, and Home library columns all use select lists, so you can't type a value in them. 5. Go to Patrons and click the "Search" button. 6. Perform searches similar to steps 3 and 4, and you will get similar results (use the "Date of birth" column for dates and "Library" or "Category" columns for authorized values). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.