1. 02 Jan, 2020 2 commits
    • Narayanan Iyer's avatar
      Merge branch 'master' into 'master' · a2a535f2
      Narayanan Iyer authored
      Add Function Library _YDBOCTOVISTAF
      
      See merge request !11
      a2a535f2
    • Chris Combs's avatar
      Library of custom Functions _ydboctoFunctions.m · f9142d64
      Chris Combs authored
      CURR_TIMESTAMP() --horolog datetime  or CURR_TIMESTAMP("v") Fileman Datetime
      DATEFORMAT(value,formatcode) -- formats based on datetime type returns MM/DD/YYYY HH:MM:SS as default
      			     -- uses "5ZSP" for fileman dates unless formatcode is otherwise specified
      			     -- if fileman date calls VA routine $$FMTE^XLFDT(value,format) to format
      IFNULL(value,replacer)	    -- Takes a passed field and replaces a null value with whatever is passes as the second
      				argument
      TOKEN			    -- Renamer for Mumps $Piece function
      Replace(value,finder,replacement) -- takes any string and searches for the finder string to replace it with the
      				replacement string, modified string is returned
      SUBSTRING(value,start,range)   -- returns a part of passed value staring at the position specified by
      				start (2nd parameter), continuing for range (3rd parameter) or
      				end of string whichever comes first
      FMGET(file#,field# or name,keys) -- VistA specific, uses VA Routine $$GET1^DIQ to take foreign kets and fetch a field 					from the specified
      LEFTY(value,characters)		-- return left x characters from value
      RIGHTY(value,caharacters)	-- return right x charaters from value
      PATINDEX(value,searchstring)	-- returns the position of the first occruence of search string in value
      NUMBER(value)			-- returns the mumps equivalent of +value, numeric portion returned only
      f9142d64
  2. 13 Sep, 2019 1 commit
  3. 11 Sep, 2019 1 commit
    • Christopher Edwards's avatar
      Change translations for date, timestamp and primary_key to numeric · a52d81ed
      Christopher Edwards authored
      Octo previously treated INTEGER and NUMERIC as equivalent, however
      recent changes have changed that equivalency and now the correct
      data type needs to be specified.
      
      In VistA dates and timestamps are numerics with a decimal point.
      The primary key data type is also converted to a numeric as it is
      possible to have decimals in the IEN columns.
      a52d81ed
  4. 29 Aug, 2019 2 commits
  5. 18 Jul, 2019 2 commits
  6. 12 Jun, 2019 8 commits
  7. 18 Apr, 2019 2 commits
  8. 08 Apr, 2019 2 commits
  9. 03 Apr, 2019 2 commits
  10. 28 Mar, 2019 6 commits