Changes between Version 3 and Version 4 of AdvancedTopics

Timestamp:

06/15/26 00:24:15 (29 hours ago)

Author:

231141

Comment:

--

AdvancedTopics

@@ -280 +280 @@
 }}}
 
+= Worker Recommendation for Task Requests =
+
+Besides recommending task requests to workers, the system also supports recommending suitable workers for a specific task request.
+
+The function compares the embedding of the selected task request with the stored worker profile embeddings and ranks the workers according to their vector similarity. Workers who have already submitted an offer for the given task request are excluded from the results.
+
+{{{#!sql
+CREATE OR REPLACE FUNCTION
+recommend_workers_for_task_request
+(
+    p_task_request_id BIGINT,
+    p_limit INT DEFAULT 20
+)
+RETURNS TABLE
+(
+    worker_id BIGINT,
+    distance DOUBLE PRECISION,
+    recommendation_type TEXT
+)
+LANGUAGE plpgsql
+AS
+$$
+BEGIN
+    RETURN QUERY
+    SELECT
+        wrp.worker_id::BIGINT,
+        tre.embedding
+        <=>
+        wrp.preference_embedding
+        AS distance,
+        'PERSONALIZED'::TEXT
+    FROM task_request_embeddings tre
+    JOIN worker_recommendation_profiles wrp
+        ON wrp.preference_embedding IS NOT NULL
+    WHERE
+        tre.task_request_id = p_task_request_id
+        AND wrp.worker_id NOT IN
+        (
+            SELECT
+                o.worker_id
+            FROM Offer o
+            WHERE
+                o.task_request_id = p_task_request_id
+        )
+    ORDER BY
+        distance ASC
+    LIMIT
+        p_limit;
+END;
+$$;
+}}}
+
+{{{#!sql
+SELECT *
+FROM recommend_workers_for_task_request(150, 20);
+}}}
+
+The query returns the 20 workers whose previous completed tasks are the most semantically similar to the selected task request.