BPC-Components

Home > Products > BPC SQL Query Builder Web Part

BPC SQL Query Builder Web Part

SQL Queries for SharePoint lists and document libraries. 

BPC SQL Query Builder is a SharePoint web part that provides automatic generation of ready-to-run sql queries for Sharepoint custom lists and document libraries. The resulting query can be used by custom applications for fast Sharepoint data retrieval, or in various reporting engines (such as SQL Server Reporting Services).

The generator supports automatic joining of related lists (lookups) for showing both name and ID values, multi-lookup information concatenated into a single row (multiple values are shown in comma-separated mode),“person or group” field types and generation of SQL queries for choice fields.

The web part has a built in Test Query feature so that you can check query results and make changes on the spot without the need to use your SQL Server tools.

 

 

  SQL Query Builder

 

  

Downloads

 

Multimedia

 

Help

 

Related

     Installation Guide

     Watch Product Videos

       Get Support

       BPC PowerForms

     EULA

     See Screenshots

       Licensing Information

       BPC Easy Timesheets