Window Header Fields not in SQL View
Bradd Notestine asked 4 years ago
So we have an Extender Window for additional vendor information with 5 fields on the “header” area. The window also has 5 additional detail fields under ‘Options’ so we can enter in a series of forms for each Vendor.
When a vendors extender window “header” fields are filled out but no forms are added to the scrolling grid area, the fields are not populating in the SQL view created. As soon as form is entered, the vendor record appears on the SQL View. When all of the forms are removed from the scrolling grid detail area, the vendor record again disappears from SQL View.
Is this supposed to work this way or did I find a bug? If it’s intended, is there anyway to force the header information in to the SQL View regardless of whether or not there are scrolling grid detail fields filled out?
When a vendors extender window “header” fields are filled out but no forms are added to the scrolling grid area, the fields are not populating in the SQL view created. As soon as form is entered, the vendor record appears on the SQL View. When all of the forms are removed from the scrolling grid detail area, the vendor record again disappears from SQL View.
Is this supposed to work this way or did I find a bug? If it’s intended, is there anyway to force the header information in to the SQL View regardless of whether or not there are scrolling grid detail fields filled out?
Answers
Patrick Roth Staff answered 4 years ago
“Is this supposed to work this way or did I find a bug?”
It would depend on whether you wrote the view or let Extender create it with Extender Views window. I assume the latter.
This would seem to be intended functionality (I tested it and could repro)
” If it’s intended, is there anyway to force the header information in to the SQL View regardless of whether or not there are scrolling grid detail fields filled out?”
You can guess the “issue” due to the behavior we see.
In this case, Extender creates the view using
EXT01100 inner join EXT01110
So no records in the EXT01110 then you get no records in the query results.
To make this work to show “header” information w/o detail information – just change the view in SQL to be “left join” instead of “inner join” and it’ll work as you are looking for.
It would depend on whether you wrote the view or let Extender create it with Extender Views window. I assume the latter.
This would seem to be intended functionality (I tested it and could repro)
” If it’s intended, is there anyway to force the header information in to the SQL View regardless of whether or not there are scrolling grid detail fields filled out?”
You can guess the “issue” due to the behavior we see.
In this case, Extender creates the view using
EXT01100 inner join EXT01110
So no records in the EXT01110 then you get no records in the query results.
To make this work to show “header” information w/o detail information – just change the view in SQL to be “left join” instead of “inner join” and it’ll work as you are looking for.