private string FilterAsSql()
{
return(GeneralDataOperations.BuildSqlAndFilter(this.Filter.GetProjectsSqlFilter(),
this.Filter.GetResponsiblesSqlFilter(),
this.Filter.GetTagsSqlFilter(),
this.Filter.GetKeywordsFilter()));
}
static internal List <ProjectItem> GetNoSummaryActivities(string filter = "", string orderBy = "")
{
filter = GeneralDataOperations.BuildSqlAndFilter($"ProjectObjectTypeId <> {ProjectItemType.SummaryType.Id}",
"Status <> 'X'", filter);
string sql = $"SELECT * FROM PMProjectObjects " +
GeneralDataOperations.GetFilterSortSqlString(filter, orderBy);
var op = DataOperation.Parse(sql);
return(DataReader.GetList <ProjectItem>(op));
}
