Jamroom Logo Jamroom 5 Core
is now Open Source!
Follow Jamroom on Twitter!

This document applies to Jamroom 2 only!
For current Jamroom 4 Documentation, visit the main Jamroom Documentation section.

Available SORT Orders for use in Song Search Areas

Column Name Description
s.song_id Sort by the Song ID
s.song_time Sort by the Song Creation Date
s.song_name Sort by the Song Name
s.song_album Sort by the Song Album Name
s.song_label Sort by the Song Label Name
i.band_id Sort by the Artist ID number
i.band_time Sort by the Artist Creation Date
i.band_name Sort by the Artist Name
i.band_location Sort by the Artist Location
h.hifi_size Sort by the SIZE (in bytes) of the HIFI Song file
h.hifi_length Sort by the LENGTH of the HIFI song
l.lofi_size Sort by the SIZE (in bytes) of the LOFI Song file
l.lofi_length Sort by the LENGTH of the LOFI song
song_total_count Sort by the total number of plays (Streams + Downloads) for the song
song_stream_count Sort by the number of Sreams for the song
song_download_count Sort by the number of Downloads for the song
g.genre_name Sort by the Song Genre Name
r.rating_number Sort by the number of Song Ratings for the song
r.rating_average Sort by the Song Rating Average for the song
Solutions Products Support Community Company
Social Media Platform
Social Networking Software
Musician Website Manager
Community Builder
Jamroom 5
Jamroom 5 Modules
Jamroom Marketplace
Support Forum
Documentation
Support Center
Contact Support
Community Forum
Member Sites
Developers
About Us
Contact Us
Privacy Policy
©2003 - 2024 The Jamroom Network