BAQ - Table Criteria - Changing filter value changes filter field - anyone else see this?

Epicor ERP 10
1

I’ve looked around and I do not see anyone else reporting this. If I can get a little validation I’ll submit to Epicor, or if it’s just me, I’ll wait until I patch up to the next level and see if it still exists.

Here’s a short video of the behavior because it’s hard to explain. The same field value change occurs when changing the operation cells too.

And this is an older BAQ from 10.1.500 that went through the upgrade, if that matters. I have not seen this behavior on queries created in 10.2.300.

BAQ Editor Behavior.mp4 (301.4 KB)

2

Yeah Mike that has bit me in the ars so many times. Still happening in 10.2.300.12>

3

I saw that the other day too! It’s only happened once to me so far. That was in 10.2.300.

4

Does it only happen when the condition is already set, and you change it to a different type of condition?

Or does it happen when you change the details of the existing condition too?
(Like if you change a constant from MC to XC)

5

In my experience ,it happens any time you change the “value” side of the equation (after you’ve set it the first time)

6

Thanks guys. It’s getting so much worse now that I’m editing a slew of BAQ’s because of a process change. Aggravating. And now I’ve found where an external query (change of datasource) reset ALL of my table criteria back to field=company, operation is ‘=’, and expression = null.

Anyone report it to Epicor? Any hints as far as how to avoid it as much as possible?

Anyone got a name at Epicor of who I can stalk about this?(besides the guy @Bart_Elia is bringing to the Vegas meetup?)

@ckrusen - seems to be whenever you alter a condition in any way. I first noticed it like @josecgomez says, but it breaks when you are changing the operation value too…

7

There’s no avoiding it @MikeGross I’ve gotten used to looking at the my field after every change and no I didn’t report it to Epicor because #Lazy
But if you do send me your ticket number and I’ll join in the chorus. Or better yet here @Rich please fix this? :pray:

2 Likes
8

My suggestion, clunky as it is. Take a quick screen shot before making the changes. I know I will after you showing me this @MikeGross

9

Me Three

1 Like
10

Would a copy and paste work?

  1. Copy the whole table, paste into excel
  2. Edit the value (type or its value). This switches the Filed to Company
  3. Copy just the first first 4 columns from excel,
  4. Paste Update.

And FWIW - I don’t have the initial problem posted.

11

no you can’t copy paste down there.

12

It would be awesome if you could though!!

13

Are we talking about something different?

I can copy and Paste Update (not full rows) in the BAQ Table Criteria pane…

Watch how I use Paste Update to change the Field of row 2 from Company to OrderNum

BAQ%20table%20criteria%20Paste%20Update
BAQ table criteria Paste Update.gif841×526 245 KB

1 Like
14

Happens to me on 10.2.300.11. Annoying!

15

Ah I’ve tried with full rows… I’ll give her a shot thanks @ckrusen

16

Paste Insert doesn’t work (even with just the first 4 columns worth of data).

But Paste Update does seem to (as long as you’re not including the Filter Value column).

You can add several new (and “undefined”) rows first, and then use Paste Update for the first 5 columns: And/OR, (, Not, Field, and Operation

4 Likes