FrontAccounting forum — Reverse order of dropdown list from input box

Re: Reverse order of dropdown list from input box

2018-02-13T14:04:58Z

A non alphabetical first char being omitted before sorting....
Thanks - hope this helps someone.

There was no difference in FA 2.3.26 - wonder what made this necessary now.

Re: Reverse order of dropdown list from input box

2018-02-13T04:16:27Z

Hi apmuthu, I changed it to this
array('c.description','IF(stock_id RLIKE \'^[a-z]\', 1, 2), stock_id')

Re: Reverse order of dropdown list from input box

2018-02-06T08:51:16Z

The ORDER BY is implemented in the array_merge() array's element of the first argument and remains the same in both FA 2.3.x and 2.4.x as:

'order' => array('c.description','stock_id')

What did you change it to, in order to make it the way you wanted?

Re: Reverse order of dropdown list from input box

2018-02-06T06:12:02Z

Ok. nevermind. I didnt look hard enough. It was just a few lines down the same file. Got it working.

Re: Reverse order of dropdown list from input box

2018-02-06T04:41:09Z

As mentioned, the new version of FA sorts items in a different order. I realized it may have something to do with the new version of mysql or php.
The sql concerned is

SELECT stock_id, s.description, c.description, s.inactive, s.editable
            FROM 0_stock_master as s,0_stock_category as c 
            WHERE s.category_id=c.category_id   ORDER BY c.description,stock_id;

which is found in include/ui/ui_lists.inc: function stock_items_list()

I tested adding REGEXP '^[a-z]' DESC, an answer I found in stackechange, and it works. But I cant figure out where the ORDER BY is located. It is not in the ui_list.php. Can someone point it out for me?

Re: Reverse order of dropdown list from input box

2017-12-23T00:23:53Z

Hi Apmuthu,

What I mean is the order of the list shown in the dropdown select box. I have search item ticked in the company page.
I tried to print screen the dropdown but it disappears. Is it even possible?

Here is an example:
If I type Gold bar, the results in the dropdown are as follows
Gold bar - Gold Bar 24k
123456789 - Gold Bar 24k
`Gold bar - Gold Bar 24k inner packaging
It is sorted as letters, numbers, then symbols. But in 2.4 symbols come first, then the rest.
I want to change it to the old one. What do I need to modify?

Re: Reverse order of dropdown list from input box

2017-12-22T14:50:26Z

In the text box before the dropdown select box for Items, only the item code can be typed. The dropdown will show the item name only and will be prefixed with the item code only if the "Show Item Codes" checkbox is ticked in the Preferences menu. Where do you get/see "symbols"?

If however, in Setup => Company Setup, the Search Items checkbox is ticked, then the textbox besfore the Items dropdown can be searched by Item Name when by Ajax, the dropdown will get filtered.

Re: Reverse order of dropdown list from input box

2017-12-22T07:49:34Z

Hi Apmuthu,
When you type in the text box the item code in sales, purchasing, or item page, it shows a combo box with the item code and the description sorted by category then item code. I want to change the order back to the previous one where symbols come last.

Re: Reverse order of dropdown list from input box

2017-12-21T15:08:26Z

Which dropdown are you referring to and where?

Reverse order of dropdown list from input box

2017-12-21T08:48:52Z

Hi, I needed to use 2.4 due to dependency issues. But I like the way the search function in 2.3 works and I want to overwrite it on v2.4.
In 2.3, symbols appear after the alphabets, after the numbers. But the order in v2.4 is symbols, numbers, letters. Can I easily modify this?