Resus
Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору По поводу удаления-редактирования групп - нашел решение, может кому поможет: If you remove(delete) the Group or rename the Group the history on the Requests will be lost. If you want to remove the Group, First,you may create a custom view with criteria like -- Site is "Sitename" and Group is "Groupname " -- and this custom view will give you all the Requests under the respective Group and you may do a bulk edit to change the Group. Second, you may need to look under Home\Show all(Tasks) and check if the same Group is assigned to any one of the Tasks,if so you may change it by editing one by one. Once you change it in Requests and Tasks,you should be able to delete the Group.Renaming the Groups,like you observed will change it everywhere and no history will be kept. + вариант через изменения в базе: The Groups in different Sites are completely different but there are chances that you may have Requests and Tasks which is associated to these Groups and if that is the case,you may need to disassociate them from those Requests and Tasks or else find another Group (queueid) to assign these to. Its easy to do this from the database and you may connect to the respective database(MYSQL or MSSQL). You may mouseover the Group that you want to delete and find the queueid from the status bar and replace the same in the below query: To disassociate from Requests: delete from workorder_queue where queueid=queueidtobedeleted; OR To replace with another group from the Requests: update workorder_queue set queueid=newqueueid where queueid=queueidtobedeleted; where newqueueid is the queueid for the group to which you are moving those Requests. queueidtobedeleted is the queueid for the Group that you want to delete. For Tasks,you may either choose to disassociate this Group from the Tasks or replace it with another one: To disassociate from Tasks: update taskdetails set groupid=null where groupid=groupid; where groupid is the id of the group you want to delete. OR To replace with another group: update taskdetails set groupid=newgroupid where groupid=oldgroupid; where newgroupid is the queueid for the group to which you are moving those Requests. oldgroupid is the queueid for the Group that you want to delete. | Всего записей: 269 | Зарегистр. 03-07-2005 | Отправлено: 14:24 16-05-2011 | Исправлено: Resus, 14:26 16-05-2011 |
|