cancel
Showing results for 
Search instead for 
Did you mean: 

Visual Composer Query

Former Member
0 Kudos

I have already created a system and am able to successfully pull data from the sql database source. However, I have a query that I want to plug in to restrict the recordset. Can somebody tell me how I can do this?

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Thank You. All I see is the tables within Visual Composer when I choose "Get Data". If understand you, I have to first have a stored procedure in SQL server that I then call from Visual Compoer? I do I view the stored procedures in Visual Composer?

Thank You!

Former Member
0 Kudos

That is correct. Also you need to give the account of the user that you are using to map from portal to the datasource the permission to view or execute that stored procedure.

Former Member
0 Kudos

Hi Kevin,

You have to restrict it in your query yourself and not in the visual composer

Regards

kurt