Ticket #49 (closed defect: fixed)

Opened 6 years ago

Last modified 15 months ago

Wantedpages action: alphabetical sorting needed

Reported by: dartar Owned by: DotMG
Priority: low Milestone: 1.3.1
Component: actions Version: 1.1.6.0
Severity: normal Keywords:
Cc:

Description (last modified by DotMG) (diff)

The list of Wantedpages may be handy, but I just found the list is not sorted alphabetically, making it hard to scan. That's a "UI bug". The list should be sorted, at least - and preferably split up by starting letters, as in PageIndex (when all pages are shown).


Fixed [243]

Change History

Changed 6 years ago by dartar

  • milestone changed from 1.1.6.1 to 1.1.6.2

Changed 6 years ago by ChrisH

Rather than rewrite the wantedpages action to sort alphabetically, how about adding some parameters so that it can be set up in various ways? IE:

- Sort Alphabetically - sort by frequency, then alphabetically - sort by date - oldest or newest first (how you would do this, I don't know) - show refering pages

or any combination there of.

Alphabetically will be nice to help me identify instances where I've made two links to a non-existant page that are similar, but not exact, when I really wanted them to be exact - IE, SmithBob and SmithBobby.

But that doesn't help identify the pages I made those links on in the first place. As my page count tops 100, it's getting hard to find those instances.

Changed 6 years ago by DarTar

  • milestone changed from 1.1.6.2 to 1.1.6.3

moving to 1.1.6.3 to take into account ChrisH's suggestion.

Changed 6 years ago by DotMG

  • owner changed from unassigned to DotMG
  • status changed from new to assigned
	function LoadWantedPagesEx($sort='count desc, time desc, tag')
	{
		return $this->LoadAll('
 		select distinct _LINKS.to_tag as tag,
			count(_LINKS.from_tag) as count,
			max(_PAGES2.time) as time
			from '.$this->config['table_prefix'].'links _LINKS left join '.$this->config['table_prefix'].
 		'pages _PAGES on _LINKS.to_tag = _PAGES.tag 
			INNER JOIN '.$this->config['table_prefix'].'pages _PAGES2 ON _LINKS.from_tag = _PAGES2.tag
			where _PAGES.tag is NULL 
			and _PAGES2.latest = \'Y\'
			group by tag order by '.$sort);
	}

Changed 5 years ago by DotMG

  • status changed from assigned to closed
  • resolution set to fixed
  • description modified (diff)

Changed 3 years ago by DarTar

  • milestone changed from 1.2 to 1.3

Retargeting to 1.3, this ticket has already been closed in trunk, from which 1.3 will be branched. Consider backporting urgent issues to 1.2.X

Changed 15 months ago by BrianKoontz

  • milestone changed from 1.3 to 1.3.1

Changed milestone to 1.3.1

Note: See TracTickets for help on using tickets.