Award winning IT Support, Solutions and Systems Development
Recently I came across a problem where I had to parse JSON in SQL and retrieve data in a table format. Parsing Simple JSON in SQL Let us take the following JSON as an example: { “employeeCode”:”E1″, “emailAddress”:”nathan@none.com”, “firstName”:”nathan”, “lastName”:”poole”, “jobTitleName”:”Developer”, “userId”:”npoole” } In SQL you must declare JSON as NVARCHAR(MAX) and select using “OPENJSON”…
Power BI doesnt really have any version control, I recently overwrote a report with a version that was incorrect. After some research I realiased the only way would be to restore the SQL sever, but instead of restoring the whole database I realised that all the data was effectivly in 3 fields in the CatalogItemExtendedContent…
As part of working out SLA’s by using the working hours between two dates we struggled to find a working solution, one of our developers built a nice function that does just that; SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].udctGetWorkingMins(@from DATETIME, @to DATETIME,@daystartmins INT NULL,@dayendmins INT=NULL) RETURNS INT AS BEGIN…
Fusion has launched an online electronic signatures solution.
Our team are exhibiting in London at the SYNERGY 2020 Legal Europe, the Thomson Reuters users’ conference for legal professionals.
Fusion have some new product developments on the way! New Look Healthcheck Fusions 3E MatterSphere Healthcheck tool has been updated to give not just a sleek new look but further functionality to aid in risk and compliance across matters/cases. Healthcheck is an add-in module for MatterSphere that provides enhanced case management and tracking functionality to…
Elastic Search is a new feature incorporated into V8 onwards. It allows for a search of content of Clients, Contacts, Matters and Documents. It enables searching for text without specifying a specific field it must belong to and/or to look into the content of documents. It uses some simple Boolean terms and will return results…
A secure online portal for the residential property market has been developed as a result of a collaboration between an IT specialist, business technology expert Thomson Reuters Elite and the UK’s largest high street law firm.
What is a Link? A link is an auto generated address that when selected will take someone directly to the document the link is for, within the MatterSphere Document Management System. A link can be inserted into an email for others to access. How is this beneficial? Amends can be made by several people to…
How to get draft documents and correspondence authorised Remove the need to print, amend, retype and re-print by using 3E MatterSphere’s Send to Authorise function. What is Send to Authorise Send to authorise allows users to send automatic emails to the Fee Earner they work for containing a link to view documents and then to…
