IBM Support

Properties with a logical type of MULTIPLE LINE STRING cannot be searched using Visual Query in the IBM i2 Analyze Information Store

Troubleshooting


Problem

Using i2 Analyst's Notebook Premium connected to i2 Analyze with the Information Store, it is not possible to search a MULTIPLE LINE STRING field using the Visual Query function. Quick Search on a string that is in the MULTIPLE LINE STRING will return results. However, attempting to use the Visual Query will not allow you to use that field as a condition to search on.

Symptom

Using an Event entity that has a MULTIPLE LINE STRING field for Event Description and Operation Details.









Create an Event with two MULTIPLE LINE STRING fields and upload it to the Information Store.



Quick Search works fine...



But Visual Query does not allow selection of the MULTIPLE LINE STRING property fields... they are absent.

No Event Description to select...



No Operation Details to select...


Cause

The knowledge center lists which logical types are supported by the different Visual Query operators:

Configuring Visual Query > Visual Query condition restrictions > Operators

Resolving The Problem

You cannot use MULTIPLE LINE STRING logical types in Visual Query conditions.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVTH","label":"i2 Analyze"},"ARM Category":[{"code":"a8m500000008ZIrAAM","label":"i2 Enterprise Insight Analysis->i2 Analyze->Query"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1.x;4.2.x;4.3.x","Line of Business":{"code":"LOB24","label":"Security Software"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXVMQ","label":"i2 Analyst's Notebook Premium"},"ARM Category":[{"code":"a8m500000008ZIcAAM","label":"i2 Analyst's Notebook and other i2 software->i2 Analyst's Notebook Premium->Query"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.1.0;9.2.0;9.2.1;9.2.2","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Product Synonym

i2A
EIA
Enterprise Insight Analysis

Document Information

More support for:
i2 Analyze

Component:
i2 Enterprise Insight Analysis->i2 Analyze->Query

Software version:
4.1.x, 4.2.x, 4.3.x

Operating system(s):
Linux, Windows

Document number:
570363

Modified date:
28 July 2020

UID

swg22016009