Tracker View Filtering on an Unfiltered BAQ

[Chris_Conn]

It sounds like the dashboard is calling the BAQ in the standard way. Are you sure you don’t have the BAQ attached to a BAQview?

Maybe we could isolate the issue. Create a random junk customization on any form (not a dashboard) - add a grid and a button and paste your code in. Does it work there?

[danbedwards (Dan Edwards)]

Bill - From a quick glance the code and BAQ look correct. Have you tried replacing the variables with some hard-coded values that you know work?

@BA-Quest

qds.ExecutionParameter.AddExecutionParameterRow(“Supplier”, txtSupplier.Text, “nvarchar”, false, Guid.NewGuid(), “A”);
qds.ExecutionParameter.AddExecutionParameterRow(“DateRangeStart”, varDateRangeStart, “date”, false, Guid.NewGuid(), “A”);
qds.ExecutionParameter.AddExecutionParameterRow(“DateRangeEnd”, varDateRangeEnd, “date”, false, Guid.NewGuid(), “A”);

Something like this with your specific values… This assumes you run your BAQ manually, populate the parameters, and it does return data.

qds.ExecutionParameter.AddExecutionParameterRow("Supplier", "12345", "nvarchar", false, Guid.NewGuid(), "A");
qds.ExecutionParameter.AddExecutionParameterRow("DateRangeStart", "1/1/2017", "date", false, Guid.NewGuid(), "A");
qds.ExecutionParameter.AddExecutionParameterRow("DateRangeEnd", "12/31/2017", "date", false, Guid.NewGuid(), "A");

[Chris_Conn]

Just curious what ever happened here @BA-Quest

[Ben_Rey]

Custom grid in tracker

What I ended up doing was the following made 2 baqs 1.to filter the VendorIDs from the vendor table. 2. to filter the Invoices based on dates I made with parameters 3. made a custom sheet added two epidatetime fields, a button and a text field for the vendor id to be passed from the initial vendor id the customer selects from the main tracker then I hid that field after I verified it was updating within the sheet. (I know its probably not the best way to pull the vendorID in and feels like a …

I was able to get something very similar to this working pretty much the same thing he was trying to do filter between two dates