CS_Case_Console
QuestionDescriptionResponseTypeFormatTextHelpPreLogicPostLogic
CS_Search_StringControl System Case Search StringNULL25Enter a value to search. This may be a case ID, first name or last name. Whatever value is entered must be an exact substring of the fields to be searched.$CS_Search_String=$_REQUEST['CS_Search_String']; //echo 'Srch_Str=~',$CS_Search_String,'~ sess Srch_Str=',$_SESSION['CS_Search_String']; if($CS_Search_String=='') $CS_Search_String=$_SESSION['CS_Search_String']; else $_SESSION['CS_Search_String']=$CS_Search_String; echo ~




  1. Search for: ~; echo ~

    ~;
CS_Search_GoControl System Case Search Go ButtonButtonBUTTONGo Search for CasesClick on the Go button to perform the search. Results will appear below.echo ~


  • ~;
    • CS_Search_ResultsControl System Case Search ResultsNULL1Enter a value to search. This may be a case ID, first name or last name. Whatever value is entered must be an exact substring of the fields to be searched.echo ~

    ~; $string=$_REQUEST['CS_Search_String']; if ($string!=~~) { $tValue=$_REQUEST['CS_Search_Field']; $where=~ INSTR(rValue,'$string')>0 ~; $xtracols=array(); echo ~
    ~; $tfrm=$_SESSION['PM_TransFrm']; $fmt=$_SESSION['PM_TransFrmFmt']; CSsearchCases(1,0,'',~$where~,$tfrm,$fmt,$xtracols); echo ~
    ~; }

    CS_Case_CreateControl System Case CreationButtonBUTTONCreate A New Caseecho ~
  • ~;
    		• if ($prm=='CS_Case_Create') { $UserId=$_SESSION['UserId']; $ProjectId=$_SESSION['ProjectId']; ExecuteSQL(~insert into Responses (CaseID,qID,uID,ProjectId) select 'New Case', 'CaseID',$UserId,$ProjectId~); $CaseId=ShowQueryResultScalar(~select rUnique from Responses where CaseID='New Case' and qID='CaseID'~); ExecuteSQL(~update Responses set CaseID=$CaseId, rValue=$CaseId, rOK=2 where rUnique=$CaseId~); $_SESSION['CaseId']=$CaseId; $_SESSION['Instance']='1'; SetForm($_SESSION['PM_TransFrm']); } $stat=1;
    CS_Console_EndControl System Console EndNULLRADIOecho ~



    ~;