ProjectWorkOrder: { title: 'CWO', width: '5%', dependsOn: 'ProjectID', options: function (data) { if (data.source == 'list') { //Return url of all countries for optimization.  //This method is called for each row on the table and jTable caches options based on this url. //alert(data.record.PWOID); return appRoot_Append + '/tlm/GetCWOListAdmin?ProjectID=0';// '/Demo/GetCountryOptions?continentalId=0'; } return appRoot_Append + '/tlm/GetCWOListAdmin?ProjectID=' + data.dependedValues.ProjectID; } //key: true },
Following is the stored procedure its calling

ALTER PROCEDURE [dbo].[spCWOAdmin] ( @ProjectID int = 0 ) as if (@ProjectID > 0) begin select ProjectID,[ProjectWorkOrder] from tblProject where Projectid=@ProjectID end else begin select pwo.ProjectID , p.ProjectWorkOrder--, from tblPrototypeWorkOrder pwo LEFT OUTER JOIN tblProject p on pwo.ProjectID = p.ProjectID LEFT OUTER JOIN tblTestStatus ts on pwo.TestStatusID = ts.TestStatusID LEFT OUTER JOIN tblDepartment d on pwo.DepartmentID = d.DepartmentID Order by PWOID end

This is the stored procedure that is running in listAction
  alter PROCEDURE spAdminProtoType AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; select PWOID, PWOTitle , PWORequestorID, pwo.ProjectID , pwo.DepartmentID , ProjectPhaseID, PWODateCreated, p.ProjectWorkOrder, ts.TestStatus, pwo.TestStatusID, d.DeptName from tblPrototypeWorkOrder pwo LEFT OUTER JOIN tblProject p on pwo.ProjectID = p.ProjectID LEFT OUTER JOIN tblTestStatus ts on pwo.TestStatusID = ts.TestStatusID LEFT OUTER JOIN tblDepartment d on pwo.DepartmentID = d.DepartmentID Order by PWOID END