Why doesn't the rest of the query show in the query phrase?

So I’m working on a query and it seems like the query phrase in the general tab isn’t showing the whole query. Shouldn’t the sub query be showing there too?

If I make the LateClockins sub the top level temporarily it shows this. Shouldn’t all of that be in there when it’s a sub query?

how are those subqueries related? what is the type of the second subquery? if it is Inner Subquery then it should be used in the top subquery somehow.

1 Like

Did you press Save?

Can you send a screen print of the query list?

Here’s how the sub query is related.

Yup. I even tried closing all of the way out of epicor and back into it, and it’s still the same today after coming back to a restarted computer.

And now, when I set it back to updateable, it cannot find those fields so it gives me an error when I need to map the fields for input column mapping. When I try to save, it locks up and I have to quit epicor altogether.

Looks like I have to remake this one from scratch…

I think that the problem might be in the order?

Try this:

Move the TopLevel to the bottom and change the InnerSubquery to CTE. Then save and refresh.

Regards

I tried this already

But it’s not a CTE, why does that work?

It seems to have worked… I now have the rest of the stuff in the query phrase tab.

I’m still having some problems getting my mapping set back up to to be the UDBaq that I need, but it will save with the default mappings. I’ll mess with some stuff and give an update if I can’t get something figured out.

1 Like

I am not sure why it works but I know it does haha. Yeah let me know if anything else comes up.

Perhaps the gurus @josecgomez @Bart_Elia or @Mark_Wonsil could shed some light in the matter

1 Like

So here are some mapping issues that are showing up.

When using the query results fields it doesn’t give you a usable field.

The query phrase shows this.

I guess I figured out how to work around it, but I generally try to use the helpers as much as possibly in order to make sure I don’t make typos. Is this typical? or is something still messed up with the query?

And after all of that, the mapping was what was giving me the problems with the saving and working. It will save and work correctly as an inner sub. It just won’t show the whole query phrase. But I couldn’t see the issue without being able to see the sub in the query phrase.

It also works as the CTE (as long as the tables are in the correct order).

Go figure…

hahaha technology man!

So everything is fixed now?

Seems to be. Thanks for the help!

1 Like