Difference between revisions of "AskPlus 8.4.3"
>Johno (Created page with "=== AskPlus E.8.4.3 - Beta === The AskPlus E.8.4.3 beta version was released in November 2017. '''Highlights:''' :The AskPlus selection has been modified to support the conc...") |
>Johno |
||
| Line 17: | Line 17: | ||
;* The OUTER keyword is required, and is not the default. | ;* The OUTER keyword is required, and is not the default. | ||
| − | Watch [video] sample. | + | Watch [https://vimeo.com/vitalsoft/askplusouterjoin video] sample. |
'''Instructions for Installing AskPlus:''' | '''Instructions for Installing AskPlus:''' | ||
:[[Installing AskPlus Version]] | :[[Installing AskPlus Version]] | ||
Revision as of 22:09, 22 December 2017
AskPlus E.8.4.3 - Beta
The AskPlus E.8.4.3 beta version was released in November 2017.
Highlights:
- The AskPlus selection has been modified to support the concept of an OUTER join. When using the selection OUTER keyword, AskPlus will no longer drop any primary set records when no secondary set records are retrieved.
Selection Syntax Using Outer:
FIND PRIMARY=LOAN-FILE;OUTSEL=(@) OUTER (LOAN-FILE.BALANCE > 0 AND LOAN-FILE.REST-FLAG-11 <> 80 AND LOAN-FILE.SUFFIX = VEHICLE-INFO.SUFFIX)
- In previous versions of AskPlus, only loans with matching VEHICLE-INFO records would be selected
- In E.8.4.3 when using the OUTER keyword, all open loans with a balance greater than zero will be selected.
- Vehicle information will be available for loans with a matching suffix, but no loans will be dropped if no vehicle-info record is found.
- The OUTER keyword is required, and is not the default.
Watch video sample.
Instructions for Installing AskPlus:
