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

Status

Assignee

Unassigned

Reporter

Horacio Judeikin

Story Size

XS

Severity

Minor

Triage

Triaged

Reported in Build #

9.1.1

Dev Owner

Nimroz Maknojia

Includes Code Fix

Yes

QA Owner

Mahalakshmi A

Code Review Owner

Kan Ma

Story point estimate

1

Time estimate

0m

Epic Link

Components

Sprint

None

Fix versions

Affects versions

Platform 9.0.1
Platform 9.0.0
Platform 9.1.0
9.0.1
9.0.2
Platform 9.1.1

Priority

Low