Order Options Problem?

Trevor

#231837

It would be better to have one field with year, and another field with edition. That way the number of choices would massively reduced and be much easier to use in the front end.

But, that would require restructuring of the data. Probably by means of a SQL command to add the extra fields based on the existing field.

This would probably require the assistance of a third party coder.

Anonymous

#231839

Thank you for this input – that might be a solution for the future – but now this would be too much effort
How could we realize a correct order with this plain “textfield”?

Trevor

#231841

It might be possible with this filter:

https://searchandfilter.com/documentation/action-filter-reference/#filter-input-object

It is likely that the data for that field would be in an array, and thus that would require an array sort based on that ‘field’ of the array.

Do you want me to refer this to the plugin developer, Ross? I am not sure what access he might need for the site to be able to code it for you, or indeed he may have a simpler method.

Anonymous

#231844

Thank you – i will have a look at this!
But what is now the difference between “01-17” and the other entries?

Trevor

#231846

I used that number only as an example. That is to be found in the WordPress database, but its label, 17-01 is not in the WordPress database. The same is the case with all these value/label pairs.

At the heart of your problem is that the wrong data forma is stored, and there are a substantial number of posts that would require editing to change this. Thus, the solution mus use programming, such as this filter, but, we need to understand that this may cause a performance hit due to the sheer volume of entries.

Also, I would reiterate that a dropdown choice box like this would be a very poor end user experience, which will likely impact on site views/traffic.

[Author]

Posts