SQL Commands? Other than the basic ones listed...
I am by no means trained in SQL and have only picked up my knowledge my viewing and editing the SQL within Envision. Do you have a list of further commands other than the basic snap in ones. Some of the other pre-build scripts are very complicated and I would like to gain further knowledge of these to apply to my work. Could you provide any documentation - links - guides or anything that would help? Thanks
Hi, I've attached an htm file that I believe I got from this site a couple of years ago. It has all the SQL functions that are available to use through Event Explorer. The ones I use most are LOCATE, SUBSTR, LENGTH, CASE, LTRIM, RTRIM, WEEK(date), MONTH(date). Just search for "Built-in Functions and Stored Procedures" in the attached .htm file. These functions really help you make some interesting Event Explorer reports for clients. Regards, Dusan Tomic