Bug: Wrong access type on list channels by group id

[arvindh123]

What were you trying to achieve?

List channels by group id, i.e listing channels of a group with access_type=direct

What are the expected results?

List of channels which are having direct relation to group

What are the received results?

In result, I got channels which are indirect relation to group

Steps To Reproduce

• Create channel1
• Create group 1, group2 , group3, group4
• Make group2 children of group1, group3 as children of group2, group4 as children of group3
• Add channel1 as parent of group4
• List channels of group1 with access_type=direct in query params like below given request

curl --location 'http://localhost/<channel_1_id>/channels?group=<group_1_id>&access_type=direct' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer <TOKEN>' \

In what environment did you encounter the issue?

Docker

Additional information you deem important

No response

[felixgateru]

From the above image when we list channels of group 4 with user1 we get the following result:

{
    "limit": 10,
    "offset": 0,
    "total": 6,
    "channels": [
        {
            "id": "16efe93c-df92-4b40-81f7-7673e9e1806c",
            "name": "Channel1",
            "parent_group_id": "44d60dd1-6cee-4679-8bf9-58ae4912e1e8",
            "access_type": "direct",
        },
        {
            "id": "56d65929-49bc-4b90-84d2-2a0ae54c0eb7",
            "name": "Channel2",
            "parent_group_id": "44d60dd1-6cee-4679-8bf9-58ae4912e1e8",
            "access_type": "direct_group",
        },
        {
            "id": "3eb28d9f-ea54-4cd1-bdbc-1cc10510bd14",
            "name": "Channel3",
            "parent_group_id": "98edb9c9-a071-4284-b9e5-42bb01b4cd0f",
            "access_type": "indirect_group",
        },
        {
            "id": "3eb28d9f-ea54-4cd1-bdbc-1cc10510bd14",
            "name": "Channel3",
            "parent_group_id": "98edb9c9-a071-4284-b9e5-42bb01b4cd0f",
            "access_type": "indirect_group",
        },
        {
            "id": "3eb28d9f-ea54-4cd1-bdbc-1cc10510bd14",
            "name": "Channel3",
            "parent_group_id": "98edb9c9-a071-4284-b9e5-42bb01b4cd0f",
            "access_type": "indirect_group",
        },
        {
            "id": "3eb28d9f-ea54-4cd1-bdbc-1cc10510bd14",
            "name": "Channel3",
            "parent_group_id": "98edb9c9-a071-4284-b9e5-42bb01b4cd0f",
            "access_type": "indirect_group",
        }
    ]
}

*Some fields ommited

The above looks like the desired behavior with the only issue being the duplication of channel3 but this is highlighted in this issue:
#2865

[dborovcanin]

@arvindh123 Please check and close if this has been resolved.

[arvindh123]

#2855 (comment)
This comments explain the scenario, Closing this ticket