Results 1 to 1 of 1

Thread: Calls dashlet - sort by date AND time

  1. #1
    ChocolateLover is offline Sugar Community Member
    Join Date
    Feb 2007
    Posts
    14

    Default Calls dashlet - sort by date AND time

    I'd like to be able to sort calls in the Calls Dashlet by start time AND start date.
    e.g.
    This is the correct sort
    02-23-2007 9:00
    02-24-2007 9:30
    02-24-2007 13:30


    This is the incorrect sort
    02-23-2007 9:00
    02-24-2007 13:30
    02-24-2007 9:30

    I've added start time to the list view but this gives me a start time OR start date sort.

    I can either

    1) concatenate the date and time within the MySQL string - something like CONCAT( date_start, CONCAT(' ', time_start ) ) AS date_start
    I can't see where to add this to the query

    2) similar to 2, but create a new field - CONCAT( date_start, CONCAT(' ', time_start ) ) AS date_time_start
    Again, I can't see where to add this to the query.

    If I did use CONCAT - would this give me a useable (sortable) date/time result?

    Is there a way to set a field that the query sorts on by default? And set it to ascending or descending?

    I'd be grateful for any help.

    Thanks.
    Last edited by ChocolateLover; 2007-02-06 at 10:43 PM. Reason: Moved to Developers forum
    SugarSuite 4.5.1
    OSX 10.4.8
    Apache 2
    PHP 5
    MySQL 4

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Start date and Time
    By njoy in forum General Discussion
    Replies: 0
    Last Post: 2006-08-21, 04:20 PM
  2. Start date and Time
    By njoy in forum Help
    Replies: 0
    Last Post: 2006-08-21, 04:19 PM
  3. Date and Time fields
    By kbrill in forum Developer Help
    Replies: 0
    Last Post: 2005-12-18, 07:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •