I have created a new field on an existing content type. The field is called "Global News." It's a checkbox and I need it to be checked for all existing nodes. I ran a SQL query to gather all nodes of a specific type joined with the latest revision ID. Both the "field_data_field_global_news" and "field_revision_field_global_news" tables are populated with the correct fields but the checboxes remain unchecked. Is there another table I need to update so this field is linked to the correct nodes?
I tried editing one of the nodes manually, which worked, but the table entry remains the same which leads me to believe there is another table that needs populating.