SuperOffice CRM Professionals

No, there isn't an dedicated api/archive provider for the mergemovelog table, so this should be done with a dynamic query like you mentioned.

Hi, I don't know if this is of any use to anyone, but I have created two functions for this base on Sverre's code above, one for an Integer number, and one for a Float. #setLanguageLevel 4; String FormatIntegerWithThousandSeparator(Integer inputNumber, String thousandSeperator) { //Convert The Number Into A String String strInputNumber = inputNumber.toString(); //Loop Back In Blocks Of Three, And Add Thousand Seperators Integer len = strInputNumber.getLength() - 3; while (len > 0) { strInputNumber = strInputNumber.subString(0, len) + thousandSeperator + strInputNumber.subString(len, strInputNumber.getLength() - len); len -= 3; } //Return Formatted Number Return strInputNumber; } String FormatFloatWithThousandSeparator(Float inputNumber, String thousandSeperator, Integer noOfDecimalPlaces) { //Split The Number Into A Whole Number And It's Decimals Integer inputNumberWholeNumber = inputNumber.floor(); Float remainingValue = inputNumber - inputNumberWholeNumber; String strRemainingValue = remainingValue.toString(noOfDecimalPlaces); //Format The Whole Number Into The Thousand Seperators And Add Back The Decimals Return FormatIntegerWithThousandSeparator(inputNumberWholeNumber, thousandSeperator) + strRemainingValue.subString(1, strRemainingValue.getLength()); } //Test Functions print(FormatIntegerWithThousandSeparator(123456789, ",") + ' '); print(FormatFloatWithThousandSeparator(123456789.99, ",", 2) + ' '); print(FormatIntegerWithThousandSeparator(325233585, ",") + ' '); print(FormatFloatWithThousandSeparator(325233585.22, ",", 2) + ' '); print(FormatFloatWithThousandSeparator(325233585.00, ",", 2) + ' '); Trevor

Perfect, glad my input helped you to resolve the issue.

Hi Sverre, Thank you for your reply, hope you are well. So if I set the request to a status that has a "Track Time As" to "None" or "Externally", would that mean that the Escalation Levels would be paused, because I only want to escalate the request if the once the time spent internally reaches the time specified in the escalation event. Also does time spent "In Queue" affect the escalation levels. Many thanks, Trevor

New day, new Web tools service dependency that is not available...