If anyone can shed some light on the difference between "In literal list" versus "Equal to" when filtering on fields in InfoAssist I would appreciate the insight. Thanks.This message has been edited. Last edited by: Tamra,
7.6.10, Windows HTML, Excel, PDF
March 07, 2016, 03:13 PM
BabakNYC
Jim: Is your WF version 7.6?
WHERE CAR.ORIGIN.COUNTRY IN ( 'ENGLAND' , 'FRANCE', 'JAPAN' );
is a shorter way of saying
WHERE CAR.ORIGIN.COUNTRY EQ 'ENGLAND' OR 'FRANCE' OR 'JAPAN';
The effect is the same.
WebFOCUS 8206, Unix, Windows
March 07, 2016, 04:54 PM
Waz
The efficiency is very much determined by the data source and how it handles the filter.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
March 11, 2016, 07:30 AM
Tamra
Jim,
Welcome to the Information Builders Community Forum - where developers help developers!
I hope the responses were helpful. Let us know if you have any further questions.
The subject line will be updated to [SOLVED]. In the future we ask that the subject line be updated once the topic has a sufficient answer. The words entered can be found at Tag your topic with keywords under Forum Guidelines.
Thank you for participating in the Focal Point Forum.