Difference between revisions of "AskPlus 8.4.3"

From Vital Soft Wiki
Jump to: navigation, search
>Johno
>Kevint
Line 19: Line 19:
 
Watch [https://vimeo.com/vitalsoft/askplusouterjoin video] sample.
 
Watch [https://vimeo.com/vitalsoft/askplusouterjoin video] sample.
  
'''Instructions for Installing AskPlus:'''
+
'''Instructions for Installing AskPlus Beta:'''
:[[Installing AskPlus Version]]
+
:[[Installing AskPlus Beta Version]]

Revision as of 20:05, 12 January 2018

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 Beta:

Installing AskPlus Beta Version