# Query Builder Confusion

**URL:** <https://forum.servoy.com/t/query-builder-confusion/20142>\
**Category:** Classic Servoy\
**Created:** [December 16, 2019, 6:35pm UTC](https://forum.servoy.com/t/query-builder-confusion/20142 "2019-12-16T18:35:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gordon\_McLean](https://avatars.discourse-cdn.com/v4/letter/g/839c29/32.png) [@Gordon\_McLean](https://forum.servoy.com/u/Gordon_McLean)\
**Post date:** [December 16, 2019, 6:35pm UTC](https://forum.servoy.com/t/query-builder-confusion/20142/1 "2019-12-16T18:35:25Z")

</div>

Hi  
Firstly I am new to Query Builder so apologies for what could be a super obvious issue.

I have a relatively simple SQL statement that I am trying to work into QB to lock my table data based on user access rights. The SQL clip works as in it returns the correct results but getting this from here to the tableFilterParam seems incredibly involved. Is there a better method ? I somehow imagined you would be able to do something like databaseManager.addTableFilterParam(qry) where qry is my working query ??

**SQL Clip**

```auto
SELECT ORG_Group_Org.ORG_ID
FROM USER_Group_Access
JOIN ORG_Group_Org ON USER_Group_Access.group_id = ORG_Group_Org.Group_id
WHERE USER_Group_Access.user_name = 'client'

```

**Query Builder**

```auto
var qry = datasources.db.dc.org_group_org.createSelect();
qry.where.add(qry.joins.user_group_access_to_or_group.columns.user_name.eq(scopes.svySecurity.active_user.user_name));	
	
var fs = datasources.db.dc.org_group_org.getFoundSet();
fs.loadRecords(qry);

var arr = []
for(var i=0;i<=fs.getSize();i++) {
	fs.setSelectedIndex(i)
	arr.push(fs.org_id)
}
	
var success = databaseManager.addTableFilterParam('dc','org','org_id','in',arr)
application.output(success)

```

---

<div class="post-metadata">

**Author:** ![kwpsd](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@kwpsd](https://forum.servoy.com/u/kwpsd)\
**Post date:** [December 17, 2019, 9:34pm UTC](https://forum.servoy.com/t/query-builder-confusion/20142/2 "2019-12-17T21:34:33Z")

</div>

Hi, Gordon.

It seems to me that you should add a result clause to your query, something like:

```auto
qry.result.add( qry.joins.user_group_access_to_or_group.columns.org_id )

```

and change the call to:

```auto
var success = databaseManager.addTableFilterParam( qry )

```

and, get rid of the array part. Caveat: I am supplying this code from memory, so it may not be exact. I hope this helps (and works)!

---

<div class="post-metadata">

**Author:** ![Gordon\_McLean](https://avatars.discourse-cdn.com/v4/letter/g/839c29/32.png) [@Gordon\_McLean](https://forum.servoy.com/u/Gordon_McLean)\
**Post date:** [December 17, 2019, 10:09pm UTC](https://forum.servoy.com/t/query-builder-confusion/20142/3 "2019-12-17T22:09:30Z")

</div>

Thank you I will try this it makes more sense than my attempt