Use table alias, when creating calculated fields for catalog items

Components

Labels

None

Description

In the "\kCatDBEventHandler::prepareObject" method change this code:

$object->addCalculatedField('CachedNavbar', 'l' . $this->Application->GetVar('m_lang') . '_CachedNavbar');

into

$object->addCalculatedField('CachedNavbar', TABLE_PREFIX . 'Categories.l'.$this->Application->GetVar('m_lang') . '_CachedNavbar');

Context Information

None

Additional information (do not use)

None

Linked issues

is blocked by

INP-788

Automatically remove unused LEFT JOIN from list count database queries

Activity

Alex January 4, 2021 at 11:00 AM

alex closed D362: - Use table alias, when creating calculated fields for catalog items.
alex updated the diff for D362: - Use table alias, when creating calculated fields for catalog items.

Alex January 4, 2021 at 9:01 AM

alex added "INP-1765" JIRA issue(s) to rINP16659: Fixes - Use table alias, when creating calculated fields for catalog….

Alex January 4, 2021 at 9:01 AM

alex committed rINP16659: Fixes - Use table alias, when creating calculated fields for catalog….

Fixes - Use table alias, when creating calculated fields for catalog items

Differential Revision: http://qa.in-portal.org/D362

Alex January 4, 2021 at 9:00 AM

alex closed D362: - Use table alias, when creating calculated fields for catalog items.
alex updated the diff for D362: - Use table alias, when creating calculated fields for catalog items.

[API] Administrator January 4, 2021 at 9:00 AM

User committed a fix to 5.2.x. Commit Message:

Fixes - Use table alias, when creating calculated fields for catalog items

Differential Revision: http://qa.in-portal.org/D362

Fixed

Details
Priority
Minor
Assignee
Alex
Reporter
Alex
Developer
Alex
Reviewer
Erik S.
Change Log Group
Fixed
Change Log Message
Fixed SQL error, when searching in "Show All" mode in Admin Console's Catalog.
Patch Instructions
Patches must be submitted through Phabricator.
To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial.
To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial.
Time tracking
1h 30m logged
Story Points
1
Fix versions
5.2.2-B3

Created May 8, 2019 at 5:19 PM

Updated December 29, 2024 at 8:49 PM

Resolved January 4, 2021 at 9:00 AM