Criteria in BAQ

Epicor ERP 9
1

Is it possible in a BAQ to add table criteria to check if a value begins with a number or not?

Thanks,
Chris

2

Yes, use the begins operator.

1 Like
3

In what context? BEGINS with what?
Do you mean several criteria entries such as JobNum BEGINS “0” or JobNum BEGINS “1” and so on?

4

Depends how you want to filter the BAQ.

…BEGINS with a number.

5

A thought from @hkeric.wci, does begins support regex?

6

I was hoping to use something like regex or substring with the array of numbers 0-9…

7

This works for what you want, I think.

image

8

Version 9 doesn’t have LIKE as a criteria choice. :frowning:

9

Is MATCHES available?

Got this to work in V10 also
image

1 Like
10

I don’t have access to E9 anymore and can’t run any tests.

11

Is that [0-9]%
Hard to see. If so, it didn’t work in 9.

However, this worked. [0-9]*
I remembered in 9, the magic is the *

Thank you thank you!!!

2 Likes
12

Well, just so you know, it worked great until it came to the dashboard. This criteria causes the dashboard to not load giving the following error. Some BAQs (Name of BAQ) missing from current Company. Please contact system administrator. I remove the criteria and it is fine.

13

One of our users got that same error yesterday (9.05.701). Turned out I forgot to mark the BAQ shared. Shared it and the error went away.:thinking:

1 Like
14

I wish mine were that easy. Must be a bug because the BAQ handles it just fine but not the dashboard referring to the BAQ.
By the way, that was the first place I looked…