Reports - Custom Column Expressions
Purpose: An advanced feature that allows entering SQL expressions into a report column to display the results of calculations, date subtractions and additions, and much more. You cannot update data with this feature. Look to our APIs if you need to add or update data.
Cost: None.
Enabling: LegalServer staff must enable this feature, which will then expose a "Report SQL Formula Editing" user role permission that administrators can give to the desired user roles.
Tips on Use: Reports - Writing Custom Column Expressions
Requesting the Feature
File a ticket from your site, and copy and paste the following required text into it:
We solemnly acknowledge:
- This is an advanced feature. There is no hand holding, no friendly messages, no guide to writing SQL.
- You do not have an ERD, handy "field guide", etc., and we will not ask for one.
- LegalServer staff may offer to help with an expression, or may refuse, or tell us there will be a charge to help with an expression.
- If an expression breaks a report, that is on us.
- If an expression produces an incorrect result because our logic is wrong, that's on us.
- If an expression causes a report to be horribly slow, that's on us.
Optionally include in your ticket how you say "SQL". We probably won't refuse to enable it if you get it wrong.
(Ref: LS-135402)