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?
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…
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.
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).