Filter edit query based on group user is in (Dynamic Permissions)

Ok I figured it out myself for anyone else that may need to know.
I did an inner join on groups than a left outer join on users. Then in events before SQL query added this:
$usercheck = $_SESSION["UserID"];

$strWhereClause = whereAdd($strWhereClause,"alert_ugmembers.UserName='".$usercheck."'");
Query on table:
SELECT

idBridge,

BridgeName,

SendWordNowUserID,

UserAssigned,

BridgeSecurityGroup,

GroupAssigned

FROM oncallbridgenames

INNER JOIN acualerts_uggroups ON oncallbridgenames.GroupAssigned = acualerts_uggroups .GroupID

LEFT OUTER JOIN alert_ugmembers ON alert_uggroups.GroupID = alert_ugmembers.GroupID

Well I spoke a little two soon.. My query may be bad but I think i'm in the right direction.

Nope query was good <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=85290&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> I was looking at something wrong. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=85290&image=2&table=forumreplies' class='bbc_emoticon' alt=':)' />

I thought I saw this same question recently . dejavu.

Try

After Successful login event put $_SESSION["Examplefldgroup"] = $data["Examplefldgroup"]; // you need to assign groups in dynamic permission to each user.

Then in dynamic security phprunner . Make user can see but only edit their own data or they can only see their own data.

Then in default field on the tablefield your are using for group put in default value: $_SESSIon["Examplefldgroup"];
That's it . When a user logs in he will be only able to edit his own records but see others or you can make it he only sees his records, that groups 2 and 5.

If he belongs to 2 or 5 he will only see records 2 and 5 . same for 1 or 2 or etc......; no need for all those inner joins.
The only thing I see is you are using the name filter . Are you using the filter panel to do this? Instead of an event when entering edit page?

Yes I'm using filtering panel along with the the custom query. It's working.
I think your way won't allow someone else to edit the list if they are in the same group. I want everyon in a group to edit the list they are in.