View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006325 | mantisbt | filters | public | 2005-10-07 11:33 | 2019-09-26 09:12 |
Reporter | MTW | Assigned To | |||
Priority | normal | Severity | feature | Reproducibility | always |
Status | new | Resolution | open | ||
Product Version | 1.0.0rc2 | ||||
Summary | 0006325: Added DATETIME data type, added Simple Text Search on custom fields | ||||
Description | Hi all, If anyone is interested, I have added the DATETIME data type and the Simple Text Search on custom fields. It works great for me, but I'm a little noob of php so if you think that something is wrong.. let me know how to fix If you like it... use it! Byez | ||||
Additional Information | The DATETIME uses the $g_normal_date_format instead of $g_short_date_format both in input and in output (print) The Simple Text Search works on date/datetime fields as well, but for now I had to hardcode some MySQL specific SQL statement.. any idea to make it installation-independent is appreciated. :) | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
related to | 0007183 | acknowledged | new search function on field and custom field |
Good!. It'seems to me that a litte part missing, the changes to: to something like: '0:string,1:numeric,2:float,3:enum,4:email,5:checkbox,6:list,7:multiselection list,8:date,9:datetime'; |
|
You are right, i forgot to include my custom files. :) In the meanwhile I have moved the define from constant_inc.php to custom_constant_inc.php 1) in your main mantis dir (not core) create a new file named custom_constant_inc.php and add following lines to it 2) in config_inc.php add the new type to enum string if english is not your main language, in your main mantis dir (not core) create a new file named custom_strings_inc.php and add to it following lines with your local translation (in the example italian) look here for further information Byez |
|
My filter_api.php modified to enable simple text search on custom fields |
|
To prevent an mysqlerror when you disable 'filter_by_custom_fields' ($g_filter_by_custom_fields = OFF;) MTW - 2005-09-29 - Search in Custom FieldsWe need this to close our custom search clause$t_textsearch_where_clause = $t_textsearch_where_clause . ")"; MTW - 2005-09-29 - Search in Custom FieldsWe need this to close our custom search clauseif ( ON == config_get( 'filter_by_custom_fields' ) ) { |
|
You are right Schroedi, thank you. |
|
Hi MTW, could You please upload your modified PHP files again. |
|
I am trying to apply this to version 1.1.4 .. Filters show sutom feilds in my version BUT search box will not return a result if I search for anything in the custom feilds. I believe this is the solution for my problem BUT I I am having problems knowing where to begin because filter_api.php was changed so much in ver 1.14 and also because this zip file lacks commenting noting only what was changed/added. 3 things:
Any help would be appreciated. I too am a noob to php but have some limited skill. Best, |
|
Ok - I figured this out.. I ported the custom feild search and special date/time changes made by MTW to version 1.1.4 filter_api.php... Also included the bug fix by SCHROEDI noted above. Special thanks to MTW for doing a hell of a job on this. The logic does not look that simple and it is impressive for a noob. I am posting 2 fields..
Hope this is usefull and ALSO urge developers of mantis to consider this for futre revisions. It s a little more overhead on the server but is not noticable. Load times are the same on my equipment. However, the functionality of being able to search custom feilds is a HUGE benefite to users of this system. |
|
Sorry guys - Mantis service is messing up right now.. I keep getting this error no matter what i try to attach. APPLICATION ERROR #503 I WILL TRY AGAIN TOMMAROW |
|
I have uploaded verrsion 1.1.4 with MTWs custom search mod. Enjoy |
|
Anyone have any idea about adding simple text search on Custom Fields for MantisBT 1.2.4 |
|
I have this functionality almost to work under 2.22. Only when i submit a new ticket and i leave the hours en minutes field '0' (default) the custom_field is not saved at all in de DB. The strange thing is, that this issue doesn't apply when i try to update/edit an existing ticket. Even when the field 'datetime' is empty in the first place, the functionality works perfectly. see also topic: https://mantisbt.org/forums/viewtopic.php?f=4&t=786 Any help is appreciated. Thx. |
|
datetime custom_field functionality ready in version 2.21.1 |
|