quick question about the table content Topic is solved

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
pra75020
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Jan 20, 2022 12:43 pm

quick question about the table content

Post by pra75020 » Wed Jan 26, 2022 11:54 am

Hello

i would like to understand / know what is the fulltext field of the content table used for ?
i ask this because the whole body of my article is in introtext field

thank you for your help

for info on postgresql :

Code: Select all

                                           Table "public.blogpra_content"
      Column      |            Type             | Collation | Nullable |                   Default                   
------------------+-----------------------------+-----------+----------+---------------------------------------------
 id               | integer                     |           | not null | nextval('blogpra_content_id_seq'::regclass)
 asset_id         | bigint                      |           | not null | 0
 title            | character varying(255)      |           | not null | ''::character varying
 alias            | character varying(255)      |           | not null | ''::character varying
 introtext        | text                        |           | not null | 
 fulltext         | text                        |           | not null | 
 state            | smallint                    |           | not null | 0
 catid            | bigint                      |           | not null | 0
 created          | timestamp without time zone |           | not null | 
 created_by       | bigint                      |           | not null | 0
 created_by_alias | character varying(255)      |           | not null | ''::character varying
 modified         | timestamp without time zone |           | not null | 
 modified_by      | bigint                      |           | not null | 0
 checked_out      | integer                     |           |          | 
 checked_out_time | timestamp without time zone |           |          | 
 publish_up       | timestamp without time zone |           |          | 
 publish_down     | timestamp without time zone |           |          | 
 images           | text                        |           | not null | 
 urls             | text                        |           | not null | 
 attribs          | character varying(5120)     |           | not null | 
 version          | bigint                      |           | not null | 1
 ordering         | bigint                      |           | not null | 0
 metakey          | text                        |           |          | 
 metadesc         | text                        |           | not null | 
 access           | bigint                      |           | not null | 0
 hits             | bigint                      |           | not null | 0
 metadata         | text                        |           | not null | 
 featured         | smallint                    |           | not null | 0
 language         | character varying(7)        |           | not null | ''::character varying
 note             | character varying(255)      |           | not null | ''::character varying
Indexes:
    "blogpra_content_pkey" PRIMARY KEY, btree (id)
    "blogpra_content_idx_access" btree (access)
    "blogpra_content_idx_alias" btree (alias)
    "blogpra_content_idx_catid" btree (catid)
    "blogpra_content_idx_checkout" btree (checked_out)
    "blogpra_content_idx_createdby" btree (created_by)
    "blogpra_content_idx_featured_catid" btree (featured, catid)
    "blogpra_content_idx_language" btree (language)
    "blogpra_content_idx_state" btree (state)

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 12473
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: quick question about the table content

Post by brian » Wed Jan 26, 2022 12:31 pm

If you split your content using the readmore functionality then only the first part of the content is stored in the introtext field
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

pra75020
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Thu Jan 20, 2022 12:43 pm

Re: quick question about the table content

Post by pra75020 » Thu Jan 27, 2022 6:26 am

Oh ok thank you very much thus i don t use this functionality
i take a look
thank you very much
have a good day


Post Reply

Return to “General Questions/New to Joomla! 4.x”