Flexiblesearch query

[Former Member]

I am trying to remove a suffix from an order number and see if the resulting order number can be matched.

ie. {Order.code} is 12345678-5

I want to remove the ending '-5' and see if I can find a matching {Order.code} for '12345678'

Is there a way to accomplish this?

[Former Member]

Thanks, got it working now!

[Former Member]

Hi , My suggestion is write the groovy script and run it. In that get the Orders ending with -5 from flexiblesearchquery .Then split the order code of each orderModel and Update the orderModel with the new Order Code.

Note:But If the orders have the Order-process and Consignment-process and their codes also need to change if You're using these codes for getting the Ordermodel in any where.