jasonamyers

create view [dbo].[FilteredAnnotationUS] (
    annotationid,
    createdby,
    createdbydsc,
    createdbyname,
    createdbyyominame,
    createdon,
    createdonutc,
    documentbody,
    filename,

jasonamyers

create view [dbo].[FilteredEmailUS] (
    activityid,
    actualdurationminutes,
    actualend,
    actualendutc,
    actualstart,
    actualstartutc,
    category,
    compressed,

jasonamyers

  SELECT 
    DocumentBody,
    ObjectId,
    FileName,
    CONVERT(varchar(255), ObjectId) + '_' + CONVERT(varchar(255), Filename) AS SaveAsFileName
  
  FROM
    FilteredAnnotation
    
  WHERE

jasonamyers

  SELECT
    EA.Body,
    EA.ActivityID,
    EA.AttachmentNumber,
    EA.FileName,
    CONVERT(varchar(255), EA.ActivityID) + '_' + CONVERT(varchar(255), EA.AttachmentNumber) + '_' + CONVERT(varchar(255), EA.Filename) AS SaveAsFileName
  
  FROM
    FilteredEmail E JOIN
    ActivityMimeAttachment EA ON E.ActivityID = EA.ActivityID

jasonamyers

create view [dbo].[FilteredAppointmentUS] (
    activityid,
    actualdurationminutes,
    actualend, 
    actualendutc,
    actualstart, 
    actualstartutc,
    category,
    ccs_administrativeevent,
    ccs_administrativeeventname,

jasonamyers

create view [dbo].[FilteredAccountUS] (
    accountcategorycode,
    accountcategorycodename,
    accountclassificationcode,
    accountclassificationcodename,
    accountid,
    accountnumber,
    accountratingcode,
    accountratingcodename,
    address1_addressid,

jasonamyers

The idea of GlucoTracker is to make tracking and trending blood sugar levels easier and more accurate. It is exceptionally difficult to remember to test until it is too late. In addition to the everyday testing, once a quarter they must complete a test regiment that requires them to test prior to breakfast, 2 hours after eating, before lunch, 2 hours after eating lunch, dinner, 2 hours later, and bedtime. It's called an accucheck 360. Example PDF It is also important to spot trends in the measurements and alert the user to those trends. The main focus of the application is around making it accessible to seniors and fast for everyone. Blood sugar ranges from 0-1000, with the norm being 80-120 outside of the 2 hours after eating which should be no more than 1

jasonamyers

  {% macro render_field(field) %}
  <div {% if field.errors %}class="control-group error"{% else %}class="control-group"{% endif %}>
      {% if field.name != "id" %}
      <label class="control-label">{{ field.label }}</label>
      {% endif %}
      <div class="controls">
          {{ field(**kwargs)|safe }}
          {% if field.errors %}
          {% for error in field.errors %}
          <span class="help-inline">{{ error }}</span>

jasonamyers

  def catalogs_home(request):
      userid = authenticated_userid(request)
      username = Users.by_id(userid).username
      clients = DBSession.query(Clients).order_by(Clients.active).all()
      commodities_count = []
      sandbox_status = []
      production_status = []
      for client in clients:
          category_count = 0 
          for category in client.categories:

jasonamyers

  def handle_cp(message):
      message = getattr(message, 'com.pb.clearpath.api.exception.CPAppException', None)
      errdesc = None
  
      if message:
          while True:
              if hasattr(message, 'exceptions'):
                  print "Exceptions"
                  if hasattr(message.exceptions, 'exceptions') or hasattr(message.exceptions, 'errors'):
                      message = message.exceptions