select * from projects where status = 'Active' select * from projects where status = 'On-Hold' select * from projects where status = 'Archived' select * from projects_reg where projectid not in ( '#replace(ValueList(active_projects.projectid),",","','","ALL")#''')

Welcome to the #application.settings.app_title#!

It appears that this is your first time running the application.


The first thing you'll want to do is to create a new project.


You may want to add a client first if the project applies to one.

Please have an administrator login to create the first project.

You are not currently assigned to any projects.


You must be added by an administrator or you may join one of the projects at right.

Latest activity across all your projects

select * from milestones_upcoming where dueDate <= select * from issues where dueDate <= select * from todos_upcoming where due <=
Due in the next 14 days
select milestoneid,name,projectid,projName from milestones_upcoming where dueDate = select issueid,issue,projectid,name from issues where dueDate = select todoid,todolistid,task,projectid,name from todos_upcoming where due =
#Left(dayOfWeekAsString(theDay),3)#
TODAY #Left(MonthAsString(Month(DateAdd("d",i,Now()))),3)# #LSDateFormat(DateAdd("d",i,Now()),"d")# #Left(MonthAsString(Month(DateAdd("d",i,Now()))),3)# #LSDateFormat(DateAdd("d",i,Now()),"d")#

Late Milestones
  • Today#daysago# days ago: #name# (#projName# | #firstName# #lastName# is responsible)

1 month | 3 months | All Upcoming Milestones
  • TodayTomorrow#daysDiff# days away: #name# (#projName# | #firstName# #lastName# is responsible)

Late ToDos
  • Today#daysago# days ago: #task# (#name# | #firstName# #lastName# is responsible)

1 month | 3 months | All Upcoming Todos
  • TodayTomorrow#daysDiff# days away: #task# (#name# | #firstName# #lastName# is responsible)

Open Issues
ID Project Type Severity Status Issue Assigned To Reported Updated Due
#shortID# #name# #type# #severity# #status# #issue# #assignedFirstName# #assignedLastName# #LSDateFormat(DateAdd("h",session.tzOffset,created),"mmm dd, yyyy")# #LSDateFormat(DateAdd("h",session.tzOffset,updated),"mmm dd, yyyy")# #LSDateFormat(dueDate,"mmm dd, yyyy")#
RSS FeedRecent Activity
Project Type Title Action User Timestamp
#projectName#
issue">Issue message">Message milestone">Milestone todolist">To-Do List file">File project">Project screenshot">Screenshot #type#">#type#
#name# #name# #name# #name# #name# #name# #name# #name# #name# #activity# by #firstName# #lastName# #LSDateFormat(DateAdd("h",session.tzOffset,stamp),"mmm d, yyyy")# #LSTimeFormat(DateAdd("h",session.tzOffset,stamp),"h:mm tt")##LSTimeFormat(DateAdd("h",session.tzOffset,stamp),"HH:mm")#
There is no recent activity.
 
#application.settings.company_name#

Add a new client


Create a new project


Your projects

On-Hold projects

Archived projects

Projects you can join