Oops.. I deleted documents from ProLaw
We've all done it at some point. Accidently deleted documents from ProLaw, only to discover there is no undo button! Not fun. Luckily...


ProLaw Server Designs from Small to Large Business
More mad scientist drawings and videos! I've had a few smaller clients running monolithic server designs, and I wanted to give some...


XML Path Function Delimiters for ProLaw Data in Cascades
One of my favorite methods of extracting cascade information from ProLaw is using the XML PATH() function in SQL. The XML Path function...

Who is marking dockets complete?
If you have events audit trail turned on you can use the SQL code below to create reporting metrics (last 30 days) on who, and how many,...


SQL Code for finding professionals assigned to default docket types
If you've ever tried to deactivate a prolaw professional and can't, check out the bottom left corner of the screen and see if you're...


May 2018 Rules Set Docket Check
SQL code to search for active dockets affected by rules update