Friday, June 7, 2019

Add a Comment in the Formula of a Saved Search

In a saved search comments can be added to increase the readability of a formula. A user can include a comment to a formula explaining its function. Comments are like notes, suggestions, warnings, etc. and are not executed.

To add a comment to a formula the characters /* */ are used.  Anything inside the characters /* */ will be a comment while anything before and after it will be executed.

An example is adding the use of the SQL expression SYSDATE in a saved time search. A user would like to add the comment explaining the function of the SQL expression SYSDATE which is "Returns the current date and time set".

Below are the steps to add both the SQL expression SYSDATE and also the comment:

1. Navigate to Lists > Search > Saved Searches > New.
2. Select Time as the Search Type.
3. Navigate the Results > Columns subtab.
4. Add the Field Formula (Date/Time).
5. In the Formula column add the formula SYSDATE/*Returns the current date and time set*/.
6. Click Preview.

Note: The saved time search will show a column for Formula (Date/Time) showing the system date and time without the comment.
 

12 comments:

  1. Thanks for providing this wonderful site; this is very useful to get backlinks. We provide training for all sort of IT couses through experienced trainers online, please visit our website to get more information on courses: https://itcources.com

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. It is extremely nice to see the greatest details presented in an easy and understanding manner.
    core services ui agent

    ReplyDelete
  4. This post is really valuable that designed for the new visitors. Pleasing work, keep on writing.
    UX design firms

    ReplyDelete
  5. Efficiently written information. It will be profitable to anybody who utilizes it, counting me. Keep up the good work. For certain I will review out more posts day in and day out. cfa level 1 study materials

    ReplyDelete
  6. Online destinations are another acceptable choice for individuals who are occupied with their occupation and still need to be familiar with cricket news.et20slam

    ReplyDelete
  7. Admiring the time and effort you put into your blog and detailed information you offer!.. สูตรไฮโล

    ReplyDelete
  8. This is certainly additionally an exceedingly wonderful offer everyone truly qualified on the lookout with. It's always not likely everyday there is chances read a little something. Tech

    ReplyDelete
  9.  backlink is a hyperlink from an external source which points right to your website or webpage. To greatly help me explain this further I possibly could add an url to Wikipedia using this article. If you were to click this link you would be directed to Wikipedia and away from my website. unique blog comments

    ReplyDelete