Sort by column headers in custom tables

jpp · July 29, 2016, 2:22pm

I have a doc type where I have a table presented with data pulled from an API. I want to be able to sort it by the column header.

I don’t think frappe has this functionality built in even for the built in modules, such as item listing, crm, etc. It would be nice since it helps to sort by alphabetical or other column names.

BhupeshGupta · July 30, 2016, 10:19am

are you using rest api?

if yes there are many options to play with.

http://localhost:8080/api/resource/Customer?order_by=creation desc&limit_page_length=100

use can use other params too

github.com

frappe/frappe/blob/develop/frappe/model/db_query.py#L27


      
          from frappe.model import optional_fields
          from frappe.model.meta import get_table_columns
          from frappe.model.utils.user_settings import get_user_settings, update_user_settings
          from frappe.query_builder.utils import Column
          from frappe.utils import (
          	add_to_date,
          	cint,
          	cstr,
          	flt,
          	get_filter,
          	get_time,
          	get_timespan_date_range,
          	make_filter_tuple,
          )
          
          
LOCATE_PATTERN = re.compile(r"locate\([^,]+,\s*[`\"]?name[`\"]?\s*\)", flags=re.IGNORECASE)
          LOCATE_CAST_PATTERN = re.compile(
          	r"locate\(([^,]+),\s*([`\"]?name[`\"]?)\s*\)", flags=re.IGNORECASE
          )
          FUNC_IFNULL_PATTERN = re.compile(
          	r"(strpos|ifnull|coalesce)\(\s*[`\"]?name[`\"]?\s*,", flags=re.IGNORECASE

jpp · August 1, 2016, 2:48pm

This is not an API or DB sort issue, this is an UI issue.