Not seeing table options in BAQ Updatable BAQ Method Directives

Epicor ERP 10
,
1

Hello,

I am trying to teach myself Epicor Functions but it has been a slog.

I am watching the youtube ‘Epicor Functions’ from Codabear and having issues reprodcuing their example. (https://www.youtube.com/watch?v=2bKcOnBUA1U&t=1892s)

I get to the part where I create a new base processing called EmailResults.

I do the design and add the email widget.

I click in the body of the email and click ‘Insert’.

Below is all I see.

image

Why do I not have access to the Part table?

Is there a setting or a step I missed?

Any help is appreciated.

2

You need to go to “References” on the library, and add the table.

You also need to make sure on the main Library screen to allow access to the db. (if doing code)

If you need to write to the part table (with the DB context), you’ll need to select the checkbox on the table in the references tab.

3 Likes
3

image

image
image1176×688 86.9 KB

2 Likes
4

Of course now, reading the title, and reading the text, this does not compute.

Functions and updatable baq method directives are not the same.

3 Likes
5

I know it sounded confusing.

In the youtube video, he creates a uBAQ to email parts that are missing the ClassID. The part I am talking about start at approx 29:06 into the video.

  • He created the BAQ
  • Added Part table
  • Added a few display fields
  • Sets BAQ as Updatable
  • He then went to Update tab and selected Advanced BPM Update Only.
  • Then he clicks the ‘BPM Directives Configuration’ button.
  • Selects the Update method on the left and adds new Base Process.
  • Click the ‘Design’ button and add email widget.

At this point is where I don’t see the table query like he has (His screenshot below) at 32:02.

image

I didn’t see any steps I missed.

I am a Gov Cloud customer, if that makes a difference.

6

Where did you put your BPM? Update? Different methods in the UBAQ have different access to the tables.

2 Likes
7

image

Same as in the video.

8

Yeah, wonder if it’s a version thing. I don’t see it either.

9

If so, that makes it less than useful, IMO.

I guess if no one else chimes in, I got my answer.

Thanks for checking on your end.

Are you cloud or on premise?

10

We are on premise. I believe it would be with the change they made to the objects for the results. You have to use queryResultDataset.Results. It used to be on the top level of that object. You can get this using some variables, but it’s not as easy as it used to be. I was looking for an object type to use a variable to assign the results to, but I couldn’t find anything.

image
image742×276 10.3 KB

image

11

I haven’t watched the video, but did they explain WHY they put the Email part on the base directive? Just wondering, I would almost never want to override a Base Processing. In general, I tend to send emails from Post Processing directives.

If a table isn’t showing in the directives in a UBAQ, you may not have included it on the Update Processing tab. normally, you can just go there, click the BPM Update button and pick the default. But until you’ve done that, you may be missing some references. (again, I’m just making guesses based on stuff I’ve done before :smiley: )

12

With UBAQs there isn’t one. They are making their own thing. In UBAQs it can be common.

The video was just doing something custom, not actually updating anything.

1 Like
13

Aidy Bryant Snl GIF by Saturday Night Live

Unless you guys moved to Azure Local recently…

:rofl:

1 Like
14

Chelsea Peretti Eye Roll GIF by Brooklyn Nine-Nine

For the purposes of the question, we control our own fate, and happen to rent someone elses computer.

4 Likes
15

What version are you on?

It’s in 23.2
image

1 Like
16

sky flying GIF

1 Like
17

image

18

What options are you seeing when you right click in the mail message? In a blank one vs the one with the callcontext

19

I have been playing and created some variables so now I see those.

Otherwise it is the same as above.

image

20

I just looked at mine, and this guy is doing some odd stuff, but I digress.

For some reason, the dataset is missing on mine too, although it is available for the other directives. Odd.

I would not follow this video for any kind of advice, maybe describe here what you actually want to do, and we can point you in the right direction.

2 Likes