Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Service Default Duration RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have to create Services with Default Duration of 5 days, CRM 2011 has a 3 days limit for it, but if I edit the register in ServiceBase sql table and change Duration from 4320 (3 days in minutes) to 7200 (5 days in minutes) I can use the Service  and everything else seems to work fine. I understand that this not a supported solution but I'm wondering if this workaround is too much wrong or I can take the risk.

    Any advices here?

    Thursday, March 22, 2012 8:31 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    No need for unsupported changes here, simply type the word '5 Days' into the default duration field and save it. The items in all duration fields are merely defaults to assist with rapid entry. You can type in x minutes, x hours, or x days and even enter upto 16 decimal places for the hour and day if you wish.

    Rob

    Microsoft Certified Technology Specialist (CRM) GAP Consulting Ltd Microsoft Community Contributor Award 2011

    Thursday, March 22, 2012 10:57 PM
    Answerer

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi

      I think  if it does the job then it okay .

      But one thing you can do is instead of SQL Script to update the Table do it  via FilteredView

      As the FilteredView are updatable rather than directly updating the Base Table

     Make sure the user login as enough permission to execute the Filteredview

    Also make sure that you test it thoroughly

     hth

    dkay

    if the response answered your question, please take a minute and mark the response as an answer.

    • Marked as answer by jimenezalbert0 Thursday, March 22, 2012 11:12 PM
    • Unmarked as answer by jimenezalbert0 Thursday, March 22, 2012 11:12 PM
    Thursday, March 22, 2012 9:15 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi,

    No need for unsupported changes here, simply type the word '5 Days' into the default duration field and save it. The items in all duration fields are merely defaults to assist with rapid entry. You can type in x minutes, x hours, or x days and even enter upto 16 decimal places for the hour and day if you wish.

    Rob

    Microsoft Certified Technology Specialist (CRM) GAP Consulting Ltd Microsoft Community Contributor Award 2011

    Thursday, March 22, 2012 10:57 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Ok Rob,

    Occam's razor, isn't it? Thank you for your clarification.

    Thursday, March 22, 2012 11:12 PM