So I am trying to understand the best way to show field data associated with another content type and I am assuming that SEBLOD’s Search Join plugin can get the job done but no luck as yet. Or if I am going about this the wrong way and there’s another solution please help guide me i the right direction.
I have 2 content types: Locations, Procedures.
In my Location’s content type, I have a Dynamic Checkbox field that allows a user to select all of the Procedures assigned to this location (field name: location_assigned_procedures).
In my Procedure’s content type I have a Menu Item field (procedure_menu_item) which I am using to store the Menu Item links associated with each procedure.
Now here’s what I am trying to accomplish.
On my Locations Content View, which I am outputting via the seb_minima template override, I would like to output the Assigned Procedures and the Menu Item associated with each assigned procedure.
I created a List and Search Type (List Location Procedures), that will be referenced in my Location content type’s Content View by way of the Seblod List & Search Field.
In my List Location Procedures Search Form View, I have the following fields and settings:
Live Value = Procedures
Match = Exact
Match = Any Words Exact / Comma Separated / Unquoted
I am currently using the Table Template for my List View (eventually I will switch to List Template (Advanced) > set_minima Item View) but I figured this would be the easiest way to see how is my data being outputted.
In my List view, I have the Article ID field and the Menu Item field. Remember all I want to show are the Procedure Menu Items that have been assigned to a Location. Now I am assuming that because the data I need is in another table, I need to use the Search Join Field.
Since the Dynamic Checkbox field (location_assigned_procedures) stores a list of comma separated values in my #__cck_store_form_locations table, I don’t know how I will be able to LEFT JOIN my #__cck_store_form_medical_procedures table by it’s ID column
What’s another alternative approach to what I’m trying to accomplish?
Keep in mind, my skill sets are not the strongest when dealing with databases so you may have to break things down in layman terms for me please lol. Thanks for any help that you can provide.