trying, tell me if something is wrong.
program:
list_union(
list_intersection(field('tags'), 'Historical, Fantasy, Sci-Fi, Contemporary, Military', ','),
list_intersection(field('#shelf'), 'Historical, Fantasy, Sci-Fi, Military', ','),
',')
This gives me result of only one genre. How to have multiple values in results? A book might be in military and historical. And the result should be Military, Historical, not just Military
I read about list functions but can't really figure it out
.