so in your film form,

you select actors...

be best to store the id’s rather than alias ...

in db, you have data stored as abc,def,ghi

in your search for the list module, for the actors field you have match set as?

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

Match settings are as follows:

• Match set to "Any Words Exact"
• Collection "None"
• Separator ","
• Comparison rule "Quoted"
• Comparison Mode "Multiple"
• Match Occurences "None"

Do unquoted.

Turn on debug in searches template config.

Post query here.

You are aiming to have a list of the films related to the actors in the current movie, that right?

Changed to "unquoted", result is the same. This is the Debug Ouput:

0.000 seconds (0.000); 5.44 MB (5.435) - beforeSearch

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

0.001 seconds (0.001); 5.48 MB (0.040) - afterSearch [Cache=OFF] = 17 results.
0.796 seconds (0.795); 5.96 MB (0.483) - afterRender [Cache=OFF]

Ah, just reread, you are on actor page, and getting all of their movies....

anyway, Seems like sd cck field not picking up any value at all.

What is setting for sd cck field?

I set it to "id" after changing the storage of the checkbox dynamic.

You can see an example for the search here (list below the text): https://www.ratingaction.com/index.php/filme-und-mehr/schauspieler/alyssa-milano

It should only show the movie "Phantom Kommando" but shows the entire list

So you reference, in the movie, the actors involved.

You store the article id of the actor article.

In your sd cck field, you are targeting the field in the content type. This would likely be "art_id".

This field should be in your actor view as well (I imagine)

This worked now, thanks a lot, Bucklash! I actually hadn't add the art_id field to the actor's content view before. Added it to the content view in the hidden section and it works now.

The only remaining issue I have with this now is in the movie view: The field lists the individual actors, but I haven't figured out how to add links to the the actors' articles. Any ideas?

Ok, thanks for the pointer. I will try to figure it out and report back.

And thanks a million for your help on the bigger problem of selecting the list properly! I really appreciate you taking the time and helping me out.

Looking at your website I see you're a musician in your day job? That's awesome! I play the bass guitar, but purely amateur. Our first gig will be my 40th birthday party later this year.

Coolio

I just started a Gypsy Jazz Duo. That stuff is pretty groovy.

First gig eh? Gotta get blind drunk and fall off stage, is the law! :D

Re my last post, probably a bit over kill... have set the link to view etc? 

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! :-)

ah there are some vids out there but not one’s i wanna rave about.

Yeah we touch on the standards but prob not herbie.

yeah just geetar and violin.

What about self, any vids?

Not yet, hopefully after my b'day party provided we don't screw it up :-)

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.