Comments in Filters?

[mrgunston]

I want to get our Vicidial Admins to start using comments in filters to explain what the filter is for.

Can I simply use the standard MySQL comment syntax to achieve this?

E.g.

Code: Select all

 /* comment goes here */

ViciBox: 8.1.2 | VERSION: 2.14b0.5 | SVN: 3063 | Clusters: 1 DB / 4 Web/Asterisk Build: ??

[williamconley]

1) you left out the BUILD of the version for Vicidial. Please include it. You were So Close. lol.

2) NO. This is a sql statement. Inline comments are not a "thing" in mysql. That's only viable for a .sql file being loaded (which this is not).

3) There's already a FIELD for comments. Perhaps you could suggest they put the comment in the comment field?

4) If the query is so long that you need multiple comments, I strongly suggest you find a different way to do whatever you are doing.

5) OR you can put a URL in the comments field, and get yourself a nice wiki system where the admins can put a fully documented copy of the entire sql statement with notes. This also could double as a backup and versioning system for your sql statements.