Question

Hyperlink on dashboard list

Hi Community,

 

What's the rule of displaying hyperlinks on the list type of dashboard? 

Sometimes the name (text field) is displayed as a hyperlink and lookups as a text value without hyperlink on the dashboard...

 

BR Paulina

Like 0

Like

2 comments

Dear  Paulina,



Actually the theory was correct - the lookup value is not a clickable link since the object of the lookup (AccountAddress) is not a section in the system. The value is clickable in case the object of the lookup is present in the Terrasoft.configuration.ModuleStructure object and this object values are being generated when login to the app as a result of this select query execution:



exec sp_executesql N'

SELECT

    [SysModule].[Id] [ModuleId],

    [SysModule].[Image32Id] [ImageId],

    [SysModule].[LogoId] [LogoId],

    [SysModule].[Code] [Module],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

    [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModule].[SectionModuleSchemaUId]) [SectionModule],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

Hello Paulina,

 

 [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModule].[SectionSchemaUId]) [SectionSchema],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

    [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModule].[CardModuleUId]) [CardModule],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

    [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModule].[CardSchemaUId]) [CardSchema],

    [SysModule].[Attribute] [Attribute],

    [SysModule].[TypeColumnValue] [ModuleTypeColumnValue],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

    [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModuleEdit].[CardSchemaUId]) [CardSchemaPage],

    (

SELECT

    [Name]

FROM

    [dbo].[VwSysClientUnitSchema] WITH(NOLOCK)

WHERE

    [SysWorkspaceId] = @SysWorkspaceId

    AND [UId] = [SysModuleEdit].[MiniPageSchemaUId]) [MiniPageSchema],

    [SysModuleEdit].[Id] [ModuleEditId],

    [SysModuleEdit].[ActionKindName] [ActionName],

    [SysModuleEdit].[TypeColumnValue] [TypeColumnValue],

    [SysModuleEntity].[SysEntitySchemaUId] [SysEntitySchemaUId],

    [SysModuleVisa].[VisaSchemaUId] [VisaSchemaUId],

    [SysModuleInWorkplace].[SysWorkplaceId] [ShowInWorkplace],

    [SysModule].[Caption] [ModuleCaption],

    [SysModule].[ModuleHeader] [ModuleHeader],

    [SysModuleEdit].[ActionKindCaption] [ActionCaption],

    [SysModuleEdit].[PageCaption] [PageCaption],

    [SysModuleLcz].[Caption] [ModuleCaptionLcz],

    [SysModuleLcz].[ModuleHeader] [ModuleHeaderLcz],

    [SysModuleEditLcz].[ActionKindCaption] [ActionCaptionLcz],

    [SysModuleEditLcz].[PageCaption] [PageCaptionLcz]

FROM

    [dbo].[SysModule] WITH(NOLOCK)

    LEFT OUTER JOIN [dbo].[SysModuleInWorkplace] WITH(NOLOCK) ON ([SysModuleInWorkplace].[SysModuleId] = [SysModule].[Id]

    AND [SysModuleInWorkplace].[SysWorkplaceId] = @P1)

    LEFT OUTER JOIN [dbo].[SysModuleEdit] WITH(NOLOCK) ON ([SysModuleEdit].[SysModuleEntityId] = [SysModule].[SysModuleEntityId])

    LEFT OUTER JOIN [dbo].[SysModuleEntity] WITH(NOLOCK) ON ([SysModuleEntity].[Id] = [SysModuleEdit].[SysModuleEntityId])

    LEFT OUTER JOIN [dbo].[SysModuleVisa] WITH(NOLOCK) ON ([SysModuleVisa].[Id] = [SysModule].[SysModuleVisaId])

    LEFT OUTER JOIN [dbo].[SysModuleLcz] WITH(NOLOCK) ON ([SysModuleLcz].[RecordId] = [SysModule].[Id]

    AND [SysModuleLcz].[SysCultureId] = @P2)

    LEFT OUTER JOIN [dbo].[SysModuleEditLcz] WITH(NOLOCK) ON ([SysModuleEditLcz].[RecordId] = [SysModuleEdit].[Id]

    AND [SysModuleEditLcz].[SysCultureId] = @P3)

WHERE

    NOT [SysModule].[SectionModuleSchemaUId] IS NULL

    AND NOT [SysModule].[SysModuleEntityId] IN (

SELECT

    [SysModuleEntityId]

FROM

    [dbo].[SysModuleEntityInPortal] WITH(NOLOCK))

ORDER BY

    [SysModuleInWorkplace].[Position] ASC,

    [SysModuleEdit].[Position] ASC',N'@SysWorkspaceId uniqueidentifier,@P1 uniqueidentifier,@P2 uniqueidentifier,@P3 uniqueidentifier',@SysWorkspaceId='2746F94F-8E5B-469A-AC1E-AAF90920BB36',@P1='79770671-CDE2-4C0F-9078-A4FF68703DEF',@P2='1A778E3F-0A8E-E111-84A3-00155D054C03',@P3='1A778E3F-0A8E-E111-84A3-00155D054C03'



The main table here from which the data is selected is SysModule and this table stores data on all the system sections. AccountAddress object is not present in the SysModule table since there is no section for "Account address".

 

Best regards,

Bogdan

Thanks, Bogdan but it's not exactly my issue. 

See attached picture. Both dashboards are created based on the same object (Opportunity product) and for one of them column Opportunity is a text value and for the second one, there is a link. I don't know why...  Some kind of bug on our env?

Show all comments