How to include the multi Picklist field in Fetch Record Criteria in Deluge Script?

How to include the multi Picklist field in Fetch Record Criteria in Deluge Script?

Hi All, Need  an help. I have a problem to restrict the fetch record based on multi pick list value( Look up field having capable to select more than one value-  bigintlist).
 Problem Outline. I have a Attendance Form which has a Absent-Students multi picklist and date field. for getting the student information for a month or certain period.

To get the Attendance details for a particular student i have to restrict it based on course and semester details. but not on student id to the absent-students lookup field.

Currently i am doing it as follows
  1. Loop though each attendance record ,
  2. for each attendance record get list of absent students.
  3. Loop though each student and see which record matches the required students id
This is not efficient as i am looping unnecessarily.

Here is a sample code

  1. for each  attendanceRecord in Fill_Attendance[Semester == semesterId && Subject_field == subj && Academic_Batch_Field == BatchId]
            {
                for each  student in attendanceRecord.Absent_Students
                {
  2.                // If student is absent for 1 class in a month then unnecessary iteration gives the limitation error of delige script
                    if(student == studentId)
                    {
                        totalClassesAbsentTillDate = totalClassesAbsentTillDate + 1;
                    }
                }
            }
Error received  : Number of statement execution limit exceed Line:(32)

Any idea of to construct the fetch record including bigintlist as one criteria?

Thank You