Search categories?

[patmaddox]

I want to view a list of ports in ports-mgmt, ordered by most recently updated. Is there a way to do that? The closest I’ve found is “under a pathname” which looks like it returns commits rather than port information.

[dlangille]

We have https://www.freshports.org/ports-mgmt/

But you can't search that.

[dlangille]

This search query comes to mind: site:www.freshports.org/net-mgmt/ - use it on DuckDuckGo or Google, for example.

[dlangille]

The technical side is straight forward. I'm having trouble coming up with the user interface.

select * from ports where name ilike '%search_string%' and category = 'foo'

[patmaddox]

Searching within a category would be cool, and is above and beyond what I was thinking.

I had in mind a “category” option in the main search drop down list. My use case is wanting to list all ports in a category, ordered by when last updated.

So..l maybe you want to add sort links on the category page, or some way of searching categories.

but for my purposes, adding “category” to the drop-down list on search page does the job.

[grahamperrin]

Drive-by comment (without giving real thought):

https://www.freshports.org/ports-mgmt/ add Sort by

[dlangille]

Drive-by comment (without giving real thought):

https://www.freshports.org/ports-mgmt/ add Sort by

Right now, it's sorted by portname. What other options are useful?

[dlangille]

but for my purposes, adding “category” to the drop-down list on search page does the job.

I have changes underway for #447 which affect search already.

I'll either commit them and work on this, or do them both at the same time. We shall see.

[patmaddox]

Right now, it's sorted by portname. What other options are useful?

I would like to be able to sort by created, and updated.

[dlangille]

First draft of search by category. Not widely tested. There are probably some combinations which are illogical.

I can search for my commits in a given category, for example.

EDIT: I notice that my solution is valid only for physical categories, not virtual categories. I'll work on the latter.

EDIT: now working for virtual categories.

[dlangille]

For me, later. This will be used to update the cached list of categories, so that each load of search.php does not query for the last of categories.

freshports.devgit=# select '            <OPTION VALUE="' || name || '" <?php if ($category == ''' || name || ''') echo ''SELECTED''?>>' || name || '</OPTION>' from categories order by name;
                                                                ?column?                                                                 
-----------------------------------------------------------------------------------------------------------------------------------------
                 <OPTION VALUE="accessibility" <?php if ($category == 'accessibility') echo 'SELECTED'?>>accessibility</OPTION>
                 <OPTION VALUE="afterstep" <?php if ($category == 'afterstep') echo 'SELECTED'?>>afterstep</OPTION>
                 <OPTION VALUE="arabic" <?php if ($category == 'arabic') echo 'SELECTED'?>>arabic</OPTION>
                 <OPTION VALUE="archivers" <?php if ($category == 'archivers') echo 'SELECTED'?>>archivers</OPTION>
,,,

[patmaddox]

I must be dense - how do I view ports-mgmt ports ordered by updated at?

[patmaddox]

Perhaps this is a clue on the search page:

The list of categories is not available - the cache file does not exist - This should never happen.

[dlangille]

@patmaddox This is fixed in dev and test. stage has always been updated but not yet tested. Same with prod.

[dlangille]

Perhaps this is a clue on the search page:

The list of categories is not available - the cache file does not exist - This should never happen.

This is what I mean by 'fixed' in my previous comment.

[patmaddox]

Cool, I’m now able to view all ports in a category sorted by last updated by searching for (space) in the description - thank you!!

[dlangille]

Cool, I’m now able to view all ports in a category sorted by last updated by searching for (space) in the description - thank you!!

A proper sort within category will be carried out under #490