To add an XtractQL object to the ERPConnect Services Designer, select the button with the plus (+) symbol next to XtractQLs. Specify a name for the Method and enter the XQL Statement. Select the Execute button for a preview of the data.
Select OK to confirm your entries. Save the ECS Designer file (.ecs) to initiate the code generation in the background. The generated code will be in a file named .Designer.cs (or .vb) and can be viewed in the Visual Studio editore in a file named .Designer.cs (or .vb) and can be viewed in the Visual Studio editor.
The following sample code illustrates how the XtractQL object can be used with a return table:
Click to open C# example.
When displayed in a Web Part, the results would look as shown below.
Please refer to the section XtractQL to find more samples and a complete syntax reference.