Hi, I just installed the SD Live CCK field and can't seem to get it to work properly. My use case is as follows: I have a movie database where I have one content type for movies and one for actors. For each movie I select the actors using a Checkbox Dynamic field. The database stores the article alias for each actor based on the Checkbox selection. On the Actor-page I would like to list all movies this actor has starred in.
To achieve this I have set up a List / Search module that is displayed on the individual actors' pages. As search criteria I have set the following:
"Core Content Type": set to "Film" (my content type for movies)
"Nebendarsteller" (my checkbox dynamic field that allows me to select the actors):
Live Value set to "SD Live CCK field" and Configure set to "art_alias"
Match set to "Any Words Exact", Collection "None", Separator ",", Comparison rule "Quoted", Comparison Mode "Multiple", Match Occurences "None"
However, on each actor page all movies in my database are displayed, regardless of whether they have been selected or not. Where am I going wrong?
I changed storage from alias to id, in case it makes a difference and changed the configuration for the live value to "id" instead of "art_alias". Result is still the same, though. For one movie this is now what's stored in the actors field: 18,17,19,14,16,15
SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.author_session AS author_session,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias FROM `#__cck_core` AS t0 LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t1.state = 1 AND t1.access IN (1,1,5) AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2019-07-08 12:10' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2019-07-08 12:10' ) AND t0.cck = 'film' ORDER BY t1.title ASC LIMIT 25
So guitar + violin? Do you have any performances up on Youtube, yet? We play mainly Jazz standards (Autumn Leaves, Beautiful Love and the likes) and some stuff that's a bit more funky, like Herbie Hancock. It's definitely great fun!
On the links: Yes, tried all that. I only get it to display either one link to the film article I'm on across all actors or no link at all. Haven't found any setting that separates the links by posted content article, yet. So possibly the php route was not ott after all. Will be a learning experience! :-)
I found a workaround for my display related article links problem. It's not very elegant, but it works.
I set up two field per related article type (in my example two each for actors and for directors): One is a Field X of related articles pointed to the category I want and the other is a checkbox dynamic field.
In the admin view I have both fields, so I have to enter actors and directors twice per film: Once as checkbox selection and once as Field X / related articles.
In the content view I put the Field X in the position where I want to display the list of actors or directors. The Field X of related articles is automatically rendered with correct links to the actor / director articles. The checkbox selection I put in the "Hidden" position. This is only needed to automatically populate the lists on the actor / director pages.
I appreciate that this may be too cumbersome for user-driven sites where users woudln't understand why they need to put in the same information twice. But for my purposes (I am the only one entering info) it does what I want it to and I don't have to spend more time trying to find a solution.