The functionality of Freehand SQL is built into Smart Reporting. Depends on what version you are running. In the newer version they have it hidden and you have to turn it on.
Read this article.
Thank you very much for your answer T.D. (and also thank you, Laurent, for moving my question to the correct place).
I knew the article you told me about, but it doesn’t resolve my issue. What I am trying to do is to create a view using freehand SQL, not a calcultated field for an existing view.
Anyway, thanks for your time.
2 of 2 people found this helpful
Below snippets explains it all on what you have requested for, i.e. we can have custom SQL at a VIEW level by using the Virtual Table option.
HOWEVER, since SmartReporting doesn't allow native SQL commands or functions, the usage of this option is very very limited.
For instance I have tried a simple CASE statement which wasn't working considering that SmartReporting is looking for a reference of FORM in the Remedy and not the TABLE in the Database.
Thank you very much, Ravi,that's what I was looking for.
I tried it yesterday and it seemed it was going to work. I had some problems whith the exact tables, but that's another story.