Export citation:


  • Views: 450
  • Aggregate Downloads: 14



DI*22.2*10001: Variable Pointer navigation incorrectly returns empty results
Please use this identifier to cite or link to this publication:
Submitted by Samuel Habiel on 04-09-2018.
# Introduction
Variable Pointer navigation incorrectly returns empty results.

# Detailed Description
INC0105488 in yourIT

## Problem
Users who query Fileman for data can be given missing results if the query
contains a variable pointer relational navigation reference. This is the case
in a frequently queried field, the OBJECT OF ORDER field in the ORDER file. For
example, setting a condition of OBJECT OF ORDER:PATIENT:AGE30 will fail to
retrieve patients above 30 years of age if a. another patient with the same
name exists or b. the patient's name is not unique within the first 30
characters. If the results of such a report are used clinically, it will lead
to at least not printing data on patients; or at worst completely missing
them since they were not printed on the report--something which could have some
clinical significance to the health of the patients.

This bug fix provides the code to ensure that variable pointer relational
navigation references are properly implemented in the Fileman computed
expression parser.

## Resolution
Computed pointer resolvers in DICOMP0 previously didn't handle variable
pointers; instead it treated them the same as join extended pointer syntax
(value in a:file b:field in b) - see
for more information. Now the V tag creates DICOMP code specifically for
variable pointers.

## Options Affected
Any sort or print operation in Fileman.

Reviews (Phase: Complete)

Peer review by Joe Snyder:

Topic Completed
Compliant - Product Build Checklist
Compliant - Installation and Post-Installation
Functional - Before Patch Installation
Functional - Installation and Post-Installation
Safe - Installation and Post-Installation

Final review by Joe Snyder:

Topic Level Comments
Name/Number Space
Open Source License
Code Review
Test Installation
Regression Testing
Functional Testing
Recommended Certification Level4



Powered by Midas