Home› Analyst Portal
Options

Dashboard Query works in IE but not in Chrome

Lorenz_BennLorenz_Benn Partner IT Monkey ✭
in Analyst Portal

Hey Guys,


I am trying to setup a dashboard sql table widget query.

This query worked before but I joined a new table and added two new properties to select

It works perfectly in Internet Explorer 11 but not in chrome.


Any help would be appreciated

Query and error message below



QUERY:

SELECT HWA.Name_8B938849_A621_7754_D33B_BD8E54DC10B4 AS 'Asset Name',

CI.DisplayName as 'Model', --NEW

CI.Price_163E27AE_3091_EFFF_AA64_13A971CCD00A as 'Price in €', --NEW

HWA.SerialNumber_C8CF2E89_7A83_1C26_0AD0_887DF9140D5A as Serialnumber,

HWStatus.EnumName as 'Status',

AssetLocation.LocationCity as 'Asset City', 

AssetLocation.LocationStreet as 'Asset Location',

PrimaryUsers.PrimaryUserName as 'Primary User',

CostCenters.CostCenter as 'CostCenter'

FROM dbo.MT_Cireson$AssetManagement$HardwareAsset HWA

JOIN dbo.Relationship RS ON

HWA.BaseManagedEntityID = RS.SourceEntityID 

JOIN dbo.MT_System$Domain$User DU ON

RS.TargetEntityID = DU.BaseManagedEntityID

LEFT JOIN

(

SELECT 

SourceEntityId as AssetId,

TargetEntityId as LocationId,

LocationTable.LocationAddress1_100069FC_35B7_24F2_0CC5_B53FAC0B4A91 as LocationStreet,

LocationTable.LocationCity_C33B0E69_3E11_BB14_5130_9C5BDCDF43F6 as LocationCity

FROM [ServiceManager].[dbo].[Relationship] as RelShip 

INNER JOIN [ServiceManager].[dbo].[RelationshipType] as RelShipType 

ON RelShip.RelationshipTypeId = RelShipType.RelationshipTypeId

LEFT JOIN [dbo].[MT_Cireson$AssetManagement$Location] as LocationTable

ON RelShip.TargetEntityId = LocationTable.BaseManagedEntityId

WHERE 

RelshipType.RelationshipTypeName = 'Cireson.AssetManagement.HardwareAssetHasLocation'

) as AssetLocation

ON AssetLocation.AssetId = HWA.BaseManagedEntityId

LEFT JOIN (

SELECT 

SourceEntityId as AssetId,

TargetEntityId as UserId,

UserTable.DisplayName as PrimaryUserName

FROM [ServiceManager].[dbo].[Relationship] as RelShip 

INNER JOIN [ServiceManager].[dbo].[RelationshipType] as RelShipType 

ON RelShip.RelationshipTypeId = RelShipType.RelationshipTypeId

LEFT JOIN [dbo].[MT_System$Domain$User] as UserTable

ON RelShip.TargetEntityId = UserTable.BaseManagedEntityId

WHERE 

RelshipType.RelationshipTypeName = 'Cireson.AssetManagement.HardwareAssetHasPrimaryUser'

) as PrimaryUsers

ON PrimaryUsers.AssetID = HWA.BaseManagedEntityId

LEFT JOIN

(

SELECT 

SourceEntityId as AssetId,

TargetEntityId as CCID,

CCTable.DisplayName as CostCenter

FROM [ServiceManager].[dbo].[Relationship] as RelShip 

INNER JOIN [ServiceManager].[dbo].[RelationshipType] as RelShipType 

ON RelShip.RelationshipTypeId = RelShipType.RelationshipTypeId

LEFT JOIN dbo.MT_Cireson$AssetManagement$CostCenter as CCTable

ON RelShip.TargetEntityId = CCTable.BaseManagedEntityId

WHERE 

RelshipType.RelationshipTypeName = 'Cireson.AssetManagement.HardwareAssetHasCostCenter'

)as CostCenters

ON CostCenters.AssetId = HWA.BaseManagedEntityId

Left JOIN dbo.EnumNames as Models

ON HWA.HardwareAssetType_07E9CFB0_049C_855E_D6CA_135808C8B964 = Models.EnumTypeId

LEFT JOIN dbo.EnumNames as HWStatus

ON HWA.HardwareAssetStatus_3019ADDF_4F3D_2C55_2024_72C22E11F4CF = HWStatus.EnumTypeId

LEFT JOIN dbo.MT_Cireson$AssetManagement$CatalogItem as CI --NEW

ON HWA.ModelEnum_1A5CE615_58C0_B30A_535E_D6FAD298AD50 = CI.Model_3E995B7A_B660_BE56_6962_F6598D9C787C --NEW

WHERE RS.RelationshipTypeId = 

(

Select RelationshipTypeID FROM dbo.RelationshipType WHERE RelationshipTypeName = 'System.ConfigItemOwnedByUser'

)

AND DU.BaseManagedEntityId=@USERID


ERROR FROM CHROME

angular.js:11655 Error: Invalid template:'<tr data-uid="#=data.uid#" role='row'><td class="grid-highlight-column#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETNAME'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETNAME'] ? '<span class="k-dirty"></span>' : '' #<a href='/Search/RedirectToWorkItem'>#= (ASSETNAME) ? ASSETNAME : '' #</a></td><td class="grid-highlight-column#= data && data.dirty && data.dirtyFields && data.dirtyFields['MODEL'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['MODEL'] ? '<span class="k-dirty"></span>' : '' #<a href='/Search/RedirectToWorkItem'>#= (MODEL) ? MODEL : '' #</a></td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['PRICEIN€'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['PRICEIN€'] ? '<span class="k-dirty"></span>' : '' ##= (PRICEIN€) ? PRICEIN€ : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['SERIALNUMBER'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['SERIALNUMBER'] ? '<span class="k-dirty"></span>' : '' ##= (SERIALNUMBER) ? SERIALNUMBER : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['STATUS'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['STATUS'] ? '<span class="k-dirty"></span>' : '' ##= (STATUS) ? STATUS : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETCITY'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETCITY'] ? '<span class="k-dirty"></span>' : '' ##= (ASSETCITY) ? ASSETCITY : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETLOCATION'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETLOCATION'] ? '<span class="k-dirty"></span>' : '' ##= (ASSETLOCATION) ? ASSETLOCATION : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['PRIMARYUSER'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['PRIMARYUSER'] ? '<span class="k-dirty"></span>' : '' ##= (PRIMARYUSER) ? PRIMARYUSER : '' #</td><td class="#= data && data.dirty && data.dirtyFields && data.dirtyFields['COSTCENTER'] ? ' k-dirty-cell' : '' #" role='gridcell'>#= data && data.dirty && data.dirtyFields && data.dirtyFields['COSTCENTER'] ? '<span class="k-dirty"></span>' : '' ##= (COSTCENTER) ? COSTCENTER : '' #</td></tr>' Generated code:'var $kendoOutput, $kendoHtmlEncode = kendo.htmlEncode;with(data){$kendoOutput='<tr data-uid="'+(data.uid)+'" role=\'row\'><td class="grid-highlight-column'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETNAME'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETNAME'] ? '<span class="k-dirty"></span>' : '' )+'<a href=\'/Search/RedirectToWorkItem\'>'+( (ASSETNAME) ? ASSETNAME : '' )+'</a></td><td class="grid-highlight-column'+( data && data.dirty && data.dirtyFields && data.dirtyFields['MODEL'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['MODEL'] ? '<span class="k-dirty"></span>' : '' )+'<a href=\'/Search/RedirectToWorkItem\'>'+( (MODEL) ? MODEL : '' )+'</a></td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['PRICEIN€'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['PRICEIN€'] ? '<span class="k-dirty"></span>' : '' )+''+( (PRICEIN€) ? PRICEIN€ : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['SERIALNUMBER'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['SERIALNUMBER'] ? '<span class="k-dirty"></span>' : '' )+''+( (SERIALNUMBER) ? SERIALNUMBER : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['STATUS'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['STATUS'] ? '<span class="k-dirty"></span>' : '' )+''+( (STATUS) ? STATUS : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETCITY'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETCITY'] ? '<span class="k-dirty"></span>' : '' )+''+( (ASSETCITY) ? ASSETCITY : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETLOCATION'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['ASSETLOCATION'] ? '<span class="k-dirty"></span>' : '' )+''+( (ASSETLOCATION) ? ASSETLOCATION : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['PRIMARYUSER'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['PRIMARYUSER'] ? '<span class="k-dirty"></span>' : '' )+''+( (PRIMARYUSER) ? PRIMARYUSER : '' )+'</td><td class="'+( data && data.dirty && data.dirtyFields && data.dirtyFields['COSTCENTER'] ? ' k-dirty-cell' : '' )+'" role=\'gridcell\'>'+( data && data.dirty && data.dirtyFields && data.dirtyFields['COSTCENTER'] ? '<span class="k-dirty"></span>' : '' )+''+( (COSTCENTER) ? COSTCENTER : '' )+'</td></tr>';}return $kendoOutput;'

    at Object.compile (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:25:7804)

    at Object.i [as template] (https://it-support.formeld.com/Scripts/kendo/2018.1.117/jquery.min.js?v=8100:2:104075)

    at init._tmpl (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:54:5705)

    at init._templates (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:54:7919)

    at new init (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:51:24876)

    at HTMLDivElement.<anonymous> (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:26:4691)

    at Function.each (https://it-support.formeld.com/Scripts/kendo/2018.1.117/jquery.min.js?v=8100:2:3111)

    at w.fn.init.each (https://it-support.formeld.com/Scripts/kendo/2018.1.117/jquery.min.js?v=8100:2:1475)

    at w.fn.init.e.fn.<computed> [as kendoGrid] (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:26:4668)

    at v (https://it-support.formeld.com/Scripts/kendo/2018.1.117/kendo.all.min.js:99:25275) <div adf-grid-state-id="{{vm.gridStateId}}" kendo-grid="grid" k-options="vm.gridOptions" k-rebind="vm.gridOptions" k-on-change="vm.onGridRowClick(kendoEvent)" k-on-column-reorder="vm.onColumnChange(kendoEvent)" k-on-column-show="vm.onColumnChange(kendoEvent)" k-on-column-hide="vm.onColumnChange(kendoEvent)" k-on-sort="vm.onColumnChange(kendoEvent)" k-on-filter="vm.onColumnChange(kendoEvent)" class="ng-scope k-grid k-widget k-display-block k-reorderable" data-role="grid" style="">

(anonymous) @ angular.js:11655

Best Answer

  • Options
    Lorenz_BennLorenz_Benn Partner IT Monkey ✭
    Answer ✓

    Solved.....

    apparently :

    Select Stuff as "something with €"


    does not work, as long as it contains the € character ...

    But only in Chrome, IE works perfectly. Didn't test any other browser

Answers

  • Options
    Lorenz_BennLorenz_Benn Partner IT Monkey ✭
    Answer ✓

    Solved.....

    apparently :

    Select Stuff as "something with €"


    does not work, as long as it contains the € character ...

    But only in Chrome, IE works perfectly. Didn't test any other browser

Sign In or Register to comment.