Difference between revisions of "AskPlus 8.4.3"

From Vital Soft Wiki
Jump to: navigation, search
>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
 
(2 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
The AskPlus E.8.4.3 beta version was released in November 2017.
 
The AskPlus E.8.4.3 beta version was released in November 2017.
  
'''Highlights:'''
+
{{AskPlus E.8.4.3}}
: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:'''
 
:[[Installing AskPlus Version]]
 

Latest revision as of 21:11, 2 February 2018

AskPlus E.8.4.3 - Beta

The AskPlus E.8.4.3 beta version was released in November 2017.

Enhancements:

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.