NS: Project Card View saved search field

project_card_view.sql

'
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/semantic-ui/2.4.1/semantic.min.css" />
<div class="ui card" style="width:600px;">
  <div class="content">
    <div class="right floated meta"><i class="user circle icon"></i> ' || {custentity_atlas_svs_em_pm_list} || '</div>
    <div class="header">' || {entityid} || ' ' || {jobname} || '</div>
    <div class="meta">' || {customer} || '</div>
  </div>
  <div class="content">
    <div class="ui three mini statistics">
      <div class="statistic">
        <div class="value">
          <i class="clock outline icon"></i> ' || {plannedwork} || '
        </div>
        <div class="label">
          Planned Hrs
        </div>
      </div>
      <div class="statistic">
        <div class="value">
          <i class="clock outline icon"></i> ' || {actualtime} || '
        </div>
        <div class="label">
          Actual Hrs
        </div>
      </div>
      <div class="statistic">
        <div class="value">
          <i class="clock outline icon"></i> ' || {timeremaining} || '
        </div>
        <div class="label">
          Remaining Hrs
        </div>
      </div>
      <div class="statistic">
        <div class="value">
          <i class="money bill alternate outline icon"></i> ' || TO_CHAR({estimatedlaborrevenue}, '999G999G999G999', 'NLS_NUMERIC_CHARACTERS=",."') || '
        </div>
        <div class="label">
          Est Revenue
        </div>
      </div>
      <div class="statistic">
        <div class="value">
          <i class="money bill alternate outline icon"></i> ' || TO_CHAR({estimatedlaborcost}, '999G999G999G999', 'NLS_NUMERIC_CHARACTERS=",."') || '
        </div>
        <div class="label">
          Est Cost
        </div>
      </div>
      <div class="statistic">
        <div class="value">
          <i class="percent icon"></i> ' || ROUND({estimatedgrossprofitpercent}*100, 1) || '
        </div>
        <div class="label">
          Est GP
        </div>
      </div>
    </div>
  </div>
  <div class="extra content">
    <span class="right floated">' || {status} || '</span>
    <span>' || ROUND({percenttimecomplete}*100, 0) || '&percnt; Complete</span>
  </div>
</div>
'