To get documents that meet a specific condition based on a certain array, or to get those whose array type field values contain at least one member of a certain array. There is a given array [English, History, Math]. We want to find information of students who select at least one of the courses in the given array from the following students collection:

To do the task with MongoDB script, we’ll filter the collection using the combination of filter+input+cond+$in to get the intersections, remove documents whose intersections are null, and then filter the lesson field and display the desired documents. The whole process is roundabout.

esProc SPL, however, will handle the task by performing intersection operations.
Download esProc installation package HERE.

Directions for accomplishing the task with esProc:
1. Write SPL script lesson.dfx in esProc:

2. Execute the script and return the following result:

esProc offers JDBC interface, so you can easily integrate the script into a Java program:
public static void doLesson() {
  Connection con = null;
  java.sql.Statement st;
 
  try{
    Class.forName("com.esproc.jdbc.InternalDriver");
    con = DriverManager.getConnection("jdbc:esproc:local://"); 
    // Call script lesson.dfx
    st=con.createStatement();
    ResultSet rst = st.executeQuery("call lesson");
    System.out.println(rst);
  }catch(Exception e){
    System.out.println(e);
  }finally{
    // Close database connection
    if (con!=null) {
      try {
        con.close();
      }catch(Exception e) {
        System.out.println(e);
      }
     }
    }
}

Read How to Call an SPL Script in Java to learn more about integration of esProc SPL script into a Java program.