pears.NetOwnerDashboardDiaryNext [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetOwnerDashboardDiaryNext ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetOwnerDashboardDiaryNext"( in "pWebUserID" char(20) ) 
result( "nextevent" char(100) ) 
begin
  select top 1
    "string"("d"."description",' @ ',"dateformat"("d"."diaryfrom",'hh:nnaa')) as "nextevent"
    from "diary" as "D"
      key join "staff" as "S"
      left outer join "iqxnetuser" as "U"
    where "U"."iqxnetuserid" = "pWebUserID"
    and "dateformat"("d"."diaryfrom",'yyyy-mm-dd hh:nn:ss') >= "dateformat"("NOW"(),'yyyy-mm-dd hh:nn:ss')
    and "dateformat"("d"."diaryfrom",'yyyy-mm-dd') = "dateformat"("NOW"(),'yyyy-mm-dd')
    order by "d"."diaryfrom" asc
end /* DOC
2017-03-23 | gets the next diary event
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerDashboardDiaryNext" IS 
{create PROCEDURE pears."NetOwnerDashboardDiaryNext"(in pWebUserID char(20))
RESULT(nextevent char(100))
BEGIN
    SELECT
        TOP 1 
        string(d.description, ' @ ', dateformat(d.diaryfrom, 'hh:nnaa')) as nextevent
    FROM
        diary D
        KEY JOIN staff S
        LEFT JOIN iqxnetuser U
    WHERE
        U.iqxnetuserid=pWebUserID
    AND
        dateformat(d.diaryfrom, 'yyyy-mm-dd hh:nn:ss') >= dateformat(NOW(), 'yyyy-mm-dd hh:nn:ss')
    AND
        dateformat(d.diaryfrom, 'yyyy-mm-dd') = dateformat(NOW(), 'yyyy-mm-dd')
    ORDER BY 
        d.diaryfrom ASC
END

/* DOC
    2017-03-23 | gets the next diary event
*/
}
</code>