Add support to sort by match name

[ziodave]

• [x] The table _wl_entities must be extended so that we have the match_name column:

+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| content_id   | bigint(20) unsigned | NO   | MUL | NULL    |                |
| content_type | tinyint(1) unsigned | NO   |     | NULL    |                |
| rel_uri      | varchar(500)        | NO   |     | NULL    |                |
| rel_uri_hash | char(40)            | NO   | UNI | NULL    |                |
| jsonld_hash  | char(40)            | YES  |     | NULL    |                |
| synced_gmt   | char(19)            | YES  |     | NULL    |                |
| about_jsonld | text                | YES  |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+

• [x] When WordLift installs, we need to update the existing records where about_jsonld is NOT null, so that we extract the match_name and set it in the column, ex extraction function:

    private function get_match_name( $jsonld ) {
        $data = json_decode( $jsonld, true );
        if ( ! $data || ! array_key_exists( 'name', $data ) ) {
            return null;
        }

        return $data['name'];
    }

• [x] When the about_jsonld column is set, then we also want to set the match_name, see src/classes/content/wordpress/class-abstract-wordpress-content-service.php, function public function set_about_jsonld( $content_id, $value )

• [x] Then you can use it for sorting

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.