Saturday, October 20, 2007

Version 3.2 Features (Definite)

Stonefield Query Version 3.2 is in the planning stages. There are hundreds and hundreds of features we could add, however, we can't add them all.

We've narrowed down the list and broken them into 3 categories: small (1-4 days), medium (1-2 weeks), and large (> 2 weeks).

This list includes the "definite" features for the next release. See the next blog entry for a list of features still on the chopping block.

Target release date: 03/31/2008

Large (More than 2 weeks)

• “Negative” queries. (ie. Show me a list of customers that did not have any orders last year)

• Multiple detail bands. (ie. Give me a complete view of a company's activities, history, forecasted sales, and invoices.)

• Join dialog so user can change joins without changing SQL statement (ie. “include records even if no records” changes join to RIGHT OUTER). This is only done if negative query is just another join choice. Options would include: contacts who have activities, contacts whether they have activities or not, activities whether they have contacts or not, contacts with no activities with specified filter (ie. in date range), activities with no contacts with specified filter

Medium (1 – 2 weeks)

• Excel data-only output for cross-tabs

• Templates control default page size and orientation

• More information in Setup Dialog e.g. email information

• Advanced button in Label and Cross-Tab Wizard (e.g. gain access to customize SQL and top n)

• Support VFP 9 SP2 features, including rotation, dynamics, advanced page, etc.

Small (1 – 4 days)

• Test Syntax button on Expression Builder (Done)

• Default table for each data group (Done)

• Option to pass “ignore this value” for ask-at-runtime conditions on command line (Done)

• SQApplication.DataEngine.GetValuesForField support default values and Ignore this Condition option (Done)

• Deleting folder deletes all reports in that folder

• Option to turn on/off point labels for all series

• Import reports from REPORTS.DBF (another option in Import dialog)

• Option to export all reports from a folder or just selected reports. Change “Export Report” to “Export Selected Report” and “Export All Reports” to “Export Reports...” which brings up a dialog with choices for selected report, all reports, and a TreeView of all reports with checkboxes (selecting a folder selects all reports in that folder)

• Display proper page number when group resets to page 1

• Options to not create label for new field and to not auto-size field in Advanced Report Designer

• Don’t check user count or name when run from command line or schedule or else can’t run report when already logged into UI

• Dialog to edit properties for a folder (ie. security)

• Option for which databases a user can access in Maintain Users and Groups dialog

• Encrypt connection user ID and password in error log and error report

• Display Date Only setting in Advanced Report Designer: enables user to turn this off if turned on in data dictionary

• Save “database” selection in filter page if “use next time” checked for all users (currently doesn’t work for runtime)

• If user cancels in GetValuesForField dialog called from Select script, don’t give “no records match” error

• Workstation-only installer (generic name so no branding issues) or no workstation installation at all (ie. all runtime files in program folder)

• Option to put all fields in same table in one line of group header

• Implement new features in TeeChart 8

Please send us your feedback on these features. We want to know if these are the things you want in Query.