Display the Date an Event Changes to a Particular Event Status



  • Michael Patterson

    Could you do this for a range of events within a certain date range rather than just one specific event?

    e.g. if you wanted to see on what date each event in quarter 4 of 2015 was changed to a "confirmed" status.

  • Jo Dadd

    I know this is probably a very basic question - but can this be added to the system itself in order to show a column on the event master

    Allowing me to create a view to show value of bookings won with a set period of time





  • Sean Tame

    Hi Jo,
    It is not possible to add SQL generated columns to grids (although that would be awesome!)

    But I'm not sure why this article exists. There is a standard field called "Firm" that tracks the date an event moves from a status less than Firm (weighting = 30) to 30 or above (but less than 80 = cancelled).

    I'd suggest using this column.

  • Ricardo Guevara

    Hello Jo,
    Having the ability to add columns on our standard grids based on a SQL statement sounds like a great idea, but I am sure you can imagine the security and performance risks that this would introduce to the system, which is why we don't offer options like this. Our formula fields would be the closest you can get, buy since they depend on the fields that are already available in the grid, they will likely not solve your problem.
    The idea behind sharing this SQL statement is to provide a simple example so our customers can build an EZWriter or a Crystal report that you can make available on your Events window to complement the data you have available there.
    It is my understanding that our Software Engineering team is working on some enhancements to our Audit Log module. If I hear of something that could help you get the information you need on this window, I'll post it on this thread.
    Additionally, you are welcome to submit an enhancement suggestion (link is available on the main page of this Support Center site) so out Event Management team can get some visibility over what you and the rest of our customers need.

Please sign in to leave a comment.