pjs.tableLookup()

This API finds an element in a table array and positions the table to that element.

An optional resulting indicators object can specify if any elements in the flags array should be set. The resulting indicators object can have these properties:

equal (Number) - identifies the flag number to set if an exact match is found
low (Number) - identifies the flag number to set if the nearest lower entry is found
high (Number) - identifies the flag number to set if the nearest higher entry is found

Parameters

Search argument
Table array
Alternate table array OR resulting indicators object (optional)
resulting indicators object (optional)
Search type (optional) - String value of "LE", "LT", "GE", or "GT" can specify a less than or equal to, a less than, a greater than or equal to, or a greater than search instead of an exact match search

Examples

Example 1

  pjs.define("tab1", { type: 'char', length: 2, dim: 5, table: true, initValue: [ '01', '02', '03', '04', '05' ] });
  pjs.define("output", { type: 'char', length: 52, varying: true });

  if (pjs.tableLookup('02', tab1)) {
    pjs.clear(tab1);
    output = 'Cleared. ';

    if (pjs.tableLookup('03', tab1)) {
      output += 'Other entries still there.';
    }
  }

Example 2

  pjs.define("var1", { type: 'decimal', length: 2, decimals: 0, initValue: 4 });
  pjs.define("var2", { type: 'decimal', length: 2, decimals: 0, initValue: 20 });
  pjs.define("tabsearch", { type: 'decimal', length: 2, decimals: 0, dim: 10, table: true, initValue: [ 0, 2, 4, 6, 8, 10, 12, 14, 16, 18 ] });
 
  pjs.tableLookup(var1, tabsearch, { equal: 71 });
  pjs.tableLookup(var2, tabsearch, { equal: 72 });
 
  if (flags[71] && !flags[72]) {
    //var1 value found, var2 value not found
  }

Example 3

pjs.define("var1", { type: 'decimal', length: 2, decimals: 0, initValue: 4 });
pjs.define("tabsearch", { 
  type: 'decimal',
  length: 2,
  decimals: 0,
  dim: 10,
  table: true,
  orderby: 'ASCEND', initValue: [ 0, 2, 4, 6, 8, 10, 12, 14, 16, 18 ] 
});

pjs.tableLookup(var1, tabsearch, { equal: 66 });
console.log(pjs.equal());

RPG Equivalent

%TLOOKUP()