It works it seems.
"Mapped the table in the Global Mappings for %ALL"
Thanks both Robert and Rich. I tried %ALL already and mapping, but it did not work...
I am missing something, obviously.
Here's what I have done:
- Created %ALL namespace
- Created a table OriginalNamespace.TableName
- Mapped the table in the Global Mappings for %ALL I used the Portal's System > SQL to create the table and to insert/select data from it.
As mentioned, not visible unless in the original namespace.
It is giving a result for either top n or without it, but only when "group by" is not there.
As soon as I add that line it spits out the error.
To leave a comment or answer to post please log in
Please log in