Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confiforms building SQL with JOIN

Andrzej
Contributor
April 4, 2025

Hello,

I have a quick question regarding building Confiforms dropdown fields using an SQL statement.

My SQL is joining two tables and it's correctly working in MS SQL, but when I add the same code to the database dropdown field, I'm getting an error. Can you tell me whether such connections are allowed in Confiforms?

Thank you in advance.

Error: Reason: The SELECT permission was denied on the object 'EmployeeRate', database 'CAPTOOL', schema 'dbo'.

 

 

EmployeeRate - it's the second table in my SQL join

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Alex Medved _ConfiForms_
Community Champion
April 4, 2025

Hi @Andrzej 

I believe this is something you should check with your database administrator to see if the user used to connect ConfiForms to the database has enough permissions to access the mentioned tables and the schema

Alex

Andrzej
Contributor
April 7, 2025

Hello Alex,

Ok, I will check the confiform user. Good point, thank you.

TAGS
AUG Leaders

Atlassian Community Events