Plugins » Katello

The content view version model never has any values in composite_content_views. Fetching id 8 of a composite content view version has empty list. This is the db at the time

katello=# select * from katello_content_view_components;
 id | content_view_version_id | composite_content_view_id |         created_at         |         updated_at         | content_view_id | latest 
----+-------------------------+---------------------------+----------------------------+----------------------------+-----------------+--------
  1 |                         |                         8 | 2018-04-30 13:48:49.614539 | 2018-04-30 13:48:49.614539 |               3 | t
  2 |                         |                         8 | 2018-04-30 13:48:49.62287  | 2018-04-30 13:48:49.62287  |               6 | t
(2 rows)

The UI doesn't rely on this field but instead makes a call to API which does return results as expected.

https://devel.example.com/katello/api/v2/content_view_versions?composite_version_id=8

This is the source line that I think should be joining the tables?
https://github.com/Katello/katello/blob/master/app/models/katello/content_view_version.rb#L28

    has_many :composite_content_views, :through => :content_view_components, :source => :composite_content_view

# cvv.composite_content_views goes through cvv.content_view_components
pry(main)> cvv.content_view_components.to_sql
=> "SELECT \"katello_content_view_components\".* FROM \"katello_content_view_components\" WHERE \"katello_content_view_components\".\"content_view_version_id\" = 4" 

As we can see in http://projects.theforeman.org/issues/23458#note-2, the components don't have the content_view_version_id attribute set.