Recently, I’ve created a BAQ to view a indented BOM, and currently I use a single paramater, which can be difficult for people that don’t know the part name. I have it so they can use a ‘’ for multiple parts, but I wish it would be more like some of the default searches for epicor applications, and …

Use a quick search a BAQ as your data filter. You can customise the Quick Search to return data to your dataView on the Dashboard. Here is the code to launch a Quick Search //launch special search to retrieve pending PO receipts r object ret = ProcessCaller.InvokeAdapterMethod (oTrans.E…

[image] Anthony_Mattice: Is this because it is still searching through every part in the database? It actually times out the refresh after a while. Yes, with a recursive query, you will actually need the parameter or it’s going to do what you are witnessing. A where clause only gets you so fa…

I see that now, as no matter what I seem to do it still times out when I remove my parameter. Would you be able to give me some information on how to set that up? I’m mostly a newb when it comes to stuff like this.

[image] Anthony_Mattice: Is this because it is still searching through every part in the database? It actually times out the refresh after a while. [image] Banderson: Yes, with a recursive query, you will actually need the parameter or it’s going to do what you are witnessing. A where cla…

Sounds about right with my luck. This whole project has been a fun experience lol :lying_face:

[image] Banderson: The only way that they have it set up right now to pass a parameter into a dashboard without a popup is a publish and subscribe. Where you have a feeder grid publishing the value for the parameter, and then a “filter” (not tracker, filter in the properties) on the grid that ne…

So on your feeder query, you make a list of what you will need for the parameters. Then use properties, and check on the field that you want to publish. [image] On the receiver query, go the the parameters tab, and select the parameter, and make it equal to the field that you published. [image] …

[image] Anthony_Mattice: Sounds about right with my luck. This whole project has been a fun experience lol :lying_face: When you’re new, it’s all about a lack of knowledge. I still feel new. It shouldn’t be too hard to combine @aarong ’s & @Banderson ’s approach together. It won’t be too hard…

Yea, I don’t think this will work, as it takes out all my functionality in searching for multiple parts, and the refresh would be highly annoying.

[image] Banderson: So this isn’t ideal, as the query probably takes a little bit in your case, and it will refresh everytime you click on a different row, but it gets rid of the popup. I’m not really sure which is better. I think that’ll work nicely. He just needs to use the partsearch bit to…

Maybe I need to start looking at the lesser of two evils here… Have you ever read into this at all? Would it be possible to use this in a grid within my dashboard, and just use my text box as the paramaters it calls? [image] Epicor: Call a BAQ From Code Customization — GingerHelp You'v…

Creating a Part Search for BAQ

Epicor ERP 10

Banderson (Brandon Anderson) January 17, 2023, 4:30pm 49

You mean like this?

Topic		Replies	Views
BAQ Question for keeping results separate Epicor ERP 10 baq	44	2994	January 27, 2023
Make Custom Search Prompt Epicor ERP 10 customization	2	577	January 23, 2024
Passing Parameter/Filter in Dynamic Query Epicor ERP 10	27	23304	October 19, 2018
Price List BAQ: Trying a "contains" criteria on part num (full-text index needed?) Epicor ERP 10	14	8939	August 23, 2018
Possible solution for silent BAQ parameter passing (working now) Kinetic ERP baq , kinetic , baq-parameter , application-studio	30	9052	November 7, 2023

Creating a Part Search for BAQ

Related topics