# BDM custom query JPQL use operator IN

**URL:** <https://community.ofelia.com/t/bdm-custom-query-jpql-use-operator-in/26553>\
**Category:** Q&A\
**Tags:** bonita-studio\
**Created:** [8 November 2024 11:40 UTC](https://community.ofelia.com/t/bdm-custom-query-jpql-use-operator-in/26553 "2024-11-08T11:40:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![oiaremenko](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/oiaremenko/32/836_2.png) [@oiaremenko](https://community.ofelia.com/u/oiaremenko)\
**Post date:** [8 November 2024 11:40 UTC](https://community.ofelia.com/t/bdm-custom-query-jpql-use-operator-in/26553/1 "2024-11-08T11:40:05Z")

</div>

Hello.  
I try to create custom query with IN operator and get error.  
For example. I have an query:

Select e  
From equipment e  
Where e.id in :params

I added parameter with name params and type java.lang.String

When i try to call this query with next code in process script:  
equipmentDAO.eq([‘1’, ‘2’], 0, 100)

I get error:

wrapped by org.bonitasoft.engine.expression.exception.SExpressionEvaluationException: groovy.lang.MissingMethodException: No signature of method: com.xsense.model.server.EquipmentDAOImpl.eq() is applicable for argument types: (ArrayList, Integer, Integer) values: [[1, 2], 0, 100]

Possible solutions: eq([Ljava.lang.String;, int, int), any(), grep(), wait(), every(), dump()

How to properly call this query with list of values?

---

<div class="post-metadata">

**Author:** ![thalia.cruz](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/thalia.cruz/32/1230_2.png) [@thalia.cruz](https://community.ofelia.com/u/thalia.cruz)\
**Post date:** [14 November 2024 13:43 UTC](https://community.ofelia.com/t/bdm-custom-query-jpql-use-operator-in/26553/2 "2024-11-14T13:43:21Z")

</div>

Hi @oiaremenko!

Since it is expecting specifically a type` java.lang.String[]` you should be more explicit.  
Try it this way:

```auto
def myList = ['1', '2'] as String[]
equipmentDAO.eq(myList, 0, 100)

```

Hope this helps.  
Cheers!  
-Thalía