[email protected] - Friday, March 21, 2014 5:14 PM:
Hi
Is it somehow possible to set a default sort order on in example the BOM relationship view?
When adding parts to a BOM like the example below. When opening the BOM it will sort on Sequence. I would like to sort on Part Number instead as default. It would save the users from clicking on the Part Number column header so set the sort order each time a part is opened.
1711002
1711046
1713010
1711003
Kind Regards
Henrik Olesen
Kamstrup A/S
Denmark
tstickel - Monday, March 24, 2014 8:26 AM:
Sorry, the answer that I gave below is not correct. The problem with my answer is that Part Number is not a property of Itemtype Part BOM, so you can not set it as being an Order By column. The correct way to do this for Part BOM is:
1. Go to the Itemtype definition for the relationship, in your case it would be Itemtype = Part BOM. Change the Order By value for the diefinition of the Sequence property to 2 (it should initially have the default value 0).
2. That is all you have to do, because Innovator will then give precedence to the Order By value from itemtype = Part. Where the out-of-the-box setting is for Part Number to have Order By = 1.
So now the relationship grid will order the rows by Part Number, Sequence instead of the out-of-the-box order of Sequence, Part Number.
You can see an explanation of this in the online Help->Innovatro Administration->Relationships->Modifying the Relationship Type Item. Look in the section with the label "Grid View".
---- Original answer below ------
Yes, you can modify the default sort order for records on a relationship tab.
Go to the Itemtype definition for the relationship, in your case it would be Itemtype = Part BOM. For each property defined on the porperties tab you can set a value in the Order By column. In an out-of-the-box installation you will see that Order By = 0 for the Sequence property. Thus, the BOM records are sorted by Sequence Number.
So you can remove that value for Sequence and set the Order By for Part Number to 0 instead. You can do more complex default sorting by setting the Order By for more than one property.
[email protected] - Tuesday, March 25, 2014 4:26 PM:
Hi Terry
Thank you very much for your reply.
I have just tried changing the Order By on the Sequence property to 2. It works almost as supposed.
Problem solved besides one thing. When I open a BOM it stil sorts by the sequence byt if I press refresh it now sorts on Part Number. I don't understand why I have to push refresh?
Kind Regards
Henrik Olesen