We're updating the issue view to help you get more done. 

Easy to fix ambiguous reference error in Export_Tabs stored procedure

Description

This one is very easy to solve. It is an unresolved/ambiguous reference to an object.

Where it says "ORDER BY TabID" it should say "ORDER BY t.TabID"
Thanks

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 CREATE PROCEDURE [dbo].[Export_Tabs] @PortalID int, @IncludeDeleted bit, @IncludeSystem bit, @ToDate datetime, @FromDate datetime=NULL AS BEGIN DECLARE @Now datetime = GETDATE() SELECT DISTINCT t.TabID, IsNull(t.ParentId, -1) AS ParentId, t.IsSystem, t.IsDeleted FROM dbo.Tabs t LEFT JOIN dbo.TabModules AS tm ON t.TabID = tm.TabID WHERE PortalID = @PortalID AND IsSystem = @IncludeSystem AND (@IncludeDeleted = 1 OR t.IsDeleted = 0) AND ( (COALESCE(t.LastModifiedOnDate, t.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(t.LastModifiedOnDate, t.CreatedOnDate) >= @FromDate)) OR (COALESCE(tm.LastModifiedOnDate, tm.CreatedOnDate, @Now) <= @ToDate AND (@FromDate IS NULL OR ISNULL(tm.LastModifiedOnDate, tm.CreatedOnDate) >= @FromDate)) ) ORDER BY *{color:red} TabID -- THIS IS AMBIGUOUS. PLEASE CHANGE IT TO t.TABID{color}* END GO

QA Test Plan

None

Status

Assignee

Unassigned

Reporter

Horacio Judeikin

Story Size

XS

Severity

Minor

Triage

Triaged

Reported in Build #

Fixed in Build

None

Dev Owner

Nimroz Maknojia

Includes Code Fix

Yes

Documentation Required

None

Trouble Ticket

None

Requires More Info

None

Journal URL

None

QA Story Points

None

QA Owner

Mahalakshmi A

Injected

None

Automation Required

None

Code Review Owner

Kan Ma

Story Points

1

Time tracking

0m

Epic Link

Components

Sprint

None

Fix versions

Affects versions

9.0.2
9.0.1
Platform 9.1.0
Platform 9.0.1
Platform 9.1.1
Platform 9.0.0

Priority

Low