You can create your own custom Select dialog to replace the standard Create Select Statement dialog that opens when clicking Select. In the QvFacebookConnector example, a custom Select dialog has been implemented and the button showing in the Script Editor has been labeled Metadata.
- In your class extending QvxServer, override the method public override string CustomCaption to activate your custom button and set its name.
In the same class, override the method public override string CreateSelectStatement(). The only requirement is that this method returns a script (for example, “SQL SELECT * FROM friends;”). In the QvFacebookConnector example, a dialog is launched. In the dialog, table selections can be made and then the dialog returns a script that is, in turn, returned to QlikView.
The following code example is taken from the file QvFacebookServer.cs in the QvFacebookConnector example: