Hello;
The below query is returning the values for the record of the columns idx, origin, destination, hop_price, parent, if I need to add column for the returned value “get_subsc_hops
” (and not for the database table), how I can do this?
In other words, I need to be able for example to set the following value:
get_subsc_hops[1][‘description’] = “Available”
get_subsc_hops[2][‘description’] = “Not Available”
Where description field is not existed in the table tabTaxi Subscription
Hops in the below query. How to achieve this?
get_subsc_hops = frappe.db.sql("""select idx, origin, destination, hop_price, parent from `tabTaxi Subscription Hops` where parent = %s order by idx asc""", (get_subscription[0]['name']), as_dict=True)
Regards
Bilal