Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Saturday 11:50 am
Add a reply View Replies (1)

Resolved Mass Update Field Values/Change Select Field Options

  1. QuickScriptz
    QuickScriptz
  2. Support
  3. Wednesday, April 04 2018, 01:46 AM
I currently have a select field called "listing_visibility", and this field has two possible values: "Yes" and "No". I'm in a situation where I need to change the possible values to be "True" and "False", and then change all the old yes/no values to be true/false.

I think think all I need to do is update the values in the *_jsn_users table for the listing_visibility column, but that almost seems too easy. Is there a better way to do this and/or am I missing something?
Responses (1)
admin
admin Accepted Answer
Admin
Hi,
the best way to make this is to launch 2 simple SQL Queries like: 
UPDATE #__jsn_users SET listing_visibility = 'True' WHERE listing_visibility='Yes'

UPDATE #__jsn_users SET listing_visibility = 'False' WHERE listing_visibility='No'


Of course you need to change also options in the select field like 
True|True

False|False
  1. more than a month ago
  2. Support
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.