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
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?
