Support › MB Custom Table › Custom Table: Taxonomy field och Taxonomy Advanced field?Resolved
- This topic has 4 replies, 2 voices, and was last updated 1 year, 7 months ago by
Bellul.
-
AuthorPosts
-
October 27, 2021 at 8:45 PM #31550
Bellul
ParticipantHi!
I have created a custom post type and three custom taxonomies. I am no going to create a new field group.
I have several text fields etc, but I am also thinking to use three multiple choice fields for the three custom taxonomies. Should I choose Taxonomy field och Taxonomy Advanced field? Does my choice have anything to do with my custom table?
Where are these fields data saved, if I choose the first or the second type? Do any of these two fields save the data in the custom table? In your documenmtation you say about Taxonomy field that "This field does not save any value in the database"?? Where is it saved? About the Taxonomy Advanced field you say: "store terms’ IDs in the post meta and doesn’t set post terms". I don't understand these two explanations. Can you further explain this and especially how they relates to custom tables (is anything saved there?)?
October 28, 2021 at 9:24 AM #31565Long Nguyen
ModeratorHi,
The field
taxonomysets the post terms, the value is saved to the tablewp_termsin the database.
The fieldtaxonomy_advancedsets the post meta, the value is saved to the tablewp_postmetain the database.
You can see more tables of WordPress here https://codex.wordpress.org/Database_DescriptionSo if you use the custom table to store field value, you should use the field
taxonomy_advanced.October 28, 2021 at 11:23 AM #31569ParticipantThanks!
But if I use taxonomy_advanced, the data is still not saved in my custom table (but in wp_postmeta)?
If I tick the option "Create table automatically" in "Edit Field Group", all fields will be TEXT. Can I then afterwards just use a database tool to change column types?
October 28, 2021 at 9:01 PM #31593ModeratorHi,
If you use the field
taxonomy_advanced, the field value is saved to the custom table as other fields. Please read more on the documentation https://docs.metabox.io/extensions/mb-custom-table/The data type
TEXTcan be used for most cases. If you want to change the data type later, you can access your database and change it or contact your hosting support to ask to change the data type. Please read more here https://www.w3schools.com/sql/sql_datatypes.aspOctober 28, 2021 at 9:29 PM #31595ParticipantThanks for clarifications!!
-
AuthorPosts
- You must be logged in to reply to this topic.