sharing:list does not show circles shares and filter doesn't show public shares

Using Nextcloud 27.1.8 and Sharelisting 1.2.0.

When I run "occ sharing:list" I do not see any shares related to circles.
When I run "occ sharing:list -u username" to find any shares related to user, I just see direct share to/from this users, not public links generated by this user or related to files owned by this user.

So share:listing report misses a lot of relevant information!

Below a more complete example with command outputs.

• My user Admin_ShareA has folder called /Espai_ShareA shared with Circle_ShareA. There's a subfolder called "probando subcompartir", with a file called "asdfasdfasdf.md".
• User "gonzalo" is member of "Circle_ShareA". He shares asdfasdfasdf.md with user "gcc2", with circle "gonzalo_circle". All shares are configured, tested and work properly.

Getting all Admin_ShareA related shares should be as simple as # occ sharing:list -o csv -u Admin_ShareA, and it should show 4 results:

• Share of Admin_ShareA with Circle_ShareA
• Share of gonzalo with user gcc2
• Share of gonzalo with circle gonzalo_circle
• Share of gonzalo with public link

But when I run:

# occ sharing:list -o csv -u Admin_ShareA
id,file_id,owner,initiator,time,permissions,path,name,is_directory,type,recipient
206,72420,Admin_ShareA,gonzalo,2024-04-30T12:36:10+00:00,19,"/Espai_ShareA/probando subcompartir/asdfasdfasdf.md",asdfasdfasdf.md,0,user,gcc2

No public share, no circle shares.

I tried again without filtering by user but using grep:

# occ sharing:list -o csv | grep  Admin_ShareA
205,72420,Admin_ShareA,gonzalo,2024-04-30T12:30:07+00:00,1,"/Espai_ShareA/probando subcompartir/asdfasdfasdf.md",asdfasdfasdf.md,0,link,G2yRQeBqSiYtZmz,"2024-05-06 22:00:00",
206,72420,Admin_ShareA,gonzalo,2024-04-30T12:36:10+00:00,19,"/Espai_ShareA/probando subcompartir/asdfasdfasdf.md",asdfasdfasdf.md,0,user,,,gcc2

Now I see the public link but not the circles shares. Also, this method is not valid for my productions system as I need to generate multiples report for users that have multiples shared spaces, links...
(using CSV just to make it easier to parse, but Json has the same results).

Sharelisting command is exactly what I need as I want to generate reports for a group of users that are acting as Share-units and I want to audit the sharing activity on those files. But is not possible if it's missing that public and circle shares. Currently I'm using a workaround querying directly database but I really would like to use this tool.

Is it possible to fix this stuff, or I'm doing anything in a wrong way?

Start by reproducing the reported occ sharing:list -o csv -u Admin_ShareA and unfiltered CSV/JSON commands, then compare their results with the database workaround described in the issue. The work is done when user-filtered listings include the relevant public-link and circle shares, matching the expected four results in the example.