I’ve been dealing with this issue for more than 24 hours and I’m not getting why it’s not working. I’m new on Epicor, hence, sorry for this silly question. I’ve been trying to filter the part revisions for only the ones with Approved checked. I tried using different ways to filter it as Table Criteria, but none of them worked.
What am I doing wrong?
Thank you.
Welcome Daniel! The trick here is to figure out what kind of field you are filteirng on. In this case, a bit field. So, the possible values are true and false. In your constant dialog box, enter true instead of 1.
Thats it! If it still doesn’t work, post your code.
Good luck!
Thank you Nate for your quick reply. Yes, although my snapshot showed 1 or 0, I did try True/False and didn’t work either. I also tried using a different Field, like ApprovedDate, or Approved By, none of them worked, the result is the same table with all info including blanks on those fields.
Try true without the capital t.
Same result. I tried that yesterday, but I tried again right now, is still giving me the entire results (including unchecked approved).
That should work. Let’s see your SQL.
It looks like you’re joining PartRev to the Part table, possibly on a different subquery? Possibly with a left outer join, rather than an inner join? Also, what is your intended outcome?
My thoughts exactly. 
I followed a video that describes exactly this, but in my case it’s not working. Here is the joined unions. Thanks for pointing this out Dan.
The filtering for Approved is on SubQuery2.
Without knowing what you want exactly, the only thing you need to get a list of unapproved Revs, is to add just the PartRev table, and apply that table criteria. If you are trying to do something else with your overall query, let us know. The subquery is not needed if you only need to see the approved/unapproved rev list.
Thank you. I will try again, but fyi, this is the video I was trying to replicate on my end.
Epicor Kinetic Business Activity Query: Fancy Tips & Nuanced Tricks - YouTube
I found another way of doing it by eliminating the subquery; apparently that was the issue. However, I insist that from the video link I shared, that subquery works good, but when I did the same, it doesn’t work here. Thank you very much Nate for your support.
It assumes that you dont have any Unapproved PartRevs. You can fix this multiple ways. Set another criteria on the First PartRev.
Without Filter
with filter
OR
Miguel, you rock! Thanks so much. It worked by adding a new criteria. Amazing!
1 Like