We released an update to the Stonefield Query SDK version 3.3 today. It has the following new features:
- In the Field Properties dialog, the Summary option has a new choice: Count Distinct. The difference between Count and Count Distinct is that Count counts the number of records while Count Distinct counts the number of records having unique values on this field. For example, if there are 100 order records but all orders were placed this week, using Count on the Order Date field would display 100 but Count Distinct would display 7 (assuming at least one order was placed every day this week). Also, the Summary option is now available for all field types, not just numeric fields.
- The Display date as option in the Field Properties dialog has a new choice: Hour, which displays the hour portion of the datetime value.
- If you use a date or datetime field in the X-axis, missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
- The Chart Type page in Step 4 of the Chart Wizard has a new Summary report option, which is turned on by default. Turn this option off if, instead of displaying summarized values, you want individual values charted.
- The Formula Editor has a new Send formula to database engine option that allows you to specify whether the database engine evaluates the formula or whether Stonefield Query requests any fields used in the formula from the database engine and then evaluates the formula itself.
- If you use an existing formula in a new formula, the existing formula is no longer expanded to show its definition in the new formula; instead, just its name appears, as it did when you created the new formula. For example, suppose a formula called Total Price is Unit Price * Quantity. If you create another formula called Commission, which is Total Price * 0.05, the formula displays as Total Price * 0.05 rather than Unit Price * Quantity * 0.05 as it used to in previous versions.
- Cross-tab reports have a new "Show percentage of total" option.
- Blank column headings now appear as "(None)" in cross-tab reports.
- In a multiple database report, if the query for one database fails for a reason other than a connection problem, the report continues to run if the Continue multi-database report if cannot connect to one database setting in the Options dialog is turned on.
- Stonefield Query now supports the syntax for outer joins used by older versions of Oracle, such as SELECT SomeFields FROM SomeTable, SomeOtherTable WHERE SomeTable.SomeField = SomeOtherTable.SomeField (+).
- You can now specify that a database login dialog should appear when the Configuration Utility connects to the database by adding DispLogins=2 to a [Settings] section in SFQEDITOR.INI (if that file doesn't exist, create it).