Thanks for a nice tool. I wound up going through a few rounds of troubleshooting the search function, and in the end, the cause was that I created a custom field called "Where_Occurred", which interfered with how util.cs merges the permissions clause onto the select statement for the search.
Seeing that you've gone through iterations of handling that permission issue, rather than suggesting you rewrite that yet again, let me suggest the lateral thinking way, and say "Prevent someone from using the word "WHERE" in a custom field" instead.
I suppose while we're talking about reserved words, maybe the word "alter" as used in util.cs and the whole process technically should be a different word, just to avoid the stickiness that alter is a SQL reserved word too. Although yes, the sql is being "altered", it's not being altered via a SQL Alter, so maybe it would reduce confusion to just use a different word. (Modified? Doctored? Retrofitted? Appended to? I like "Appended") Thanks again.
Log in to post a comment.