How to add more columns to listview

[ahmadRagheb]

hi ,
normally listview takes 2 parameters as extra columns but i need to add more
i tried to add them form making the docfield in list view , but it doesn’t show then i try to add it in the
doctype_list.js
colwidths: {“status”:2,“from_date”: 2,“to_date”:2,“employee_name”:2,“leave_type”:2},
but it doesn’t edit it out ,
and finally i tried to edit the columns , and it didn’t change any thing ?

[johnskywalker]

I believe, listview only allows 3 columns… What I can suggest is that you create a field that will have the 2 fields already (string type is suggested) ex. that field will have from_date/to_date

[bghayad]

@johnskywalker
Thank you for the advise.
But I have question: how to remove the status column from the list view? I checked the fields if it contains document_status or status and I did not find it.

Regards
Bilal

[bghayad]

Adding more columns is possible via list_render.js as in the below link (search for list_render.js as the link is talking about another topic) and thanks a lot for @joelios:

Dashboard issue heatmap in v9

Hi @bghayad With changes on list_render.js, it is possible to add mor fields to listview: [grafik] but adding a horizontal scrollbar would involve significant changes to list_render.js! My question; Do you really need to force more fields in the listview? you can solve the same also over a report …? Cheers

Regards
Bilal

[vimal0777]

can you elaborate with step by step procedure for adding more columns to list view

[ofca]

@vimal0777

Dashboard issue heatmap in v9

Hello @joelios I confirmed the problem that is related to the education heatmap that you proposed, but it is only related to the attendance and it seems that it is related to the unix_timestamp at the query which cause error that is related to the timestamp = get_timestamp(date) as in the following traceback: Traceback (most recent call last): File “/home/frappe/frappe-bench/apps/frappe/frappe/app.py”, line 62, in application response = frappe.handler.handle() File “/home/frappe/frappe-ben…

Posts in this thread are as step-by-step as it goes.

My request is: since I hate making changes to code base, and this has been asked about numerous times, could the number of columns perhaps be changed to a setting instead of being hard-coded?

[szufisher]

I am proposing to add new feature to support multi version of layout per list / report view, but not enough feedback yet.

[New Feature] Personalized layout for list and report view, Add more columns to list Ad Hoc

Currently, the core function frappe.get_list / frappe.get_all is a high level API to wrap raw SQL call to the database, which is extensively used by the list view and reports, there is already special logic to directly allow filtering by child table field, e.g filtering sales order by item_code field in items child table, we can use filtering arguments like this: filters={‘item_code’:‘xxx’}, it is also possible to fetch child table fields by either use the argument with_childnames or directly ad…

[bghayad]

All the problems of the customization will be resolved if erpnext (or frappe) has Overwrite or Inheritance capabilities. So instead of being worry about the overwrite when doing upgrade, you can customize whatever you would in the script by separated file and using Inheritance and Overwrite. Really I do not know if this is possible in ERPNext.

Regards
Bilal