Can Configurator query the database?

You will have different options depending on how your Epicor is hosted. We are on Epicors cloud, so all server side functions are super locked down. However I was able to make a dynamic list be populated with dynamic params.

  • Make BAQ with appropriate parameters.
  • Make a client side UD function that returns a ~ delimited string.
  • Call your BAQ in UD method and pass the inputs as parameters
  • Create a dynamic list, and for the source select your client side UD method created above.
  • Make sure to Refresh() your dynamic list when any of the inputs used as parameters for the BAQ are updated.
1 Like