Performing Search on In-memory Tables Yields Incorrect Results

Last Updated:26/June/2018

Affected products

• MotionBoard (for Dr.Sum EA) Ver. 5.6.00.0000 to 5.6.00.0005
• MotionBoard (for Dr.Sum EA) Ver. 5.7.00.0000 to 5.7.00.0020
• MotionBoard for Dr.Sum Ver. 5.7.00.0000 to 5.7.00.0020

Summary

There are 2 cases wherein this issue occurs:

Case 1: When all of the following conditions are met, not all search results are returned.

• Data Source: In-memory Table
• Join Condition: And/Or
• Comparison Condition: Equals/Equals any of
• Searchable Items: More than 255 Items

Case 2: When all the conditions are met, unrelated items are included in the search result.

• Data Source: In-memory Table
• Join Condition: And/Or
• Comparison Condition: Does not equal/Does not equal any of

Resolution

For MotionBoard Ver.5.7, the fix has been released on 29th of June, 2018 (version 5.7.00.0030). Please contact us for instructions on how to download the patch.

For the other versions of MotionBoard, the patch will be released in the coming days.