How does the 25 Related label picked in a page
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
How does the 25 Related label picked in a page?
Based on below's code:
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
select
distinct label,
count(labelling2.label)
from
Label as label,
Labelling as labelling1,
Labelling as labelling2,
SpaceContentEntityObject as sceo,
Space as space
where
labelling1.label.id = :labelID and
labelling1.content = labelling2.content and
labelling2.label.id != :labelID and
labelling2.content = sceo and
sceo.space = space and
lower(space.key) = :spaceKey and
labelling2.label = label and
label.namespace = 'global'
group by
labelling2.label,
label,
label.namespace,
label.name,
label.owningUser,
label.creationDate,
label.lastModificationDate
order by
count(labelling2.label) descIt's based on the number of occurrences of the following:
The other label's shared content
The other label's shared spaces
Example:
LabelA is on the same page with LabelB (count the amount of pages that this happens, higher = higher in the list)
LabelA is on the same space as LabelB (count the amount of spaces that thishappens, higher = higher in the list)
Was this helpful?