Difference between revisions of "AskPlus 8.4.3"

From Vital Soft Wiki
Jump to: navigation, search
>Kevint
>Johno
 
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 [https://vimeo.com/vitalsoft/askplusouterjoin video] sample.
 
 
 
'''Instructions for Installing AskPlus Beta:'''
 
:[[Installing AskPlus Beta 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.