Databases
StackOverflow2013
Postsdbo
POHow do you add fields to com_content in Joomla! with a plugin and store the data in its own table?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do you add fields to com_content in Joomla! with a plugin and store the data in its own table?
    text
    copied!<p>I'm running Joomla 1.7 and I know that it has the ability to add custom form fields to components with a plugin.</p> <p>There is a sample plugin located at: /plugins/user/profile</p> <p>This plugin allows you to put custom form fields on the user profile front end and back end and these fields are stored in a custom table.</p> <p>I created a similar plugin for user profiles and it worked perfectly.</p> <p>However, when I go to create a plugin like this for com_content, I am met with a problem.</p> <p>this is what my XML file looks like:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;form&gt; &lt;fields name="additionalinfo"&gt; &lt;fieldset name="additionalinfo_fieldset" label="PLG_CONTENT_ADDITIONALINFO_FIELDSET_LABEL"&gt; &lt;field name="tagline" type="text" size="50" default="" label="PLG_CONTENT_ADDITIONALINFO_TAGLINE_LABEL" description="PLG_CONTENT_ADDITIONALINFO_TAGLINE_DESC" /&gt; &lt;field name="pseudocategory" type="category" extension="com_content" label="PLG_CONTENT_ADDITIONALINFO_PSEUDOCATEGORY_FIELD_LABEL" description="PLG_CONTENT_ADDITIONALINFO_PSEUDOCATEGORY_FIELD_DESC" /&gt; &lt;/fieldset&gt; &lt;/fields&gt; &lt;/form&gt; </code></pre> <p>This however does not work, whenever I do something like above, the form fields never show up on the admin form (even though I have it set correctly, and the only thing that changed between the user plugin and the content plugin is the name of the form i'd like the form to appear on</p> <p>When I change my XML to this:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;form&gt; &lt;fields name="attribs"&gt; &lt;fieldset name="additionalinfo_fieldset" label="PLG_CONTENT_ADDITIONALINFO_FIELDSET_LABEL"&gt; &lt;field name="tagline" type="text" size="50" default="" label="PLG_CONTENT_ADDITIONALINFO_TAGLINE_LABEL" description="PLG_CONTENT_ADDITIONALINFO_TAGLINE_DESC" /&gt; &lt;field name="pseudocategory" type="category" extension="com_content" label="PLG_CONTENT_ADDITIONALINFO_PSEUDOCATEGORY_FIELD_LABEL" description="PLG_CONTENT_ADDITIONALINFO_PSEUDOCATEGORY_FIELD_DESC" /&gt; &lt;/fieldset&gt; &lt;/fields&gt; &lt;/form&gt; </code></pre> <p>When I make this simple change, the form fields show up! BUT, the data isn't stored or retrieved from the custom table, it just goes into the 'attribs' column on the _content table. This stores the content in JSON, which is alright, but we'd like to be able to index the content by the custom fields (and not have to loop through each record in the database to find what we're looking for).</p> <p>Any ideas on how to fix this?</p> <p>thanks!</p> <p>david barratt</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload