# Authenticator Module having QB stmt with JOIN using relation

**URL:** <https://forum.servoy.com/t/authenticator-module-having-qb-stmt-with-join-using-relation/19224>\
**Category:** Classic Servoy\
**Created:** [April 20, 2017, 9:02am UTC](https://forum.servoy.com/t/authenticator-module-having-qb-stmt-with-join-using-relation/19224 "2017-04-20T09:02:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![huber](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/huber/32/5042_2.png) [@huber](https://forum.servoy.com/u/huber)\
**Post date:** [April 20, 2017, 9:02am UTC](https://forum.servoy.com/t/authenticator-module-having-qb-stmt-with-join-using-relation/19224/1 "2017-04-20T09:02:47Z")

</div>

In the Authenticator Module, having a QB statement with a JOIN using a relation like

```auto
var join1 = query.joins.add('persons_classified_by_persons_access_right_groups', 'parg');

```

leds to an error message:

```auto
Cannot find relation 'persons_classified_by_persons_access_right_groups'

```

So I assume this is because the code in the Authenticator Module can’t access the applications relations for security reasons. Is this assumption correct?

Thanks and regards,

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [April 20, 2017, 9:15am UTC](https://forum.servoy.com/t/authenticator-module-having-qb-stmt-with-join-using-relation/19224/2 "2017-04-20T09:15:39Z")

</div>

No, I think that should work. The whole point about the separation of login solution and authenticator is that the authenticator can do these things while login cannot. Is the module that holds this relation available to the authenticator (added as a module)?

---

<div class="post-metadata">

**Author:** ![huber](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/huber/32/5042_2.png) [@huber](https://forum.servoy.com/u/huber)\
**Post date:** [April 20, 2017, 1:34pm UTC](https://forum.servoy.com/t/authenticator-module-having-qb-stmt-with-join-using-relation/19224/3 "2017-04-20T13:34:54Z")

</div>

That’s the point, the Authenticator module did not see the relation ![:oops:]( "Embarassed")

Thanks and regards,