OP Software BugTracker
Main | My View | View Issues | Change Log | Roadmap
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000077 [OP SmartDesk] Admin Area feature N/A 2010-03-25 11:40 2010-04-06 08:36
Reporter ozanpakyuz View Status public  
Assigned To ozanpakyuz
Priority normal Resolution fixed  
Status resolved   Product Version 2.0.3732
Summary 0000077: Custom fields
Description Ability to have custom fields on a per queue basis would be good.
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000050)
ozanpakyuz (administrator)
2010-03-25 11:54

 Looking at creating 3 new tables for this:

tblCustom_field
ID (INT)
NAME (VARCHAR(255))
DEFAULT_NAME (VARCHAR(255))
LENGTH_MIN (INT)
LENGTH_MAX (INT)
VALIDATION (INT)

This table will hold the custom fields definition

tblCustom_Field_String
FIELD_ID (INT)
SRID (INT)
VALUE (VARCHAR(255))

This table will hold the values entered for a given field and link that field to and incident for display later

tblCustom_Field_Queue
FILED_ID (INT)
QUEUE_ID (INT)
ORDER (INT)

This table wil link the field to the queue in order to dynamically display the fields based on the queue selection and in which order to display the fields.
(0000051)
ozanpakyuz (administrator)
2010-03-25 11:54

 Validation rules would be:

Email
Number
Text
URL
Anything
NONE
(0000052)
plexer (reporter)
2010-03-25 12:21

 Would it be possible to expand it to things like having a check box as well as just text input?

so if I was asking for them to fill out a form for a new user it would be:

Firstname: [TEXT BOX]
Surname: [TEXT BOX]
Teaching Staff: [CHECK BOX]
Support Staff: [CHECK BOX]
Supply Staff: [CHECK BOX]
Student: [CHECK BOX]
Year 7: [CHECK BOX]
Year 8: [CHECK BOX]
Year 9: [CHECK BOX]
Year 10: [CHECK BOX]
Year 11:

Only one of teaching, support, supply or student could be selected and only one of the years could be selected but only if student is checked.

This is probably a bit extreme or maybe some form of custom template just for this?
(0000101)
ozanpakyuz (administrator)
2010-04-06 08:36

 Unlimited Custom fields per queue is now available with fields being able to be used across a number of queues.

Full validation has also been added with the following choices:

Is the fields a required one i.e. something MUST be in this field

Is the fields one of the following:
Anything - Can have anything in this field upto 255 chars
Email - Must be a valid email address, rules will validate this
Number - must be a number, rules will validate this
IP Address - Must be a valid IP, rules will validate this
Text Only - Must only contain text and no numbers or special chars, rules will vaildate this
URL - Must be a valid web address of the following: http https ftp ftps, rules will validate this.

- Issue History
Date Modified Username Field Change
2010-03-25 11:40 ozanpakyuz New Issue
2010-03-25 11:54 ozanpakyuz Note Added: 0000050
2010-03-25 11:54 ozanpakyuz Assigned To => ozanpakyuz
2010-03-25 11:54 ozanpakyuz Status new => acknowledged
2010-03-25 11:54 ozanpakyuz Note Added: 0000051
2010-03-25 12:21 plexer Note Added: 0000052
2010-04-06 08:36 ozanpakyuz Note Added: 0000101
2010-04-06 08:36 ozanpakyuz Status acknowledged => resolved
2010-04-06 08:36 ozanpakyuz Resolution open => fixed
2010-04-06 08:36 ozanpakyuz Projection none => minor fix
2010-04-06 08:36 ozanpakyuz ETA none => 2-3 days
2010-04-06 08:36 ozanpakyuz Fixed in Version => 2.0.3775
2010-04-06 08:36 ozanpakyuz Target Version => 2.0.3775

Main | My View | View Issues | Change Log | Roadmap
  

Copyright © 2006 - 2009 OP Software
Powered by Mantis Bugtracker