database:functions:pears_netorderreasonlist



pears.NetOrderReasonList

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."NetOrderReasonList"()
RETURNS long VARCHAR
//IQXWeb
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT "list"("string"("tempshiftorderreasonid",']~[',"description"),']~[' ORDER BY "sortorder" ASC,"description" ASC) INTO "rv" FROM "tempshiftorderreason";
  RETURN "rv"
END /* DOC
2016-10-20 PC modify to include doc and test
 
inputs:
none
 
outputs:
delimited list
 
tests:
test inherited through NetClientShiftOrderReasons
 
*/
/* TEST
 
*/
  • database/functions/pears_netorderreasonlist.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1