• Replies 14 replies
  • Subscribers 337 subscribers
  • Views 17 views
  • Users 0 members are here
Related

Order By Command Not Working

Triland McConico
$organization

Hi,

I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

ORDER BY d.lname, d.fname DESC

Parents
  • $organization

    There is a new column in t_customer called sort_name, which is what I am using.

     

    _____________________________
    Lucie Spieler
    IT Development and Training Manager

    Editor, Season Program Book

    FLORIDA GRAND opera
    8390 NW 25th Street
    Miami, FL 33122
    305.854.1643 x. 1521
    Box Office: 800.741.1010
    To Give a Gift: 305.403.3315
    www.FGO.org

    2012-2013 | 72ND SEASON

    La bohème | The Magic Flute | La sonnambula | La traviata

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Triland McConico
    Sent: Friday, October 26, 2012 3:13 PM
    To: Lucie Spieler
    Subject: RE: [Tessitura Technical Forum] Order By Command Not Working

     

     

    I tried and it still does not work.  Anything else I might try.  Where you able to get it to work on your side.

     

    Triland L. McConico

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser
    Sent: Friday, October 26, 2012 12:52 PM
    To: Triland McConico
    Subject: Re: [Tessitura Technical Forum] Order By Command Not Working

     

    Try:   ORDER BY d.lname, d.fname

    From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com>
    Sent: 10/25/2012 6:54:00 PM

    Hi,

    I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

    ORDER BY d.lname, d.fname DESC




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    There is a new column in t_customer called sort_name, which is what I am using.

     

    _____________________________
    Lucie Spieler
    IT Development and Training Manager

    Editor, Season Program Book

    FLORIDA GRAND opera
    8390 NW 25th Street
    Miami, FL 33122
    305.854.1643 x. 1521
    Box Office: 800.741.1010
    To Give a Gift: 305.403.3315
    www.FGO.org

    2012-2013 | 72ND SEASON

    La bohème | The Magic Flute | La sonnambula | La traviata

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Triland McConico
    Sent: Friday, October 26, 2012 3:13 PM
    To: Lucie Spieler
    Subject: RE: [Tessitura Technical Forum] Order By Command Not Working

     

     

    I tried and it still does not work.  Anything else I might try.  Where you able to get it to work on your side.

     

    Triland L. McConico

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jason Kaiser
    Sent: Friday, October 26, 2012 12:52 PM
    To: Triland McConico
    Subject: Re: [Tessitura Technical Forum] Order By Command Not Working

     

    Try:   ORDER BY d.lname, d.fname

    From: Triland McConico <bounce-trilandmcconico7946@tessituranetwork.com>
    Sent: 10/25/2012 6:54:00 PM

    Hi,

    I have a report where I'm trying to sort by last name then first name.  I cannot get the Order By command to work.  Can someone share with me what I might be doing wrong?  Syntax Below:

    ORDER BY d.lname, d.fname DESC




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data