Well–I have a half working option.
Only issue is it does not let me do virtual paging; still working that bit out.
You could set a larger page size if you know what kind of results you’re expecting, though.
Here’s the setup:
Make a placeholder view. Don’t make it an actual BAQ view or it will pull the params slide out.
I made my parameter a dropdown on the front page. Bind that to something and after the form loads, initialize it for the first call. I guess, strictly speaking, you probably don’t have to initialize it?
OMG Thank you this works really well, I just set my page size to 100,000 not sure if this will cause any issues. The query explodes all BoMs for a customer or product category, so it can be pretty hefty.
I have it working just statically right now plugging in a string in the executions parameters. I am a bit confused on how to get it to bind with my textbox.
These are all the parameters the BAQ has(Currently just using a textbox for Ordernum just for testing):
@hmwillett Thanks for the help! The solution does have a couple limitations on the user end. They can’t personalize the column layout, and the data can’t be exported to excel or even copied to excel.
Why not?
Are they grayed out? If so, click the grid in App Studio, go to properties > advanced and enable them. Or possibly properties > grid model > advanced.
I’m pretty sure in there somewhere are checkboxes to allow those.
I have been placing parameters into a UD table that I set aside for this purpose. . @hmwillett@Camren360 - I don’t know how to do all of the programming.
Steps are:
Create an updatable BAQ using UD11.
Filter the table so Key1 is equal to current user ID
Setup update to populate Key1 with UserID when you add a record
Make all other fields updateable execpt for Key2 thru Key5
In the BAQ(s) you want to use parameters on - pull in UD11 as a datafilter
create InnerSubquery with UD11 filter to Key1 equals Current UserID
Using a suquery filter or pull in UD11 into the query so OrderHed.Order is between UD11.Date01 and UD11.Date02
The added benefit is you can have multiple BAQs on a dashboard, all filtered by UD11.Date01 and UD11.date02