[GH] (texera/pin/4-search): Workflow run "Required Checks" is working again!

[GitBox <gi...@apache.org>]

The GitHub Actions job "Required Checks" on texera.git/pin/4-search has succeeded.
Run started by GitHub user yangzhang75 (triggered by yangzhang75).

Head commit for run:
02a567b4e117490e4d03b10c25c01c7d68bf530e / Yang Zhang <ya...@uci.edu>
feat(workflow): match search and listings against the copy on show

Search and the listings it feeds were reading the author's live columns,
which for a pinned workflow is the one copy the public cannot open. A
draft would turn up in a public search under a title nobody has seen, and
the card would advertise a name the detail page does not show.

Each filter is now applied to whichever copy the caller may see:
`onVisibleCopy` builds the same filter twice -- over the live columns for
rows the caller was granted access to, over the frozen ones for rows they
reach only because the workflow is public -- and ORs the two. A
disjunction over bare columns rather than a CASE, so each side stays
eligible for its own fulltext index. Unpinned public rows fall back to
the live columns, so a following workflow searches exactly as it does now.

Listings carry two more things from the same query: the frozen name and
description to show a viewer without granted access, and whether the copy
on show is behind the author's working copy. `constructWhereClause` takes
`includePublic` for this; the other builders accept and ignore it.

Co-Authored-By: Claude Opus 5 <no...@anthropic.com>

Report URL: https://github.com/apache/texera/actions/runs/37508090320

With regards,
GitHub Actions via GitBox