Authenticator Module having QB stmt with JOIN using relation

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Authenticator Module having QB stmt with JOIN using relation

Postby huber » Thu Apr 20, 2017 11:02 am

In the Authenticator Module, having a QB statement with a JOIN using a relation like
Code: Select all
var join1 = query.joins.add('persons_classified_by_persons_access_right_groups', 'parg');

leds to an error message:
Code: Select all
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,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 518
Joined: Mon May 14, 2012 11:31 pm

Re: Authenticator Module having QB stmt with JOIN using rela

Postby patrick » Thu Apr 20, 2017 11:15 am

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)?
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany

Re: Authenticator Module having QB stmt with JOIN using rela

Postby huber » Thu Apr 20, 2017 3:34 pm

That's the point, the Authenticator module did not see the relation :oops:

Thanks and regards,
Robert Huber
7r AG, Switzerland
SAN Developer
http://www.seven-r.ch
User avatar
huber
 
Posts: 518
Joined: Mon May 14, 2012 11:31 pm


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 13 guests