Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

For large CMS websites it's crucial for users to be able to find relevant content using Search page. Unfortunately in current implementation the actual page text (what's inside content blocks) isn't used during search which might result from page relevance indicator drop (in search results) to not even showing needed page.

Solution

  1. add new "l1_PageContent" column to the "PageRevisions" table
  2. collect text only (remove all HTML markup) from all page content blocks (on content block add/edit/delete) - the "PageContent.l1_Content" column
  3. put it into newly added "PageRevisions.l1_PageContent" column
  4. add new setting to "Configuration > Website > Search" page to represent relevance (in search results) for "PageRevisions.l1_PageContent" of currently approved page revision

In above plan all columns that name start with "l1_" are multilingual columns and separate column is created for each language.

Related Tasks

Jira Legacy
serverSystem Jira
serverId513b375f-8291-3313-9d9f-704c39b1f915
keyINP-1744