I am seeing some strange results with the Dynamic Query BO. I get results with my user account and other users accounts, but if I try to run this against some other accounts I get no results. Anyone know why this returns data for specific users and not all? Field security is broke in my version so I'm guessing it is not that.
DynamicQueryDataSet ds = qry.GetByID(@"QryID");
QueryExecutionDataSet qds = new QueryExecutionDataSet();
ds.QueryWhereItem[4].RValue = @"08/01/2016";
ds.QueryWhereItem[5].RValue = @"08/14/2016";
ds.AcceptChanges();
DataSet ds2 = qry.Execute(ds, qds);
dataGridView1.DataSource = ds2.Tables[0];
QueryExecutionDataSet qds = qry.GetQueryExecutionParametersByID("QryID");
qds.ExecutionParameter.Clear();
qds.ExecutionParameter.AddExecutionParameterRow("StartDate", @"08/01/2016", "date", false, Guid.NewGuid(), "A");
qds.ExecutionParameter.AddExecutionParameterRow("EndDate", @"08/14/2016", "date", false, Guid.NewGuid(), "A");
DataSet ds = qry.ExecuteByID("100-PayrollExport", qds);
dataGridView1.DataSource = ds.Tables[0];