Results 1 to 2 of 2

Thread: Adding a note, task, et cetera to change Modified date

  1. #1
    avadtechnologies is offline Sugar Community Member
    Join Date
    Sep 2007
    Posts
    28

    Default Adding a note, task, et cetera to change Modified date

    Is there any way to have the modified date update in a case when you add a note or task or anything else to the case? It only seems to change if you edit the case and then save it.

    Maybe I am going about it the wrong way so here is what we are trying to accomplish.

    We have multiple trouble ticket / cases open for various networking or other problems. We want to be able to sort by the issue / case that has not had any "attention" recently. Kind of like a que system that brings up an issue / case to the front if it has not had work for the longest period of time.

    Currently whenever we do something regarding the issue / case we add a note of what we did, and then manually click edit / save on the main case to change the modified date.

  2. #2
    roblaus's Avatar
    roblaus is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Vienna / Austria
    Posts
    2,850

    Default Re: Adding a note, task, et cetera to change Modified date

    This sounds like a fairly easy code modification. Although I wouldn't touch the original 'modified at' field. Create a new one - like 'last action' and fill this one whenever a related entry is changed.
    Since I am not a programmer I do not know how to do this in php but I know (at least for MSSQL) that this would be a very simple database trigger.
    With Pro you might be able to set up a workflow but I need to check this first. In CE there is no out of the box solution.

    rgds
    rl
    __________________________
    Robert Laussegger
    http://www.iscongroup.net

    Bei Fragen: support@iscon.at
    Die deutschen Sprachdateien für SugarCRM und das deutsche Handbuch gibt es hier: http://goo.gl/kPsAz
    Ab sofort auch mit 6.4.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 18
    Last Post: 2008-04-15, 01:18 PM
  2. History Note Date Modified Different than Emails
    By browndogforever in forum Help
    Replies: 2
    Last Post: 2007-05-17, 12:04 PM
  3. error message when adding note or task
    By aprice88 in forum Help
    Replies: 0
    Last Post: 2007-03-15, 11:36 PM
  4. Replies: 2
    Last Post: 2006-12-08, 04:19 AM
  5. Replies: 1
    Last Post: 2006-09-11, 03:38 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •