Dear Sir,
I am new developer on ErpNext System. Can any one tell me how to get random record from asset using frappe.db.get_list command on Client Script.
I try this (using rand() on order_by)
frappe.db.get_list(“Asset”,{fields:[‘name’, ‘asset_name’, ‘item_name’, ‘item_code’,‘rfid’,‘barcode’],
filters:{‘workflow_state’:‘Normal’},
order_by:[‘rand()’]
}).then(records => {
but fail.
Thank you.