Sub-queue inheritance - blank columns

MS1Corp

I have a global queue that presents CustomFormA::FieldA1 and CustomFormB:FieldB1
Both field values are visible as expected.

I have a global sub-queue that presents identical columns, inherited from the parent queue

A1 value inaccurately presented as blank on the sub queue
B1 value accurately presented and visible on the sub queue

I modified the queue to present A4 instead of A1. Same result: A4 blank on sub queue.
Known problem? How do I fix the join, etc?

Worth noting, the Filter on the sub-queue is NOT related to A1.
Note: GitHub Issue #5890 (open bug) not the same as what I'm seeing.

Thanks

KevinTheJedi

MS1Corp

Can you show what you mean with all the criteria, columns, etc. shown from the queue modification page (in the admin panel)?

Cheers.

MS1Corp

Turns out it was essentially the same problem as #5890.

I was able to patch both the normal join strategy of a non-filtered column sourced from a custom form on a subqueue, AND the corresponding sub-queue Counts query.

Working properly now.
When's the 2.0 anticipated? Need a beta customer?

KevinTheJedi

MS1Corp

Again, can you show what you mean so the class can learn?

You can sign up for notifications on the Next site. We will send out campaigns for beta testers, etc.

Cheers.

MS1Corp

I can't provide a screenshot, but I'll try to describe again

Parent Queue
Col 0: Ticket Number (ootb field)
Col 1: Custom Form A, Field A1 (joined)
Col 2: Custom Form B, Field B1 (joined)
Example Data:
Col0 Col1 Col2
123 XXX YYY
presented on screen correctly

Sub Queue
Inherit Columns from Parent Queue
Filter on Form B, Field B1 "has a value" or any condition
Col 0: Ticket Number (same as above)
Col 1: Custom Form A, Field A1 (same as above, but system didn't create in independent Form A Join to fetch)
Col 2: Custom Form B, Field B1 (same as above, system created a Form B join properly)
Example Data:
Col0 Col1 Col2
123 ___ YYY
presented incorrect, Col1 is blank because system didn't join to Form A.

If the Filter is on a joined Form, that join is created and the field is presented.
All other non-Filtered joined Forms display as blank (no additional joins are created)

KevinTheJedi

MS1Corp

Yea but you said you patched it so care to share? Because I get most of what you're saying except the last bit. Are you saying if you filter on say Form A alone the proper JOIN is created in the query but if you add an additional form say Form B then only one will work and all others will be blank?

Cheers.

MS1Corp

if you filter on say Form A alone the proper JOIN is created in the query but if you add an additional form say Form B then only one will work and all others will be blank?

Correct.

I'm hesitant to share the patch until I put some meaningful test cycles in production first. I'll circle back. Thats why I was asking how long until 2.0. 😃

KevinTheJedi

MS1Corp

Odd.. once I see the changes you made I'll be able to better understand the problem and solution.

Cheers.