locked
Filter Last Closed Activity RRS feed

  • Question

  • In my report I want to list the last closed or canceled activity. It's easy enough to list closed/canceled activities for the last x days/hours/etc but that might return no or many activities. What I want is just the last closed/canceled activity. How do I go after doing this?

     

    Thanks

    Tuesday, November 25, 2008 11:26 PM

Answers

  • There is no Advanced Find operator to filter out the last updated or closed record.

    Options:

    1. Maybe try View that sort by the date column of the entity in question and the first row would be the current value - you will still see a list of other row...

    2. Develop an SRS Report to provide this info

    3. SDK


    http://www.workopia.com/Links.htm
    • Marked as answer by Jim Glass Jr Thursday, April 2, 2009 8:38 PM
    Thursday, April 2, 2009 7:07 PM
    Moderator
  • Hi,

    You can do it like this (add as many columns you want to):

    select top 1 createdon, owneridname, subject
    from activitypointer
    order by createdon desc

    Morten
    • Marked as answer by Jim Glass Jr Thursday, April 2, 2009 8:37 PM
    Thursday, April 2, 2009 8:17 PM

All replies

  • There is no Advanced Find operator to filter out the last updated or closed record.

    Options:

    1. Maybe try View that sort by the date column of the entity in question and the first row would be the current value - you will still see a list of other row...

    2. Develop an SRS Report to provide this info

    3. SDK


    http://www.workopia.com/Links.htm
    • Marked as answer by Jim Glass Jr Thursday, April 2, 2009 8:38 PM
    Thursday, April 2, 2009 7:07 PM
    Moderator
  • Hi,

    You can do it like this (add as many columns you want to):

    select top 1 createdon, owneridname, subject
    from activitypointer
    order by createdon desc

    Morten
    • Marked as answer by Jim Glass Jr Thursday, April 2, 2009 8:37 PM
    Thursday, April 2, 2009 8:17 PM