Change Sort Order View based on time stamp?

Basic Installation and Setup.

Moderator: davidyin

Post Reply
tonylagrassa

Change Sort Order View based on time stamp?

Post by tonylagrassa »

Hello All,
Is there a way to change the sort order to display who logs in first, second ect? We work in an office in which sales reps come in and whoever is first gets the first call and then on a rotation basis from there ie:

Bob 8:00
Tim 8:02
Joe 8:03

Any ideas?
User avatar
davidyin
Members
Members
Posts: 192
Joined: Wed Apr 27, 2005 10:50 pm
Location: Burnaby

Post by davidyin »

Let me show you how to mod it.

1) Open default.asp in any text editor.
2) About line 275, find
if orderby <> "userfirstname" and orderby <>"recordstatus" then
and replace it by

Code: Select all

if orderby <> "userfirstname" and orderby <>"recordstatus" and orderby <> "recordaddon" then
3) Line 462, find

Code: Select all

<td  width="160" align="center" class="rightline style12px">Updated</td>
and replace it by

Code: Select all

 <td  width="160" align="center" class="rightline style12px">
				   <%
				  if request.QueryString("groupid") <> empty then
				  	if request.QueryString("locationid") <> empty then
					orderbytime = "default.asp?order=recordaddon&locationid="&request.QueryString("locationid")&"&groupid="&request.QueryString("groupid")
					else
					orderbytime = "default.asp?order=recordaddon&groupid="&request.QueryString("groupid")
					end if
				  else
				  	if request.QueryString("locationid") <> empty then
					orderbytime = "default.asp?order=recordaddon&locationid="&request.QueryString("locationid")
					else
					orderbytime = "default.asp?order=recordaddon"
					end if
				 end if
				  %>				  
				  <a href="<%=orderbytime%>">Updated</a></td>
4) Save it. you may find the link to sort by time.
tonylagrassa

Awesome. . . Works liks a charm

Post by tonylagrassa »

Thanks again
tonylagrassa

Can this action be the default?

Post by tonylagrassa »

Can this change be used as the default view?
ie it will show who's is as the default view
User avatar
davidyin
Members
Members
Posts: 192
Joined: Wed Apr 27, 2005 10:50 pm
Location: Burnaby

Post by davidyin »

You can change it as you like.
Post Reply