Using query editor on Sobiens Studio

This feature allows you to generate select, caml syntax to ease your query generation on your code. You can also use this to easily navigate between data on your environments. MS SharePoint lists and libraries, MS CRM entities and SQL tables can be used on this feature.

  1. Select your data source from object explorer. You can select one of the following MS SharePoint list and library, MS CRM entity and SQL table.
  2. Click "New Query" from ribbon bar
  3. This will open you three sections; Query criteria, query result, query syntax.
    a. Query criteria: Selecting output will display the field in the result. Sort Type and Sort Order will allow you sort the result. Filter part will allow you to filter the result.
    b. Query result: This section will display the result based on selections from Query criteria.
    c. Query Syntax: This section will display different syntax based on your datasource type (MS CRM, MS SharePoint, SQL Table).