Hey all. So I create a uBAQ and throw Customer in.
I add in Customer.Comment, and a few UD fields, and set them as updatable.
I save the query, and add it to my dash, set it to subscribe to CustNum, and now I notice that I’m getting rows for all customers.
Go back into the query, and I see Epicor has added this funky little blue thing:
I throw in a join on ForeignSysRowID = SysRowID and boom, correct results in the analyzer.
I save and reload, and now my join is gone.
Anybody know what I’m doing wrong?
That occasionally happens, no one seems to know why. Usually, you just delete the blue table, and re-add your fields that will now be missing. If you’ve got a lot of work already done, then you can add the joins like you did, and that usually works.
If it keeps happening on this specific BAQ, it would be interesting if you can figure out what’s doing it by just cutting stuff out until it stops doing that. Then maybe they can fix that bug!
It’s very reproducible in my system. Deleting the UD table and readding the fields didn’t work, it just comes back on reload.
I did finally get it to work by trying a new query and bringing in one field at a time, saving and reloading. But, strangely enough, the first couple of times I got the same results within the first couple of fields.
This may sound strange but I swear I think it had something to do with the order in which I enabled Updateable, Added the table, and added the BO.
