使用 IN 运算符查询具有联接列的持久性实体

问：

我有一个实体，例如 follow，它与另一个名为 story_id.Story

import javax.persistence.*;
import java.util.Date;

@Entity
@Table(name = "user_story_mapping")
public class UserStoryMapping {
 
     @ManyToOne
     @JoinColumn(name = "story_id")
     private Story story; // this attribute
 
     @Column(name = "user_id")
     private String userId;
 
     @Column(name = "seen_at")
     private Date seenAt;
  
     @Transient
     private String storyId;
}

我尝试执行的是查询此表，例如

select usm.story_id as storyId from user_story_mapping usm where usm.user_id='Naman' and usm.story_id IN ("8a9f90858871dc9f018abc3fc3dc4e86","ffhy8a9f9abc3fc3dc4e09") and usm.status = 1;

为了在 的帮助下实现这一点，我引用了以下查询常量：javax.persistence.EntityManager#createQuery

public static final String GET_ACTIVE_USER_STORY_MAPPINGS = """
             from UserStoryMapping usm \
             where ((usm.userId = :userId) and (usm.story IN :storyIds) and (usm.status = 1))
             """;

在执行时，这会导致以下异常

…nested exception is java.lang.IllegalArgumentException:
Parameter value element [8a9f90858871dc9f018abc3fc3dc4e86] did not match expected type [entity.core.Story (n/a)]"

如果我将查询更改为

public static final String GET_ACTIVE_USER_STORY_MAPPINGS = """
             select usm.story_id as storyId \
             from UserStoryMapping usm \
             where ((usm.userId = :userId) and (usm.story_id IN :storyIds) and (usm.status = 1))
             """;

然后我被卡住了

org.hibernate.QueryException: could not resolve property: story_id of: entity.core.UserStoryMapping [select usm.story_id as storyId\nfrom entity.core.UserStoryMapping usm where ((usm.userId = :userId) and (usm.story_id IN :storyIds) and (usm.status = 1))\n];