E10 Filter by empty UD20.Key1

Epicor ERP 10
1

Hey all,

Smack dab in the middle of my E9 to E10 uplift. Barely any hair left. I have a dashboard utilizing the UD20 table. In E9, I filter my grid as UD20.Key1 = Constant: NullValue and it works fine. This does not work in E10. I’ve tried the Constant: NullValue which returns zero results, I’ve tried ‘’, “” and even ? but still no results in my grid. Any ideas or tricks? Could the dashboard have some sort of corruption from the upgrade?

Thanks,
Chris

2

Is there any data in that table?
Typically a record in a UDXX table would have at least a value in Key1 to make a record…

But I digress. If you’re trying to filter on the dashboard level (vs. the filtering on the BAQ level or on the Ultragrid Filter level), it seems to work just fine for me. Not sure what level you’re trying to filter at.
image

3

I have the UD20 table linked to JobMtl. I am trying to show all JobMtl that do not have a UD20 record thus Key1 would be null. I ended up creating a calculated field in my BAQ that is false if there’s no related UD20 record. I was able to filter on this.

Thanks,
Chris