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...



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
Was this topic helpful?
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