Skip to Content
This question has been flagged
viewstreeviewdefaultorderdefinition
3 Replies
7632 Views
Avatar
Raphael

We want to have certain columns in a tree view sorted in an ascending way. In order to achieve it I tried to edit the tree view under Manufacturing Orders (Edit Tree View (Developers Mode)) and I added the following line

<tree default_order='x_Delivery_Date_To_FSLSales'>

It now reads:

<?xml version="1.0"?><tree fonts="bold:message_unread==True" colors="blue:state in ('draft','confirmed');red:date_planned&lt;current_date and state not in ('done','cancel');black:date_planned&gt;=current_date;gray:state in ('done','cancel') " string="Manufacturing Orders">

<tree default_order='x_Delivery_Date_To_FSLSales'>
</tree>

<field name="x_Delivery_Date_To_FSLSales"/>

<field name="sale_ref"> </field>

</tree>

It comes up with a 

ValidateError

Field(s) `arch` failed against a constraint: Invalid view definition

Can someone please help out on how to have a tree view sorted according to a specific column. I have seen various answers but could not figure out how to edit the view definition in order to achieve this.

Avatar
Discard
Avatar
Jusab Sida (jsi)
Best Answer

Hello Raphael,

Can you try with this???

<?xml version="1.0"?>
<data>
	<tree fonts="bold:message_unread==True" colors="blue:state in ('draft','confirmed');red:date_planned&lt;current_date and state not in ('done','cancel');black:date_planned&gt;=current_date;gray:state in ('done','cancel') " string="Manufacturing Orders" default_order='x_Delivery_Date_To_FSLSales'>
		<field name="x_Delivery_Date_To_FSLSales" />
		<field name="sale_ref" />
	</tree>
</data>


Avatar
Discard
Raphael
Author

Thank you for the suggestion: I am now getting the following error: "Uncaught TypeError: Type is not a function"

Raphael
Author

Just removed the and and it now works fine. Thank you very much!

Avatar
Pouya Malekinejad
Best Answer

You have two </tree> tags!

<tree default_order='x_Delivery_Date_To_FSLSales'>
</tree>  <-- remove this
<field name="x_Delivery_Date_To_FSLSales"/>
<field name="sale_ref"> </field>
</tree>
Avatar
Discard
Raphael
Author

Thank you for the answer. I have taken the line out and it now states: "Premature end of data in tag tree line 1, line 10, column 3"

Related Posts Replies Views Activity
Can tree/list views be customized to show more than 80 items? Solved
views treeview
Avatar
Avatar
1
Mar 15
3460
How to add set default value from tree view edition Solved
treeview default
Avatar
Avatar
Avatar
Avatar
3
Mar 15
16463
How to redirect to form view after clicking row in custom SQL tree view? (14.0)
views treeview formview
Avatar
0
Sep 21
1255
Default filters on views for different user groups?
filter views default
Avatar
0
Aug 16
2272
Button to Open Product Record in Tree view
views treeview mrp
Avatar
Avatar
1
Apr 15
5104