Dynamic Query BO

I'm just reading the LaborHed and EmpBasic tables.



From: "bruce.d.ordway@... [vantage]" <vantage@yahoogroups.com>
To: vantage@yahoogroups.com
Sent: Friday, August 26, 2016 12:02 PM
Subject: [Vantage] Re: Dynamic Query BO



>>100-PayrollExport
Just wondering if you're using Payroll tables in your queries?
If so, I remember there being a process to generate keys for users.
And my payroll queries wouldn't return data for users whose keys had not been generated.




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];


>>100-PayrollExport
Just wondering if you're using Payroll tables in your queries?
If so, I remember there being a process to generate keys for users.
And my payroll queries wouldn't return data for users whose keys had not been generated.