The easiest solution here is to link the table from another namespace.  Only takes a second and you don't need to screw around getting the storage right (note: do NOT start editing storage defs if you can avoid it - that is not an easily maintained solution).  This solution does not work if you have to JOIN the two tables together (we call this a heterogeneous JOIN), however.  The next best solution is to write your own class query as @Stephen Canzano & @Michael Smart  have recommended.  It's a little work up front but you can make some easy changes, such as creating a temp table and populating it with data from the other namespace or using a process private global.

Hi Community!

New video is already on DC YouTube Channel:

API Design for REST

 

+ 1   0 1
0

comments

107

views

+ 1

rating

Hi Everyone!

New webinar "Rest API Design and Development" is available now on  DC YouTube Channel:

 

+ 1   0 2
0

comments

135

views

+ 1

rating