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
- Loop though each attendance record ,
- for each attendance record get list of absent students.
- 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
- for each attendanceRecord in Fill_Attendance[Semester == semesterId && Subject_field == subj && Academic_Batch_Field == BatchId]
{
for each student in attendanceRecord.Absent_Students
{ - // 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