filter and search fields added in support ticket: raised_by, subject
diff --git a/maintenance/doctype/support_ticket/support_ticket.txt b/maintenance/doctype/support_ticket/support_ticket.txt
index 2902feb..ebb4043 100644
--- a/maintenance/doctype/support_ticket/support_ticket.txt
+++ b/maintenance/doctype/support_ticket/support_ticket.txt
@@ -13,7 +13,7 @@
'client_script_core': None,
'client_string': None,
'colour': 'White:FFF',
- 'creation': '2011-05-23 09:01:10',
+ 'creation': '2011-05-23 14:50:46',
'description': None,
'docstatus': 0,
'doctype': 'DocType',
@@ -29,7 +29,7 @@
'istable': None,
'max_attachments': None,
'menu_index': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
'module': 'Maintenance',
'name': 'Support Ticket',
@@ -42,7 +42,7 @@
'print_outline': None,
'read_only': None,
'read_only_onload': None,
- 'search_fields': 'status,customer,allocated_to',
+ 'search_fields': 'status,customer,allocated_to,subject,raised_by',
'section_style': 'Tray',
'server_code': None,
'server_code_compiled': None,
@@ -53,21 +53,21 @@
'subject': '%(subject)s',
'tag_fields': 'status',
'use_template': None,
- 'version': 136
+ 'version': 138
},
{
'amend': 0,
'cancel': 0,
'create': 1,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'docstatus': 0,
'doctype': 'DocPerm',
'execute': None,
'idx': 1,
'match': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'PERM00818',
+ 'name': 'PERM00838',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'permissions',
@@ -82,15 +82,15 @@
'amend': None,
'cancel': None,
'create': 1,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'docstatus': 0,
'doctype': 'DocPerm',
'execute': None,
'idx': 2,
'match': 'customer',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'PERM00819',
+ 'name': 'PERM00839',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'permissions',
@@ -105,15 +105,15 @@
'amend': None,
'cancel': 1,
'create': 1,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'docstatus': 0,
'doctype': 'DocPerm',
'execute': None,
'idx': 3,
'match': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'PERM00820',
+ 'name': 'PERM00840',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'permissions',
@@ -128,15 +128,15 @@
'amend': None,
'cancel': 0,
'create': 0,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'docstatus': 0,
'doctype': 'DocPerm',
'execute': None,
'idx': 4,
'match': 'allocated_to',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'PERM00821',
+ 'name': 'PERM00841',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'permissions',
@@ -151,15 +151,15 @@
'amend': None,
'cancel': None,
'create': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'docstatus': 0,
'doctype': 'DocPerm',
'execute': None,
'idx': 5,
'match': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'PERM00822',
+ 'name': 'PERM00842',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'permissions',
@@ -173,7 +173,7 @@
{
'allow_on_submit': None,
'colour': 'White:FFF',
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': 'Open',
'depends_on': None,
'description': None,
@@ -186,9 +186,9 @@
'idx': 1,
'in_filter': 0,
'label': 'Status',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04772',
+ 'name': 'FL05022',
'no_column': None,
'no_copy': 1,
'oldfieldname': 'status',
@@ -209,7 +209,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': None,
'description': None,
@@ -220,11 +220,11 @@
'hidden': None,
'icon': None,
'idx': 2,
- 'in_filter': None,
+ 'in_filter': 1,
'label': 'Subject',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04773',
+ 'name': 'FL05023',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -245,7 +245,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:doc.__islocal',
'description': None,
@@ -256,11 +256,11 @@
'hidden': None,
'icon': None,
'idx': 3,
- 'in_filter': None,
+ 'in_filter': 1,
'label': 'Raised By (Email)',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04774',
+ 'name': 'FL05024',
'no_column': None,
'no_copy': None,
'oldfieldname': 'raised_by',
@@ -281,7 +281,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:doc.__islocal',
'description': None,
@@ -294,9 +294,9 @@
'idx': 4,
'in_filter': None,
'label': 'Description',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04775',
+ 'name': 'FL05025',
'no_column': None,
'no_copy': None,
'oldfieldname': 'problem_description',
@@ -317,7 +317,43 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-28 10:12:57',
+ 'default': None,
+ 'depends_on': None,
+ 'description': None,
+ 'docstatus': 0,
+ 'doctype': 'DocField',
+ 'fieldname': 'problem_description',
+ 'fieldtype': 'Text',
+ 'hidden': None,
+ 'icon': None,
+ 'idx': 5,
+ 'in_filter': None,
+ 'label': 'Problem Description',
+ 'modified': '2011-06-20 13:46:30',
+ 'modified_by': 'Administrator',
+ 'name': 'FL05475',
+ 'no_column': None,
+ 'no_copy': None,
+ 'oldfieldname': 'problem_description',
+ 'oldfieldtype': 'Text',
+ 'options': None,
+ 'owner': 'Administrator',
+ 'parent': 'Support Ticket',
+ 'parentfield': 'fields',
+ 'parenttype': 'DocType',
+ 'permlevel': 0,
+ 'print_hide': None,
+ 'report_hide': None,
+ 'reqd': None,
+ 'search_index': None,
+ 'trigger': None,
+ 'width': None
+ },
+ {
+ 'allow_on_submit': None,
+ 'colour': None,
+ 'creation': '2011-05-28 10:26:08',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -327,12 +363,12 @@
'fieldtype': 'HTML',
'hidden': None,
'icon': None,
- 'idx': 5,
+ 'idx': 6,
'in_filter': None,
'label': 'Thread HTML',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04778',
+ 'name': 'FL05530',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -353,7 +389,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -363,12 +399,12 @@
'fieldtype': 'Text',
'hidden': None,
'icon': None,
- 'idx': 6,
+ 'idx': 7,
'in_filter': None,
'label': 'New Response',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04776',
+ 'name': 'FL05027',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -389,7 +425,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -399,17 +435,17 @@
'fieldtype': 'Button',
'hidden': None,
'icon': None,
- 'idx': 7,
+ 'idx': 8,
'in_filter': None,
'label': 'Send',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04777',
+ 'name': 'FL05028',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
'oldfieldtype': None,
- 'options': None,
+ 'options': 'send_response',
'owner': 'Administrator',
'parent': 'Support Ticket',
'parentfield': 'fields',
@@ -425,7 +461,7 @@
{
'allow_on_submit': None,
'colour': 'White:FFF',
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-28 10:26:09',
'default': None,
'depends_on': None,
'description': None,
@@ -435,12 +471,12 @@
'fieldtype': 'Section Break',
'hidden': None,
'icon': None,
- 'idx': 8,
+ 'idx': 9,
'in_filter': None,
'label': 'Additional Info',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04779',
+ 'name': 'FL05531',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -461,7 +497,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-28 10:26:09',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -471,12 +507,12 @@
'fieldtype': 'Column Break',
'hidden': None,
'icon': None,
- 'idx': 9,
+ 'idx': 10,
'in_filter': None,
'label': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04780',
+ 'name': 'FL05532',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -497,7 +533,7 @@
{
'allow_on_submit': None,
'colour': 'White:FFF',
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': None,
'description': None,
@@ -507,12 +543,12 @@
'fieldtype': 'Link',
'hidden': None,
'icon': None,
- 'idx': 10,
+ 'idx': 11,
'in_filter': 1,
'label': 'Customer',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04781',
+ 'name': 'FL05031',
'no_column': None,
'no_copy': None,
'oldfieldname': 'customer',
@@ -533,7 +569,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': None,
'description': None,
@@ -543,12 +579,12 @@
'fieldtype': 'Data',
'hidden': None,
'icon': None,
- 'idx': 11,
+ 'idx': 12,
'in_filter': 1,
'label': 'Customer Name',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04782',
+ 'name': 'FL05032',
'no_column': None,
'no_copy': None,
'oldfieldname': 'customer_name',
@@ -569,7 +605,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': None,
'description': None,
@@ -579,12 +615,12 @@
'fieldtype': 'Data',
'hidden': None,
'icon': None,
- 'idx': 12,
+ 'idx': 13,
'in_filter': None,
'label': 'Contact No',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04783',
+ 'name': 'FL05033',
'no_column': None,
'no_copy': None,
'oldfieldname': 'contact_no',
@@ -605,7 +641,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': 'Today',
'depends_on': None,
'description': None,
@@ -615,12 +651,12 @@
'fieldtype': 'Date',
'hidden': None,
'icon': None,
- 'idx': 13,
+ 'idx': 14,
'in_filter': None,
'label': 'Opening Date',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04784',
+ 'name': 'FL05034',
'no_column': None,
'no_copy': 1,
'oldfieldname': 'opening_date',
@@ -641,7 +677,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': None,
'description': None,
@@ -651,12 +687,12 @@
'fieldtype': 'Time',
'hidden': None,
'icon': None,
- 'idx': 14,
+ 'idx': 15,
'in_filter': None,
'label': 'Opening Time',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04785',
+ 'name': 'FL05035',
'no_column': None,
'no_copy': 1,
'oldfieldname': 'opening_time',
@@ -677,7 +713,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-28 10:26:09',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -687,12 +723,12 @@
'fieldtype': 'Column Break',
'hidden': None,
'icon': None,
- 'idx': 15,
+ 'idx': 16,
'in_filter': None,
'label': None,
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04786',
+ 'name': 'FL05533',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
@@ -713,7 +749,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -723,12 +759,12 @@
'fieldtype': 'Link',
'hidden': None,
'icon': None,
- 'idx': 16,
+ 'idx': 17,
'in_filter': 1,
'label': 'Allocated To',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04787',
+ 'name': 'FL05037',
'no_column': None,
'no_copy': None,
'oldfieldname': 'allocated_to',
@@ -749,7 +785,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -759,12 +795,12 @@
'fieldtype': 'Text',
'hidden': None,
'icon': None,
- 'idx': 17,
+ 'idx': 18,
'in_filter': None,
'label': 'Resolution Details',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04788',
+ 'name': 'FL05038',
'no_column': None,
'no_copy': 1,
'oldfieldname': 'resolution_details',
@@ -785,7 +821,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -795,12 +831,12 @@
'fieldtype': 'Date',
'hidden': None,
'icon': None,
- 'idx': 18,
+ 'idx': 19,
'in_filter': 0,
'label': 'Resolution Date',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04789',
+ 'name': 'FL05039',
'no_column': None,
'no_copy': 1,
'oldfieldname': 'resolution_date',
@@ -821,7 +857,7 @@
{
'allow_on_submit': None,
'colour': None,
- 'creation': '2011-05-23 09:01:11',
+ 'creation': '2011-05-23 14:50:46',
'default': None,
'depends_on': 'eval:!doc.__islocal',
'description': None,
@@ -831,12 +867,12 @@
'fieldtype': 'Time',
'hidden': None,
'icon': None,
- 'idx': 19,
+ 'idx': 20,
'in_filter': None,
'label': 'Resolution Time',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04790',
+ 'name': 'FL05040',
'no_column': None,
'no_copy': None,
'oldfieldname': 'resolution_time',
@@ -857,7 +893,7 @@
{
'allow_on_submit': None,
'colour': 'White:FFF',
- 'creation': '2011-05-24 10:16:53',
+ 'creation': '2011-05-28 10:12:58',
'default': None,
'depends_on': None,
'description': None,
@@ -867,12 +903,12 @@
'fieldtype': 'Data',
'hidden': 1,
'icon': None,
- 'idx': 20,
+ 'idx': 21,
'in_filter': None,
'label': 'Content Type',
- 'modified': '2011-05-28 09:22:11',
+ 'modified': '2011-06-20 13:46:30',
'modified_by': 'Administrator',
- 'name': 'FL04791',
+ 'name': 'FL05478',
'no_column': None,
'no_copy': None,
'oldfieldname': None,
diff --git a/patches/patch.py b/patches/patch.py
index 05042a9..7a243ec 100644
--- a/patches/patch.py
+++ b/patches/patch.py
@@ -1,6 +1,6 @@
# REMEMBER to update this
# ========================
-last_patch = 283
+last_patch = 284
#-------------------------------------------
@@ -1139,3 +1139,6 @@
rec = sql("select voucher_type, voucher_no, ifnull(is_cancelled, 'No') from `tabGL Entry` where modified >= '2011-06-15 01:00:00' order by name ASC")
for d in rec:
sql("update `tab%s` set docstatus = %s where name = '%s'" % (d[0], d[2]=='No' and 1 or 2, d[1]))
+ elif patch_no == 284:
+ reload_doc('maintenance', 'doctype', 'support_ticket')
+ sql("update `tabDocField` set in_filter = 1 where fieldname in ('raised_by', 'subject') and parent = 'Support Ticket'")