• Communications notes and emails

    In the communications table we have comm_note and comm_email. If the comm type is email, the details go into comm_email otherwise it goes into comm_note. All well and good. A customer of mine has a good reason to want to see the notes in a list. The communication…
  • Query performance on system views

    Hello, I am noticing that performance around system views, predominantly the views surrounding communications, are performing badly in comparison to the rest of the system. If we take vListCommunication as an example, it has the following syntax in…
  • [Today] Command in Views?

    Is there are command to call Today's date while creating or editing a View in Customization?