Tersus: Re: how to search or filter in all of the filed in wizard table

Re: how to search or filter in all of the filed in wizard tableDate: Nov 12, 2012Tags:Table WizardThe filtering option in the Table Wizard can be any of the following values, each of which affects both the <Header>'s From and To rows, and the generated SQL SELECT's WHERE clause.

Exact - The database field's value exacly matches the value entered
Allow input in From row
Add a Field = From condition to the WHERE cluase

Starts with - The database field's value starts with the value eneterd
Allow input in From row
Add a Field LIKE 'From%' condition to the WHERE cluase

Contains - The database field's value contains the value entered
Allow input in From row
Add a Field LIKE '%From%' condition to the WHERE cluase

Range - The database field's value is between the two values entered
Allow input in From & To rows
Add a Field >= From AND Field <= To condition to the WHERE cluase

Nothing - No filtering, and therefore no input in either rows, and no condition added to WHERE clause.

I join Stefen's suggestion - try out the tutorial @ http://www.tersus.com/#Id=6344, which demonstrates this.If you've tried this and it's not working as expected, you're welcome to create a demo, export it to a .tersus file (File>Export>Tersus>Tersus Export File) and attach it to a forum post.Regarding a search popup ... well it's actually up to you, once the table wizard is done, it creates a model which you can change and add to as you wish. Just remember that extensive changes to the model will prevent the Apply Table Wizad option (available when right-clicking the root model created by the Table Wizard), from working - but will in no way prevent you from performing manual changes to the model.Regards,DavidSee Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...