Configuring a Query by Example

Without some mechanism to restrict the results displayed to those that you want the information displayed is not very useful.

The Query by Example (QBE) provides that mechanism by giving you a dynamic display control, so you can restrict the result set to, from our example, only Government contacts - or whatever.

To get started you need to add a Query by Example to the Config section, and call it QBE: Category

Having added the QBE, right-click and open in a new tab to configure it.

Open the Text Surface, and add a Field embed, and then edit it to configure the General tab options.

You must give it a unique Parameter name - starting with a lowercase letter. It is helpful to give it a context appropriate name. We are using picker.

We are going to want to have a Check Box List as the way to select records. Next, set the Allowed values to be set to the Table Category previously created, with e Value set to Record Id and the Text to Category Name.

Then add a Submit Button to the Text Surface, and give it some Button text, and save.

When you are done, the QBE Text Surface will look like this:

Now we can go to the public pages and embed the necessary components so that the results will come to view on demand.

Go to the 'First Page in Section 4', and Edit the page.

Embed the 'Query By Example'.

And then below it, embed the Query Q: Category View with the Output set to CV: Category View.

Edit the properties of the QBE and ensure it is set to use the  correct Query and to Trigger on Form Submit.

Next, edit the properties of Query you embedded, set to use the CV Category View.

In the records tab, set the Criteria to Restrict All Records on Filed Category Id, where the Operator is Equal to the Value of a Parameter Parent with an explicit value of picker (the name we gave the QBE Parameter name previously).

Page height/throbber

Load empty

 NEXT - on to Full Stack - Design hints

---