iLogic - Setting BOM to sort numerically

[glenrouch84TLA]

I have a BOM that has a custom iProperty called BOM Order to be able to sort line items into the desired order, with some of the values being decimals and some being integers up to the hundreds. This can be done manually, but with the process we have, it is repeated constantly and can be automated. However, when trying to use iLogic it sorts it alpha-numerically as the picture shows. How can I get around this without having to edit the BOM Order iProperty for every single part?

[A.Acheson]

Hi @glenrouch84TLA 

If the manual sort methods don't work for you then out of the box ilogic won't either as your only automating the manual workflow. See below sort method for partlist and here for help page.

Syntax

PartsList.Sort2( PrimaryColumnTitle As String, [PrimaryColumnAscending] As Boolean, [SecondaryColumnTitle] As String, [SecondaryColumnAscending] As Boolean, [TertiaryColumnTitle] As String, [TertiaryColumnAscending] As Boolean, [SortByString] As Boolean, [AutoSortOnUpdate] As Boolean )

Can you bring the question up on the ilogic forum? There is custom sort functions that might be able to help you out. See this post here realting to custom sort function in the BOM. Please include a sample sort list and the sort criteria you have used (screen shot the editor)