public Guid OrgMembersQuery(int progid, int divid, int orgid, string memberTypes) { var c = db.ScratchPadCondition(); c.Reset(); var mtlist = memberTypes.Split(','); var mts = string.Join(";", from mt in db.MemberTypes where mtlist.Contains(mt.Description) select $"{mt.Id},{mt.Code}"); var clause = c.AddNewClause(QueryType.MemberTypeCodes, CompareType.OneOf, mts); clause.Program = progid.ToString(); clause.Division = divid.ToString(); clause.Organization = orgid.ToString(); c.Save(db); return(c.Id); }