Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

Hi,

This is a complex problem, I would say for sure don't put the values in the rules directly. 

I would think a possible way would be to include the excel spreadsheet in the XOM  and using the POI java library (for example) to search in the excel file directly in java or B2X. 

My 2 cents

------------------------------
Alain Robert

Original Message:
Sent: Fri August 29, 2025 10:45 AM
From: Ali B
Subject: Validation on 15millions string values against given value

Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

------------------------------
Ali B
------------------------------

Thank you so much @Alain Robert for your quick response, Sure will use POI java library.

------------------------------
Ali B

Original Message:
Sent: Fri August 29, 2025 11:22 AM
From: Alain Robert
Subject: Validation on 15millions string values against given value

Hi,

This is a complex problem, I would say for sure don't put the values in the rules directly. 

I would think a possible way would be to include the excel spreadsheet in the XOM  and using the POI java library (for example) to search in the excel file directly in java or B2X. 

My 2 cents

------------------------------
Alain Robert

Original Message:
Sent: Fri August 29, 2025 10:45 AM
From: Ali B
Subject: Validation on 15millions string values against given value

Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

------------------------------
Ali B
------------------------------

Hi,

What you want to expose explicitly in the rules is what you want the business analysts to see or be able to change when business requirements change. Therefore of course you do not want to expose such huge lists in the rules and change the rules everytime there is a new employee. The BAL and editors have not been designed for that anyway.

As Alain wrote, you can maintain such lists in Excel and access them through POI as long as they are not too long. It is not going to work with 15 million records as Excel does not scale to that level, and you do not want to do a Java search against 15 million values in the ODM process.

A more scalable approach consists in exposing a verbalized REST/SQL method "belongs to list". This allows to pass contextual info, such as "country", "period", etc

Francis Friedlander

Thank you so much @Alain Robert for your quick response, Sure will use POI java library.

------------------------------
Ali B

Original Message:
Sent: Fri August 29, 2025 11:22 AM
From: Alain Robert
Subject: Validation on 15millions string values against given value

Hi,

This is a complex problem, I would say for sure don't put the values in the rules directly. 

I would think a possible way would be to include the excel spreadsheet in the XOM  and using the POI java library (for example) to search in the excel file directly in java or B2X. 

My 2 cents

------------------------------
Alain Robert

Original Message:
Sent: Fri August 29, 2025 10:45 AM
From: Ali B
Subject: Validation on 15millions string values against given value

Hi All,

Requesting to suggest the best approach to validate 15 million string values(employee ids) against given value.
Ex: if employee id of the employee is one of {"a1","a2","a3",................"a150k"}

      then set status of employee to Active.

Note: Given employee ids in excel sheet.

------------------------------
Ali B
------------------------------