Retrieve (field) single value, from database using frappe.db.sql

Frappe Framework Customization
,
1

Hi ERPNext Community

I Want to retrieve (min date) single value, from my doctype , how to fetch this field to another doctype ?
depend on student group

x = frappe.db.sql(""" select DISTINCT MIN(schedule_date) AS _start_date ....     
                                            where student_group = '{0}' """ .format(
                                            self.student_group,), as_dict=True)
2

I actually didn’t get you want single value from particular record or minimum date from whole list of records.

get_min_date = frappe.get_value(DocType, {"student_group": self.student_group}, ['schedule_date']) // For single record only

get_min_date_list = frappe.db.get_all(doctype, filters= { "student_group": self.student_group }, fields= ['schedule_date']) // From list of records

min([i.get('schedule_date', '') for i in get_min_date_list])
1 Like
3

@Hardik_Zinzu
Not Working Sir

4

What is not working and what issue you’re facing ? Please share screenshot.

1 Like
5

Hi @Hardik_Zinzu
Thank you for response
my code is

fetch course date 1
fetch course date 11169×325 19.9 KB

and I Want to retrieve to

certificates issue tool
certificates issue tool1844×648 26.3 KB

6

@Hardik_Zinzu

thank you bro

my solution is

        if course_date:
            self.course_start_date = course_date[0].course_start_date
            self.course_end_date = course_date[0].course_end_date