Ivan Milic - Networks expert Ivan Milic CEO Ivan Milic

Top Menu

× To post a question you must be signed in.

VM Excel-like Custom Field Ordering

26 Jul 2018 08:19 #2996 by Ray
Hi Holest

Is there a way to order the custom fields in the columns/grid ?

If it is a sql query or code modification i can do it.

I tried changing the ID number of custom field
virtuemart_custom_id in the virtuemart_customs and virtuemart_product_customfields tables

to order the columns differently but had no effect as i thought it would

i would like to have the custom fields reordered in the columns as in picture attached

thanks!

Attachments:

Please Log in or Create an account to join the conversation.

26 Jul 2018 08:38 - 26 Jul 2018 08:40 #2997 by Super User
Replied by Super User on topic VM Excel-like Custom Field Ordering
Hi,

that should be ok. Order of fields follows virtuemart_custom_id.

You need to actually change value of field so order could be set. Note that for list fields "Red;Blue" is same as "Blue;Red" and no set will be done.

I see you play around with SQL . You could use UDF add-on and configure "after update trigger" to set order more fine.

EDIT:

There is filed ordering in #_virtuemart_customs table. It has advantage over virtuemart_custom_id

Please Log in or Create an account to join the conversation.

Time to create page: 0.042 seconds