Project

General

Profile

Bug #9965

Compound Query components not honoring the INCLUDE clause

Added by Lorian Sandu about 1 year ago. Updated about 1 year ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
production:
No
env_name:
topics:

History

#1 Updated by Lorian Sandu about 1 year ago

do transaction:

    for each b, first a fields (a2 a3) no-lock:
        message a.a2.
    end.
end.
CompoundQuery query0 = new CompoundQuery();
            forEach(query0, "loopLabel0", new Block((Init) () -> 
            {
               RecordBuffer.openScope(b, a);
               query0.initialize(false, false);
               query0.addComponent(new AdaptiveQuery().initialize(b, ((String) null), null, "b.recid asc"));
               query0.addComponent(new RandomAccessQuery().initialize(a, ((String) null), null, "a.recid asc", LockType.NONE), QueryConstants.FIRST);
               query0.include(a, "a2", "a3");
            }, 
            (Body) () -> 
            {
               message((integer) new FieldReference(a, "a2").getValue());
            }));

The included array is set only for the big CompoundQuery.
When each component is processed in CompoundQuery.processComponent they do not override the included/excluded arrays and they remain with the default null value.

Also available in: Atom PDF