IF i put those exact values into my .sql, i get the results i anticipate.

quote:

3001_TESTING.INPUT.@TRIGGERTYPENAME

@ Tom,

Do you want to explain or shall I?

T

Hi:

Either way, i canot get it to resolve

WHERE (3001_TESTING.INPUT.@TRIGGERTYPENAME IN (&TRIGGERTYPENAME.QUOTEDSTRING));

OR

WHERE (3001_TESTING.ANSWERSET1.TRIGGERTYPENAME IN (&TRIGGERTYPENAME.QUOTEDSTRING));

I'm sorry, i 'm new to this coming from a totally different background & this is anything but user friendly.

If i am asking stupid questions, i apologize

thank you

Nico, no reason to apologise, I just wanted to give Tom the opportunity to reply first

Take a step back and let's understand what you have currently.

Your synonym has been created against a stored procedure (or view?) for an SQL data source.

You are tabling against this synonym with specific columns being selected.

If you run the WebFOCUS code, it returns no records but running your procedure with the same values being passed you get results. Therefore there must be a difference between the SQL being passed from WebFOCUS and the SQL you run manually - so we need to see what WebFOCUS is passing.

Go back to Francis' earlier post about trapping the SQL from your report and then cut and paste this SQL as necessary to run it direct against your data source.

If you wish to, post the SQL produced and we'll see if there's anything that looks awry.

T

Thank you for your patience. My syn is based off a existing sql procedure that has been certifiedm, that i have to use. I am able to pass 1 value in and get results. However, i ONLY have 1 row in my test dbase that will show up in my repot. When i try to test multiple values, i get the error below. I do not have control of this data sadly.

I am able to pass this in as a parameter value in my .sql

.SQL
WHERE (TriggerTypeName in ('DeedInLieu', 'ForeclosureSale' ))



.FEX

Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


--------------------------------------------------------------------------------


CURRENTLY DEFINED & VARIABLES:
&&IBIBIPMS =
&&MAS_FULLINFO= Y
&ACCEPTS = 0
&APPPRIV = /binfs00/app/ibi/apps
&APPROOT = /binfs00/app/ibi/apps
&AROUTPUT = SET AROUTPUT=EXTJS
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 04/01/14
&DBMSERR = 0
&DELTD = 0
&DMY = 010414
&DMYY = 01042014
&DUPLS = 0
&ECHO = OFF
&EXCELSERVURL = SET EXCELSERVURL=http://vmbiapps06.dcsr.site:9080/ibi_apps
&FOCEXURL = /ibi_apps/WFServlet.ibfs?IBIF_webapp=/ibi_apps&IBIC_server=BI
&FOCFEXNAME = ADHOCRQ
&FOCFOCEXEC = _ADHOCRQ
&FOCGRAPHCNT = 0
&FOCHTMLURL = /ibi_apps/ibi_html/S56_13911305501F
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = M728007D
&FORMAT = 0
&GOOGLEMAPSAP>=
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 040114
&MDYY = 04012014
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&SETFILE =
&SORTIO = 0
&TOD = 10.34.05
&TRANS = 0
&TRIGGERTYPEN>= 'DeedInLieu' OR 'ForeclosureSale'
&TRIGGERTYPEN>= DeedInLieu, ForeclosureSale
&WFDESCRIBE = XMLPROMPT
&WF_TITLE = AdhocRequest
&YMD = 140401
&YYMD = 20140401
SET MSG=ON
-*** Set up SQL tracing
-*** Deactivate SQL tracing
SET TRACEOFF = ALL
-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL
-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS
-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT
-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT
-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT
-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT
-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF
-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 132
-*** Set trace to output file
SET TRACEUSER=C:\ibi\apps\baseapp\my_sql_trace.txt
-*** Activate SQL tracing
SET TRACEUSER = ON
-RUN
-SET &TRIGGERTYPENAME = STRREP (33, '''DeedInLieu'' OR ''ForeclosureSale''', 4, ' OR ', 2, ', ', 33, 'A33');
TABLE FILE CWS3001_QC_PERFORMANCE_DETAIL_TESTING
PRINT
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.INVESTOR
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMUSERNAME
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.SERVICERLOANNUMBER
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMLOGINID
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('DeedInLieu', 'ForeclosureSale' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/endeflt.sty
type=report,
color=rgb(66 70 73),
font='Trebuchet MS',
size=9,
squeeze=on,
grid=off,
$
type=pagenum,
style=italic,
size=6,
justify=right,
$
type=tabheading,
style=bold+italic,
size=14,
justify=center,
$
type=tabfooting,
style=bold+italic,
size=12,
justify=center,
border-top=heavy,
border-top-color=rgb(52 55 58),
$
type=heading,
style=bold,
size=12,
justify=center,
$
type=footing,
style=bold,
size=10,
justify=center,
$
type=title,
backcolor=rgb(102 102 102),
color=rgb(255 255 255),
style=-underline+bold,
$
type=data,
backcolor=(rgb(255 255 255) rgb(235 235 240)),
$
type=acrosstitle,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
size=9,
style=-underline+bold,
$
type=acrossvalue,
backcolor=rgb(218 225 232),
style=bold,
$
type=subhead,
size=10,
style=bold,border-top=heavy,
border-bottom=light,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subfoot,
size=10,
style=bold,
border-top=light,
border-bottom=medium,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subtotal,
backcolor=RGB(200 200 200),
style=bold,
border-top=light,
border-top-color=rgb(66 70 73),
$
type=grandtotal,
backcolor=rgb(66 70 73),
color=rgb(255 255 255),
style=bold,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(66 70 73),
border-top-style=solid,
border-bottom-style=double,
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
BACKCOLOR=RGB(200 200 200),
HOVER-BACKCOLOR=rgb(218 225 232),
$
TYPE=REPORT,
GRAPHCOLOR=green,
GRAPHCOLORNEG=red,
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=MENU,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
BORDER-COLOR=white,
HOVER-COLOR=rgb(66 70 73),
hover-backcolor=rgb(218 225 232),
$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(48,94,213));
setFillColor(getSeries(1),new Color(237,195,27));
setFillColor(getSeries(2),new Color(136,144,151));
setFillColor(getSeries(3),new Color(140,205,40));
setFillColor(getSeries(4),new Color(227,136,0) );
setFillColor(getSeries(5),new Color(40,190,205) );
setFillColor(getSeries(6),new Color(255,102,102) );
setFillColor(getSeries(7), new Color(71,186,143));
setFillColor(getSeries(8), new Color(187,90,71));
setFillColor(getSeries(9),new Color(190,107,211));
setFillColor(getSeries(10),new Color(16,122,22));
setFillColor(getSeries(11),new Color(108,149,200));
setFillColor(getSeries(12),new Color(169,109,205) );
setFillColor(getSeries(13),new Color(210,143,255) );
setFillColor(getSeries(14),new Color(60,49,36));
setFillColor(getSeries(15),new Color(78,43,37));
setFillColor(getSeries(16),new Color(95,38,37));
setFillColor(getSeries(17),new Color(19,23,162));
setFillColor(getSeries(18),new Color(66,70,73));
setFillColor(getSeries(19),new Color(19,23,162));
setFillColor(getSeries(20),new Color(66,70,73));
setFillColor(getSeries(21),new Color(191,218,170));
setFillColor(getSeries(22),new Color(0,0,128));
setFillColor(getSeries(23),new Color(163,211,208));
setFillColor(getSeries(24),new Color(158,213,243));
setFillColor(getSeries(25),new Color(179,151,191));
setFillColor(getSeries(26),new Color(200,158,193));
setFillColor(getSeries(27),new Color(240,171,196));
setFillColor(getSeries(28),new Color(242,171,168));
setFillColor(getSeries(29),new Color(230,121,88));
setFillColor(getSeries(30),new Color(240,159,97));
setFillColor(getSeries(31),new Color(248,191,106));
setFillColor(getSeries(32),new Color(255,239,121));
setFillColor(getSeries(33),new Color(195,218,125));
setFillColor(getSeries(34),new Color(0,0,255));
setFillColor(getSeries(35),new Color(0,255,0));
setFillColor(getSeries(36),new Color(255,0,255));
setFillColor(getSeries(37),new Color(255,255,0));
setFillColor(getSeries(38),new Color(255,0,0));
setFillColor(getSeries(39),new Color(255,200,0));
setFillColor(getSeries(40),new Color(255,175,175));
setFillColor(getSeries(41),new Color(0,255,255));
setFillColor(getSeries(42),new Color(206,0,54));
setFillColor(getSeries(43),new Color(255,239,0));
setFillColor(getSeries(44),new Color(0,152,82));
setFillColor(getSeries(45),new Color(0,174,227));
setFillColor(getSeries(46),new Color(42,19,109));
setFillColor(getSeries(47),new Color(206,0,121));
setFillColor(getSeries(48),new Color(243,169,136));
setFillColor(getSeries(49),new Color(248,190,145));
setFillColor(getSeries(50),new Color(253,211,154));
setFillColor(getSeries(51),new Color(255,243,172));
setFillColor(getSeries(52),new Color(217,229,171));
setFillColor(getSeries(53),new Color(191,218,170));
setFillColor(getSeries(54),new Color(165,208,169));
setFillColor(getSeries(55),new Color(163,211,208));
setFillColor(getSeries(56),new Color(158,213,243));
setFillColor(getSeries(57),new Color(179,151,191));
setFillColor(getSeries(58),new Color(200,158,193));
setFillColor(getSeries(59),new Color(240,171,196));
setFillColor(getSeries(60),new Color(242,171,168));
setFillColor(getSeries(61),new Color(230,121,88));
setFillColor(getSeries(62),new Color(240,159,97));
setFillColor(getSeries(63),new Color(248,191,106));
setBorderColor(getO1AxisLine(),new Color(130,130,130));
setBorderColor(getY1AxisLine(),new Color(130,130,130));
setFillColor(getY1Title(),new Color(66,70,73));
setFillColor(getY1Label(),new Color(66,70,73));
setFillColor(getY2Label(),new Color(66,70,73));
setFillColor(getY3Label(),new Color(66,70,73));
setFillColor(getY4Label(),new Color(66,70,73));
setFillColor(getY5Label(),new Color(66,70,73));
setFillColor(getO1Title(),new Color(66,70,73));
setFillColor(getX1Title(),new Color(66,70,73));
setFillColor(getO1Label(),new Color(66,70,73));
setFillColor(getO2Label(),new Color(66,70,73));
setFillColor(getX1Label(),new Color(66,70,73));
setFillColor(getLegendText(),new Color(66,70,73));
setFillColor(getFrame(),new Color(235,235,240));
setFillColor(getChartBackground(),new Color(255,255,255));
setBorderColor(getY1MajorGrid(),new Color(204,204,204));
setBorderColor(getY1MinorGrid(),new Color(204,204,204));
setBorderColor(getY2MajorGrid(),new Color(204,204,204));
setBorderColor(getY2MinorGrid(),new Color(204,204,204));
setBorderColor(getO1MajorGrid(),new Color(204,204,204));
setBorderColor(getO1MinorGrid(),new Color(204,204,204));
setBorderColor(getX1MajorGrid(),new Color(204,204,204));
setBorderColor(getX1MinorGrid(),new Color(204,204,204));
setTransparentBorderColor(getCubeFloor(),true);
setTransparentBorderColor(getCubeLeftWall(),true);
setTransparentBorderColor(getCubeRightWall(),true);
setCubeFocusFactor(95.83333182119424);
setCubePanX(41.3);
setCubePanY(54.7);
setCubeRotationMatrix(0.9527877123115605,-0.39648905742363183,1.0691265903653806,-0.012240167246073914,1.389589570659449,0.5262420232508634,-1.1402128823990627,-0.3462324595884829,0.8877371966710723);
setCubeViewerZ(93.61645050038162);
setCubeZoomFactor(55.0);
setCubeWallThickZ(0.0);
setCubeWallThickY(0.0);
setCubeWallThickX(0.0);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setTransparentBorderColor(getChartBackground(),true);
setY1MajorGridStyle(0);
setY2MajorGridStyle(0);
setO1MajorGridStyle(0);
setX1MajorGridStyle(0);
setLineStyleLegendMarkers(3);
setNullLegendMarkerShapesAsSquares(false);
setFrameAutoShade(true);
setColorMode(1);
setUseDefaultBubbleMarker(false);
*GRAPH_JS
"mouseOverIndicator": {
"enabled": true,
"color": "yellow",
"marker":{"size": 0}
},
"introAnimation": {
"enabled": true,
"duration": 1400
},
"riserBevel":"bevel"
*END
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END
(FOC1631) MORE THAN ONE IF/WHERE TEST FOR FIELD @TRIGGERTYPENAME

Hi Nico,

Please post your synonym if you are permitted to do so. You still seem to be using a combination of field names which look wrong. With your synonym I can supply you some code to test which, hopefully, will help us resolve this for you (and explain why your code is not running).

T

There are multiple fields i have to do this for. IF i can just get the TRIGGERTYPENAME to pass multiple values, i feel i can get the rest.

i am able to pass 1 value, jsut not multiple.
thank u

-? &
-SET &ECHO=ALL;
SET MSG=ON
-*** Set up SQL tracing

-*** Deactivate SQL tracing
SET TRACEOFF = ALL

-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL

-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS

-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT

-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT

-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT

-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT

-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF

-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 132

-*** Set trace to output file
SET TRACEUSER=C:\ibi\apps\baseapp\my_sql_trace.txt

-*** Activate SQL tracing
SET TRACEUSER = ON

-RUN


-SET &TRIGGERTYPENAME = STRREP (&TRIGGERTYPENAME.LENGTH, &TRIGGERTYPENAME.QUOTEDSTRING, 4, ' AND ', 2, ', ', &TRIGGERTYPENAME.LENGTH, 'A&TRIGGERTYPENAME.LENGTH');



TABLE FILE CWS3001_QC_PERFORMANCE_DETAIL_TESTING
PRINT
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.INVESTOR
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('&TRIGGERTYPENAME');


ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/BIRS05/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END

The SQL trace you added to your fex is there to display the SQL. You have to run the fex, with the report in HTML format and then view source in the web browser window. somewhere in the source html you will see a SQL select statement - that is what we need to see - with you having selected multiple values on your parameter screen.

Hi:
With the code below, i am able to pass in 1 values @ a time. However, i am not able to pass in multiple.

Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


--------------------------------------------------------------------------------


CURRENTLY DEFINED & VARIABLES:
&&IBIBIPMS =
&&MAS_FULLINFO= Y
&ACCEPTS = 0
&APPPRIV = /binfs00/app/ibi/apps
&APPROOT = /binfs00/app/ibi/apps
&AROUTPUT = SET AROUTPUT=EXTJS
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 04/01/14
&DBMSERR = 0
&DELTD = 0
&DMY = 010414
&DMYY = 01042014
&DUPLS = 0
&ECHO = OFF
&EXCELSERVURL = SET EXCELSERVURL=http://vmbiapps06.dcsr.site:9080/ibi_apps
&FOCEXURL = /ibi_apps/WFServlet.ibfs?IBIF_webapp=/ibi_apps&IBIC_server=BI
&FOCFEXNAME = ADHOCRQ
&FOCFOCEXEC = _ADHOCRQ
&FOCGRAPHCNT = 0
&FOCHTMLURL = /ibi_apps/ibi_html/S56_13911305501F
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = M728007D
&FORMAT = 0
&GOOGLEMAPSAP>=
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 040114
&MDYY = 04012014
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&SETFILE =
&SORTIO = 0
&TOD = 11.47.26
&TRANS = 0
&TRIGGERTYPEN>= DeedInLieu OR ForeclosureSale
&WFDESCRIBE = XMLPROMPT
&WF_TITLE = AdhocRequest
&YMD = 140401
&YYMD = 20140401
SET MSG=ON
-*** Set up SQL tracing
-*** Deactivate SQL tracing
SET TRACEOFF = ALL
-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL
-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS
-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT
DeedInLieuDeedInLieu
-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT
-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT
-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT
-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF
-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 132
-*** Set trace to output file
SET TRACEUSER=C:\ibi\apps\baseapp\my_sql_trace.txt
-*** Activate SQL tracing
SET TRACEUSER = ON
-RUN
(FOC1517) UNRECOGNIZED COMMAND DEEDINLIEUDEEDINLIEU
-SET &TRIGGERTYPENAME = STRREP (29, 'DeedInLieu OR ForeclosureSale', 4, 'AND', 2, ', ', 29, 'A29');
TABLE FILE CWS3001_QC_PERFORMANCE_DETAIL_TESTING
PRINT
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.INVESTOR
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMUSERNAME
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.SERVICERLOANNUMBER
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMLOGINID
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('DeedInLieu OR ForeclosureSale');
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/endeflt.sty
type=report,
color=rgb(66 70 73),
font='Trebuchet MS',
size=9,
squeeze=on,
grid=off,
$
type=pagenum,
style=italic,
size=6,
justify=right,
$
type=tabheading,
style=bold+italic,
size=14,
justify=center,
$
type=tabfooting,
style=bold+italic,
size=12,
justify=center,
border-top=heavy,
border-top-color=rgb(52 55 58),
$
type=heading,
style=bold,
size=12,
justify=center,
$
type=footing,
style=bold,
size=10,
justify=center,
$
type=title,
backcolor=rgb(102 102 102),
color=rgb(255 255 255),
style=-underline+bold,
$
type=data,
backcolor=(rgb(255 255 255) rgb(235 235 240)),
$
type=acrosstitle,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
size=9,
style=-underline+bold,
$
type=acrossvalue,
backcolor=rgb(218 225 232),
style=bold,
$
type=subhead,
size=10,
style=bold,border-top=heavy,
border-bottom=light,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subfoot,
size=10,
style=bold,
border-top=light,
border-bottom=medium,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subtotal,
backcolor=RGB(200 200 200),
style=bold,
border-top=light,
border-top-color=rgb(66 70 73),
$
type=grandtotal,
backcolor=rgb(66 70 73),
color=rgb(255 255 255),
style=bold,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(66 70 73),
border-top-style=solid,
border-bottom-style=double,
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
BACKCOLOR=RGB(200 200 200),
HOVER-BACKCOLOR=rgb(218 225 232),
$
TYPE=REPORT,
GRAPHCOLOR=green,
GRAPHCOLORNEG=red,
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=MENU,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
BORDER-COLOR=white,
HOVER-COLOR=rgb(66 70 73),
hover-backcolor=rgb(218 225 232),
$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(48,94,213));
setFillColor(getSeries(1),new Color(237,195,27));
setFillColor(getSeries(2),new Color(136,144,151));
setFillColor(getSeries(3),new Color(140,205,40));
setFillColor(getSeries(4),new Color(227,136,0) );
setFillColor(getSeries(5),new Color(40,190,205) );
setFillColor(getSeries(6),new Color(255,102,102) );
setFillColor(getSeries(7), new Color(71,186,143));
setFillColor(getSeries(8), new Color(187,90,71));
setFillColor(getSeries(9),new Color(190,107,211));
setFillColor(getSeries(10),new Color(16,122,22));
setFillColor(getSeries(11),new Color(108,149,200));
setFillColor(getSeries(12),new Color(169,109,205) );
setFillColor(getSeries(13),new Color(210,143,255) );
setFillColor(getSeries(14),new Color(60,49,36));
setFillColor(getSeries(15),new Color(78,43,37));
setFillColor(getSeries(16),new Color(95,38,37));
setFillColor(getSeries(17),new Color(19,23,162));
setFillColor(getSeries(18),new Color(66,70,73));
setFillColor(getSeries(19),new Color(19,23,162));
setFillColor(getSeries(20),new Color(66,70,73));
setFillColor(getSeries(21),new Color(191,218,170));
setFillColor(getSeries(22),new Color(0,0,128));
setFillColor(getSeries(23),new Color(163,211,208));
setFillColor(getSeries(24),new Color(158,213,243));
setFillColor(getSeries(25),new Color(179,151,191));
setFillColor(getSeries(26),new Color(200,158,193));
setFillColor(getSeries(27),new Color(240,171,196));
setFillColor(getSeries(28),new Color(242,171,168));
setFillColor(getSeries(29),new Color(230,121,88));
setFillColor(getSeries(30),new Color(240,159,97));
setFillColor(getSeries(31),new Color(248,191,106));
setFillColor(getSeries(32),new Color(255,239,121));
setFillColor(getSeries(33),new Color(195,218,125));
setFillColor(getSeries(34),new Color(0,0,255));
setFillColor(getSeries(35),new Color(0,255,0));
setFillColor(getSeries(36),new Color(255,0,255));
setFillColor(getSeries(37),new Color(255,255,0));
setFillColor(getSeries(38),new Color(255,0,0));
setFillColor(getSeries(39),new Color(255,200,0));
setFillColor(getSeries(40),new Color(255,175,175));
setFillColor(getSeries(41),new Color(0,255,255));
setFillColor(getSeries(42),new Color(206,0,54));
setFillColor(getSeries(43),new Color(255,239,0));
setFillColor(getSeries(44),new Color(0,152,82));
setFillColor(getSeries(45),new Color(0,174,227));
setFillColor(getSeries(46),new Color(42,19,109));
setFillColor(getSeries(47),new Color(206,0,121));
setFillColor(getSeries(48),new Color(243,169,136));
setFillColor(getSeries(49),new Color(248,190,145));
setFillColor(getSeries(50),new Color(253,211,154));
setFillColor(getSeries(51),new Color(255,243,172));
setFillColor(getSeries(52),new Color(217,229,171));
setFillColor(getSeries(53),new Color(191,218,170));
setFillColor(getSeries(54),new Color(165,208,169));
setFillColor(getSeries(55),new Color(163,211,208));
setFillColor(getSeries(56),new Color(158,213,243));
setFillColor(getSeries(57),new Color(179,151,191));
setFillColor(getSeries(58),new Color(200,158,193));
setFillColor(getSeries(59),new Color(240,171,196));
setFillColor(getSeries(60),new Color(242,171,168));
setFillColor(getSeries(61),new Color(230,121,88));
setFillColor(getSeries(62),new Color(240,159,97));
setFillColor(getSeries(63),new Color(248,191,106));
setBorderColor(getO1AxisLine(),new Color(130,130,130));
setBorderColor(getY1AxisLine(),new Color(130,130,130));
setFillColor(getY1Title(),new Color(66,70,73));
setFillColor(getY1Label(),new Color(66,70,73));
setFillColor(getY2Label(),new Color(66,70,73));
setFillColor(getY3Label(),new Color(66,70,73));
setFillColor(getY4Label(),new Color(66,70,73));
setFillColor(getY5Label(),new Color(66,70,73));
setFillColor(getO1Title(),new Color(66,70,73));
setFillColor(getX1Title(),new Color(66,70,73));
setFillColor(getO1Label(),new Color(66,70,73));
setFillColor(getO2Label(),new Color(66,70,73));
setFillColor(getX1Label(),new Color(66,70,73));
setFillColor(getLegendText(),new Color(66,70,73));
setFillColor(getFrame(),new Color(235,235,240));
setFillColor(getChartBackground(),new Color(255,255,255));
setBorderColor(getY1MajorGrid(),new Color(204,204,204));
setBorderColor(getY1MinorGrid(),new Color(204,204,204));
setBorderColor(getY2MajorGrid(),new Color(204,204,204));
setBorderColor(getY2MinorGrid(),new Color(204,204,204));
setBorderColor(getO1MajorGrid(),new Color(204,204,204));
setBorderColor(getO1MinorGrid(),new Color(204,204,204));
setBorderColor(getX1MajorGrid(),new Color(204,204,204));
setBorderColor(getX1MinorGrid(),new Color(204,204,204));
setTransparentBorderColor(getCubeFloor(),true);
setTransparentBorderColor(getCubeLeftWall(),true);
setTransparentBorderColor(getCubeRightWall(),true);
setCubeFocusFactor(95.83333182119424);
setCubePanX(41.3);
setCubePanY(54.7);
setCubeRotationMatrix(0.9527877123115605,-0.39648905742363183,1.0691265903653806,-0.012240167246073914,1.389589570659449,0.5262420232508634,-1.1402128823990627,-0.3462324595884829,0.8877371966710723);
setCubeViewerZ(93.61645050038162);
setCubeZoomFactor(55.0);
setCubeWallThickZ(0.0);
setCubeWallThickY(0.0);
setCubeWallThickX(0.0);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setTransparentBorderColor(getChartBackground(),true);
setY1MajorGridStyle(0);
setY2MajorGridStyle(0);
setO1MajorGridStyle(0);
setX1MajorGridStyle(0);
setLineStyleLegendMarkers(3);
setNullLegendMarkerShapesAsSquares(false);
setFrameAutoShade(true);
setColorMode(1);
setUseDefaultBubbleMarker(false);
*GRAPH_JS
"mouseOverIndicator": {
"enabled": true,
"color": "yellow",
"marker":{"size": 0}
},
"introAnimation": {
"enabled": true,
"duration": 1400
},
"riserBevel":"bevel"
*END
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=IBFS:/WFC/NONE,
$
TYPE=TITLE,
COLUMN=N1,
FOCEXEC=IBFS:/WFC/NONE,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

String them together in JavaScript and pass them as one long field for an IN clause.

&COLOR='('RED', 'BLUE', 'GREEN')

Hi, is java the only option @ this point?
I'm not exactly sure how to do that, do you have an example?

thanks

I still don't see any SQL.

But this seems to be an error:

WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('DeedInLieu OR ForeclosureSale');

Each option in &TRIGGERTYPENAME should have quotes around them. And you're using STRREP to replace the OR by a comma but that's not what the resulting code seems to show:

-SET &TRIGGERTYPENAME = STRREP (33, '''DeedInLieu'' OR ''ForeclosureSale''', 4, ' OR ', 2, ', ', 33, 'A33');
TABLE FILE CWS3001_QC_PERFORMANCE_DETAIL_TESTING
PRINT
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.INVESTOR
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMUSERNAME
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.SERVICERLOANNUMBER
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMLOGINID
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('DeedInLieu', 'ForeclosureSale' );

Thank you for your reply. The output is below & i am able to see the values that SHOULD theoricially pass successfully to my stored proc. I do not understand why its not passing
Your request did not return any output to display.

ERROR MESSAGE IN .FEX
(FOC1631) MORE THAN ONE IF/WHERE TEST FOR FIELD @TRIGGERTYPENAME


SQL WHERE CLAUSE:
WHERE (TriggerTypeName in (@TriggerTypeName))


Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


--------------------------------------------------------------------------------


CURRENTLY DEFINED & VARIABLES:
&ACCEPTS = 0
&APPPRIV = /binfs00/app/ibi/apps
&APPROOT = /binfs00/app/ibi/apps
&AROUTPUT = SET AROUTPUT=EXTJS
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 04/01/14
&DBMSERR = 0
&DELTD = 0
&DMY = 010414
&DMYY = 01042014
&DUPLS = 0
&ECHO = OFF
&EXCELSERVURL = SET EXCELSERVURL=http://vmbiapps06.dcsr.site:9080/ibi_apps
&FOCEXURL = /ibi_apps/WFServlet.ibfs?IBIF_webapp=/ibi_apps&IBIC_server=BI
&FOCFEXNAME = ADHOCRQ
&FOCFOCEXEC = _ADHOCRQ
&FOCGRAPHCNT = 0
&FOCHTMLURL = /ibi_apps/ibi_html/S56_13911305501F
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = M728007D
&FORMAT = 0
&GOOGLEMAPSAP>=
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 040114
&MDYY = 04012014
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&SETFILE =
&SORTIO = 0
&TOD = 13.51.36
&TRANS = 0
&TRIGGERTYPEN>= 'DeedInLieu' OR 'ForeclosureSale'
&WFDESCRIBE = XMLPROMPT
&WF_TITLE = AdhocRequest
&YMD = 140401
&YYMD = 20140401
SET MSG=ON
-*** Set up SQL tracing
-*** Deactivate SQL tracing
SET TRACEOFF = ALL
-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL
-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS
-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT
-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT
-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT
-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT
-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF
-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 132
-*** Set trace to output file
SET TRACEUSER=C:\ibi\apps\baseapp\my_sql_trace.txt
-*** Activate SQL tracing
SET TRACEUSER = ON
-RUN
-SET &TRIGGERTYPENAME = STRREP (33, '''DeedInLieu'' OR ''ForeclosureSale''', 4, ' OR ', 2, ', ', 33, 'A33');
TABLE FILE CWS3001_QC_PERFORMANCE_DETAIL_TESTING
PRINT
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.INVESTOR
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMUSERNAME
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.SERVICERLOANNUMBER
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.CLAIMLOGINID
CWS3001_QC_PERFORMANCE_DETAIL_TESTING.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_QC_PERFORMANCE_DETAIL_TESTING.INPUT.@TRIGGERTYPENAME IN ('DeedInLieu', 'ForeclosureSale' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/endeflt.sty
type=report,
color=rgb(66 70 73),
font='Trebuchet MS',
size=9,
squeeze=on,
grid=off,
$
type=pagenum,
style=italic,
size=6,
justify=right,
$
type=tabheading,
style=bold+italic,
size=14,
justify=center,
$
type=tabfooting,
style=bold+italic,
size=12,
justify=center,
border-top=heavy,
border-top-color=rgb(52 55 58),
$
type=heading,
style=bold,
size=12,
justify=center,
$
type=footing,
style=bold,
size=10,
justify=center,
$
type=title,
backcolor=rgb(102 102 102),
color=rgb(255 255 255),
style=-underline+bold,
$
type=data,
backcolor=(rgb(255 255 255) rgb(235 235 240)),
$
type=acrosstitle,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
size=9,
style=-underline+bold,
$
type=acrossvalue,
backcolor=rgb(218 225 232),
style=bold,
$
type=subhead,
size=10,
style=bold,border-top=heavy,
border-bottom=light,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subfoot,
size=10,
style=bold,
border-top=light,
border-bottom=medium,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subtotal,
backcolor=RGB(200 200 200),
style=bold,
border-top=light,
border-top-color=rgb(66 70 73),
$
type=grandtotal,
backcolor=rgb(66 70 73),
color=rgb(255 255 255),
style=bold,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(66 70 73),
border-top-style=solid,
border-bottom-style=double,
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
BACKCOLOR=RGB(200 200 200),
HOVER-BACKCOLOR=rgb(218 225 232),
$
TYPE=REPORT,
GRAPHCOLOR=green,
GRAPHCOLORNEG=red,
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=MENU,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
BORDER-COLOR=white,
HOVER-COLOR=rgb(66 70 73),
hover-backcolor=rgb(218 225 232),
$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(48,94,213));
setFillColor(getSeries(1),new Color(237,195,27));
setFillColor(getSeries(2),new Color(136,144,151));
setFillColor(getSeries(3),new Color(140,205,40));
setFillColor(getSeries(4),new Color(227,136,0) );
setFillColor(getSeries(5),new Color(40,190,205) );
setFillColor(getSeries(6),new Color(255,102,102) );
setFillColor(getSeries(7), new Color(71,186,143));
setFillColor(getSeries(8), new Color(187,90,71));
setFillColor(getSeries(9),new Color(190,107,211));
setFillColor(getSeries(10),new Color(16,122,22));
setFillColor(getSeries(11),new Color(108,149,200));
setFillColor(getSeries(12),new Color(169,109,205) );
setFillColor(getSeries(13),new Color(210,143,255) );
setFillColor(getSeries(14),new Color(60,49,36));
setFillColor(getSeries(15),new Color(78,43,37));
setFillColor(getSeries(16),new Color(95,38,37));
setFillColor(getSeries(17),new Color(19,23,162));
setFillColor(getSeries(18),new Color(66,70,73));
setFillColor(getSeries(19),new Color(19,23,162));
setFillColor(getSeries(20),new Color(66,70,73));
setFillColor(getSeries(21),new Color(191,218,170));
setFillColor(getSeries(22),new Color(0,0,128));
setFillColor(getSeries(23),new Color(163,211,208));
setFillColor(getSeries(24),new Color(158,213,243));
setFillColor(getSeries(25),new Color(179,151,191));
setFillColor(getSeries(26),new Color(200,158,193));
setFillColor(getSeries(27),new Color(240,171,196));
setFillColor(getSeries(28),new Color(242,171,168));
setFillColor(getSeries(29),new Color(230,121,88));
setFillColor(getSeries(30),new Color(240,159,97));
setFillColor(getSeries(31),new Color(248,191,106));
setFillColor(getSeries(32),new Color(255,239,121));
setFillColor(getSeries(33),new Color(195,218,125));
setFillColor(getSeries(34),new Color(0,0,255));
setFillColor(getSeries(35),new Color(0,255,0));
setFillColor(getSeries(36),new Color(255,0,255));
setFillColor(getSeries(37),new Color(255,255,0));
setFillColor(getSeries(38),new Color(255,0,0));
setFillColor(getSeries(39),new Color(255,200,0));
setFillColor(getSeries(40),new Color(255,175,175));
setFillColor(getSeries(41),new Color(0,255,255));
setFillColor(getSeries(42),new Color(206,0,54));
setFillColor(getSeries(43),new Color(255,239,0));
setFillColor(getSeries(44),new Color(0,152,82));
setFillColor(getSeries(45),new Color(0,174,227));
setFillColor(getSeries(46),new Color(42,19,109));
setFillColor(getSeries(47),new Color(206,0,121));
setFillColor(getSeries(48),new Color(243,169,136));
setFillColor(getSeries(49),new Color(248,190,145));
setFillColor(getSeries(50),new Color(253,211,154));
setFillColor(getSeries(51),new Color(255,243,172));
setFillColor(getSeries(52),new Color(217,229,171));
setFillColor(getSeries(53),new Color(191,218,170));
setFillColor(getSeries(54),new Color(165,208,169));
setFillColor(getSeries(55),new Color(163,211,208));
setFillColor(getSeries(56),new Color(158,213,243));
setFillColor(getSeries(57),new Color(179,151,191));
setFillColor(getSeries(58),new Color(200,158,193));
setFillColor(getSeries(59),new Color(240,171,196));
setFillColor(getSeries(60),new Color(242,171,168));
setFillColor(getSeries(61),new Color(230,121,88));
setFillColor(getSeries(62),new Color(240,159,97));
setFillColor(getSeries(63),new Color(248,191,106));
setBorderColor(getO1AxisLine(),new Color(130,130,130));
setBorderColor(getY1AxisLine(),new Color(130,130,130));
setFillColor(getY1Title(),new Color(66,70,73));
setFillColor(getY1Label(),new Color(66,70,73));
setFillColor(getY2Label(),new Color(66,70,73));
setFillColor(getY3Label(),new Color(66,70,73));
setFillColor(getY4Label(),new Color(66,70,73));
setFillColor(getY5Label(),new Color(66,70,73));
setFillColor(getO1Title(),new Color(66,70,73));
setFillColor(getX1Title(),new Color(66,70,73));
setFillColor(getO1Label(),new Color(66,70,73));
setFillColor(getO2Label(),new Color(66,70,73));
setFillColor(getX1Label(),new Color(66,70,73));
setFillColor(getLegendText(),new Color(66,70,73));
setFillColor(getFrame(),new Color(235,235,240));
setFillColor(getChartBackground(),new Color(255,255,255));
setBorderColor(getY1MajorGrid(),new Color(204,204,204));
setBorderColor(getY1MinorGrid(),new Color(204,204,204));
setBorderColor(getY2MajorGrid(),new Color(204,204,204));
setBorderColor(getY2MinorGrid(),new Color(204,204,204));
setBorderColor(getO1MajorGrid(),new Color(204,204,204));
setBorderColor(getO1MinorGrid(),new Color(204,204,204));
setBorderColor(getX1MajorGrid(),new Color(204,204,204));
setBorderColor(getX1MinorGrid(),new Color(204,204,204));
setTransparentBorderColor(getCubeFloor(),true);
setTransparentBorderColor(getCubeLeftWall(),true);
setTransparentBorderColor(getCubeRightWall(),true);
setCubeFocusFactor(95.83333182119424);
setCubePanX(41.3);
setCubePanY(54.7);
setCubeRotationMatrix(0.9527877123115605,-0.39648905742363183,1.0691265903653806,-0.012240167246073914,1.389589570659449,0.5262420232508634,-1.1402128823990627,-0.3462324595884829,0.8877371966710723);
setCubeViewerZ(93.61645050038162);
setCubeZoomFactor(55.0);
setCubeWallThickZ(0.0);
setCubeWallThickY(0.0);
setCubeWallThickX(0.0);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setTransparentBorderColor(getChartBackground(),true);
setY1MajorGridStyle(0);
setY2MajorGridStyle(0);
setO1MajorGridStyle(0);
setX1MajorGridStyle(0);
setLineStyleLegendMarkers(3);
setNullLegendMarkerShapesAsSquares(false);
setFrameAutoShade(true);
setColorMode(1);
setUseDefaultBubbleMarker(false);
*GRAPH_JS
"mouseOverIndicator": {
"enabled": true,
"color": "yellow",
"marker":{"size": 0}
},
"introAnimation": {
"enabled": true,
"duration": 1400
},
"riserBevel":"bevel"
*END
$
TYPE=DATA,
COLUMN=N1,
FOCEXEC=IBFS:/WFC/NONE,
$
TYPE=TITLE,
COLUMN=N1,
FOCEXEC=IBFS:/WFC/NONE,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END
(FOC1631) MORE THAN ONE IF/WHERE TEST FOR FIELD @TRIGGERTYPENAME

As I noted earlier, the documentation imposes the limit stated in the FOC1631 message.

Apparently it will accept the where ... in () syntax -- provided the list is a single value:

WHERE parameter IN ('just one value');

Thank u very much & you were correct about the IN() syntax j.gross.

I am now able to pass multiple values through both my stored procedure (utilizing a split function) AND my .fex, however the html is not functioning as intended.

sql:

WHERE
(TriggerTypeName in (SELECT * FROM tfSplitStringByDelimiter1](@TriggerTypeName,',')))
OR ((@TriggerTypeName = '') )


.FEX

I can successfully pass in this when prompted for triggertypename:
AcceleratedClaim, DeedInLieu



HOWEVER,
I am not able to pass multi values from the html page (where i am trying to use either a list box OR a check box)
In my properties on my listbox, i have mutliple chosen, with NO quotes.


IF i choose multiple values, i can only see the 1st of the choices


IF i choose:

AcceleratedClaim
DeedInLieu (I KNOW THERE IS DATA FOR THIS VALUE, IF I CHOOSE IT INDIVIDUALLY, IT RESOLVES)


Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.

-------------------------------------------------------------------------------


CURRENTLY DEFINED & VARIABLES:
&&IBIBIPMS =
&&MAS_FULLINFO= Y
&ACCEPTS = 0
&APPPRIV = /binfs00/app/ibi/apps
&APPROOT = /binfs00/app/ibi/apps
&AROUTPUT = SET AROUTPUT=EXTJS
&AUTOINDEX = NO
&BASEIO = 0
&CHNGD = 0
&DATE = 04/04/14
&DBMSERR = 0
&DELTD = 0
&DMY = 040414
&DMYY = 04042014
&DUPLS = 0
&ECHO = OFF
&EXCELSERVURL = SET EXCELSERVURL=http://vmbiapps06.dcsr.site:9080/ibi_apps
&FOCEXURL = /ibi_apps/WFServlet.ibfs?IBIF_webapp=/ibi_apps&IBIC_server=BI
&FOCFEXNAME = ADHOCRQ
&FOCFOCEXEC = _ADHOCRQ
&FOCGRAPHCNT = 0
&FOCHTMLURL = /ibi_apps/ibi_html/S56_13911305501F
&FOCINCLUDE = ADHOCRQ
&FOCNEXTPAGE = 0
&FOCREL = M728007D
&FORMAT = 0
&GOOGLEMAPSAP>=
&INDEXIO = 0
&INPUT = 0
&INVALID = 0
&LINES = 0
&MDY = 040414
&MDYY = 04042014
&NOMATCH = 0
&READS = 0
&RECORDS = 0
&REJECTS = 0
&SETFILE =
&SORTIO = 0
&TOD = 14.58.32
&TRANS = 0
&TRIGGERTYPEN>= AcceleratedClaim OR DeedInLieu
&WFDESCRIBE = XMLPROMPT
&WF_TITLE = AdhocRequest
&YMD = 140404
&YYMD = 20140404
SET MSG=ON
-*** Set up SQL tracing
-*** Deactivate SQL tracing
SET TRACEOFF = ALL
-*** Show Commands and data exchange between the physical and
-*** the logical layers of the data adapter
-*SET TRACEON = SQLCALL
-*** Enable Trace for the SQL Translator
SET TRACEON = SQLTRANS
-*** Show SQL statements
SET TRACEON = STMTRACE//CLIENT
-*** Show Optimization information
SET TRACEON = SQLAGGR//CLIENT
-*** Show SQL generated statement trace
-*SET TRACEON = STMTRACE/1/CLIENT
-*** Show SQL generated sub-statement trace
-*SET TRACEON = STMTRACE/2/CLIENT
-*** Disable the trace stamp (Date/Time etc)
SET TRACESTAMP = OFF
-*** Set trace line wrapping - # of characters
SET TRACEWRAP = 132
-*** Set trace to output file
SET TRACEUSER=C:\ibi\apps\baseapp\my_sql_trace.txt
-*** Activate SQL tracing
SET TRACEUSER = ON
-RUN
-SET &TRIGGERTYPENAME = STRREP (30, 'AcceleratedClaim OR DeedInLieu', 4, ' OR ', 2, ', ', 30, 'A30');
TABLE FILE CWS3001_TESTING_TRIGGER
PRINT
CWS3001_TESTING_TRIGGER.ANSWERSET1.INVESTOR
CWS3001_TESTING_TRIGGER.ANSWERSET1.CLAIMUSERNAME
CWS3001_TESTING_TRIGGER.ANSWERSET1.SERVICERLOANNUMBER
CWS3001_TESTING_TRIGGER.ANSWERSET1.CLAIMID
CWS3001_TESTING_TRIGGER.ANSWERSET1.TRIGGERTYPENAME
WHERE CWS3001_TESTING_TRIGGER.INPUT.@TRIGGERTYPENAME IN ('AcceleratedClaim, DeedInLieu ');
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
-INCLUDE _EDAHOME/ETC/endeflt.sty
type=report,
color=rgb(66 70 73),
font='Trebuchet MS',
size=9,
squeeze=on,
grid=off,
$
type=pagenum,
style=italic,
size=6,
justify=right,
$
type=tabheading,
style=bold+italic,
size=14,
justify=center,
$
type=tabfooting,
style=bold+italic,
size=12,
justify=center,
border-top=heavy,
border-top-color=rgb(52 55 58),
$
type=heading,
style=bold,
size=12,
justify=center,
$
type=footing,
style=bold,
size=10,
justify=center,
$
type=title,
backcolor=rgb(102 102 102),
color=rgb(255 255 255),
style=-underline+bold,
$
type=data,
backcolor=(rgb(255 255 255) rgb(235 235 240)),
$
type=acrosstitle,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
size=9,
style=-underline+bold,
$
type=acrossvalue,
backcolor=rgb(218 225 232),
style=bold,
$
type=subhead,
size=10,
style=bold,border-top=heavy,
border-bottom=light,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subfoot,
size=10,
style=bold,
border-top=light,
border-bottom=medium,
border-top-color=rgb(52 55 58),
border-bottom-color=rgb(52 55 58),
$
type=subtotal,
backcolor=RGB(200 200 200),
style=bold,
border-top=light,
border-top-color=rgb(66 70 73),
$
type=grandtotal,
backcolor=rgb(66 70 73),
color=rgb(255 255 255),
style=bold,
border-top=light,
border-bottom=heavy,
border-top-color=rgb(66 70 73),
border-top-style=solid,
border-bottom-style=double,
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
BACKCOLOR=RGB(200 200 200),
HOVER-BACKCOLOR=rgb(218 225 232),
$
TYPE=REPORT,
GRAPHCOLOR=green,
GRAPHCOLORNEG=red,
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
$
TYPE=REPORT,
OBJECT=MENU,
COLOR=white,
BACKCOLOR=rgb(102 102 102),
BORDER-COLOR=white,
HOVER-COLOR=rgb(66 70 73),
hover-backcolor=rgb(218 225 232),
$
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(48,94,213));
setFillColor(getSeries(1),new Color(237,195,27));
setFillColor(getSeries(2),new Color(136,144,151));
setFillColor(getSeries(3),new Color(140,205,40));
setFillColor(getSeries(4),new Color(227,136,0) );
setFillColor(getSeries(5),new Color(40,190,205) );
setFillColor(getSeries(6),new Color(255,102,102) );
setFillColor(getSeries(7), new Color(71,186,143));
setFillColor(getSeries(8), new Color(187,90,71));
setFillColor(getSeries(9),new Color(190,107,211));
setFillColor(getSeries(10),new Color(16,122,22));
setFillColor(getSeries(11),new Color(108,149,200));
setFillColor(getSeries(12),new Color(169,109,205) );
setFillColor(getSeries(13),new Color(210,143,255) );
setFillColor(getSeries(14),new Color(60,49,36));
setFillColor(getSeries(15),new Color(78,43,37));
setFillColor(getSeries(16),new Color(95,38,37));
setFillColor(getSeries(17),new Color(19,23,162));
setFillColor(getSeries(18),new Color(66,70,73));
setFillColor(getSeries(19),new Color(19,23,162));
setFillColor(getSeries(20),new Color(66,70,73));
setFillColor(getSeries(21),new Color(191,218,170));
setFillColor(getSeries(22),new Color(0,0,128));
setFillColor(getSeries(23),new Color(163,211,208));
setFillColor(getSeries(24),new Color(158,213,243));
setFillColor(getSeries(25),new Color(179,151,191));
setFillColor(getSeries(26),new Color(200,158,193));
setFillColor(getSeries(27),new Color(240,171,196));
setFillColor(getSeries(28),new Color(242,171,168));
setFillColor(getSeries(29),new Color(230,121,88));
setFillColor(getSeries(30),new Color(240,159,97));
setFillColor(getSeries(31),new Color(248,191,106));
setFillColor(getSeries(32),new Color(255,239,121));
setFillColor(getSeries(33),new Color(195,218,125));
setFillColor(getSeries(34),new Color(0,0,255));
setFillColor(getSeries(35),new Color(0,255,0));
setFillColor(getSeries(36),new Color(255,0,255));
setFillColor(getSeries(37),new Color(255,255,0));
setFillColor(getSeries(38),new Color(255,0,0));
setFillColor(getSeries(39),new Color(255,200,0));
setFillColor(getSeries(40),new Color(255,175,175));
setFillColor(getSeries(41),new Color(0,255,255));
setFillColor(getSeries(42),new Color(206,0,54));
setFillColor(getSeries(43),new Color(255,239,0));
setFillColor(getSeries(44),new Color(0,152,82));
setFillColor(getSeries(45),new Color(0,174,227));
setFillColor(getSeries(46),new Color(42,19,109));
setFillColor(getSeries(47),new Color(206,0,121));
setFillColor(getSeries(48),new Color(243,169,136));
setFillColor(getSeries(49),new Color(248,190,145));
setFillColor(getSeries(50),new Color(253,211,154));
setFillColor(getSeries(51),new Color(255,243,172));
setFillColor(getSeries(52),new Color(217,229,171));
setFillColor(getSeries(53),new Color(191,218,170));
setFillColor(getSeries(54),new Color(165,208,169));
setFillColor(getSeries(55),new Color(163,211,208));
setFillColor(getSeries(56),new Color(158,213,243));
setFillColor(getSeries(57),new Color(179,151,191));
setFillColor(getSeries(58),new Color(200,158,193));
setFillColor(getSeries(59),new Color(240,171,196));
setFillColor(getSeries(60),new Color(242,171,168));
setFillColor(getSeries(61),new Color(230,121,88));
setFillColor(getSeries(62),new Color(240,159,97));
setFillColor(getSeries(63),new Color(248,191,106));
setBorderColor(getO1AxisLine(),new Color(130,130,130));
setBorderColor(getY1AxisLine(),new Color(130,130,130));
setFillColor(getY1Title(),new Color(66,70,73));
setFillColor(getY1Label(),new Color(66,70,73));
setFillColor(getY2Label(),new Color(66,70,73));
setFillColor(getY3Label(),new Color(66,70,73));
setFillColor(getY4Label(),new Color(66,70,73));
setFillColor(getY5Label(),new Color(66,70,73));
setFillColor(getO1Title(),new Color(66,70,73));
setFillColor(getX1Title(),new Color(66,70,73));
setFillColor(getO1Label(),new Color(66,70,73));
setFillColor(getO2Label(),new Color(66,70,73));
setFillColor(getX1Label(),new Color(66,70,73));
setFillColor(getLegendText(),new Color(66,70,73));
setFillColor(getFrame(),new Color(235,235,240));
setFillColor(getChartBackground(),new Color(255,255,255));
setBorderColor(getY1MajorGrid(),new Color(204,204,204));
setBorderColor(getY1MinorGrid(),new Color(204,204,204));
setBorderColor(getY2MajorGrid(),new Color(204,204,204));
setBorderColor(getY2MinorGrid(),new Color(204,204,204));
setBorderColor(getO1MajorGrid(),new Color(204,204,204));
setBorderColor(getO1MinorGrid(),new Color(204,204,204));
setBorderColor(getX1MajorGrid(),new Color(204,204,204));
setBorderColor(getX1MinorGrid(),new Color(204,204,204));
setTransparentBorderColor(getCubeFloor(),true);
setTransparentBorderColor(getCubeLeftWall(),true);
setTransparentBorderColor(getCubeRightWall(),true);
setCubeFocusFactor(95.83333182119424);
setCubePanX(41.3);
setCubePanY(54.7);
setCubeRotationMatrix(0.9527877123115605,-0.39648905742363183,1.0691265903653806,-0.012240167246073914,1.389589570659449,0.5262420232508634,-1.1402128823990627,-0.3462324595884829,0.8877371966710723);
setCubeViewerZ(93.61645050038162);
setCubeZoomFactor(55.0);
setCubeWallThickZ(0.0);
setCubeWallThickY(0.0);
setCubeWallThickX(0.0);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setTransparentBorderColor(getSeries(11),true);
setTransparentBorderColor(getSeries(12),true);
setTransparentBorderColor(getSeries(13),true);
setTransparentBorderColor(getSeries(14),true);
setTransparentBorderColor(getSeries(15),true);
setTransparentBorderColor(getSeries(16),true);
setTransparentBorderColor(getSeries(17),true);
setTransparentBorderColor(getChartBackground(),true);
setY1MajorGridStyle(0);
setY2MajorGridStyle(0);
setO1MajorGridStyle(0);
setX1MajorGridStyle(0);
setLineStyleLegendMarkers(3);
setNullLegendMarkerShapesAsSquares(false);
setFrameAutoShade(true);
setColorMode(1);
setUseDefaultBubbleMarker(false);
*GRAPH_JS
"mouseOverIndicator": {
"enabled": true,
"color": "yellow",
"marker":{"size": 0}
},
"introAnimation": {
"enabled": true,
"duration": 1400
},
"riserBevel":"bevel"
*END
$
TYPE=REPORT,
COLUMN=N5,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N1,
WRAP=6.000000,
$
ENDSTYLE
END
0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

Any help is SO VERY MUCH APPRICIATED
thank u

WebFOCUS 7.6
Windows, All Outputs

I just need to know WHY the html page does not interpret the values the same way as the .fex.
There has to be a way to work thought this.

Why does it only see the 1st value in teh list box OR the all option.


If i have no value for the 1st option & a value for the 2nd option, when i pass these values in through my list box in my html, why does it not see it?
BUT if i do the exact same thing in the .fex, it resolves perfectly.

What am i missing here?


Thank you..

quote:

-SET &TRIGGERTYPENAME = STRREP (30, 'AcceleratedClaim OR DeedInLieu', 4, ' OR ', 2, ', ', 30, 'A30');
TABLE FILE CWS3001_TESTING_TRIGGER
PRINT . . .
WHERE CWS3001_TESTING_TRIGGER.INPUT.@TRIGGERTYPENAME IN ('AcceleratedClaim, DeedInLieu ');

As it stands, your Where compares @TRIGGERTYPENAME to the single (long) character value
"AcceleratedClaim, DeedInLieu"
-- and of course there is no match to that value, so you get back LINES=0.



As Francis already noted, you need to tell the HTML Composer to quote the individual values. Then the fex would receive
"'AcceleratedClaim' OR 'DeedInLieu'"
(instead of
"AcceleratedClaim OR DeedInLieu")
as the parameter string. And then, STRREP would change the parameter to
"'AcceleratedClaim', 'DeedInLieu'"
which will fit neatly into your WHERE statement. If multiple values are indeed supported, your Table request will then return multiple lines.

But, according to the documentation, WF does not pass along multiple values in such a WHERE clause, and you'll just get a FOC1631.

If there is only one INPUT parameter to screen on with multiple values, you can avoid the FOC1631 by using MORE. If there are several such parameters, it's still possible to use MORE as a work-around, but more complex because of the number of combinations.

This message has been edited. Last edited by: j.gross,

Thank you for your reply. I have followed all recommendations posted in this forum and still can't get this to resolve.

When i try the suggestons listed above, i am back to this error message:
(FOC1631) MORE THAN ONE IF/WHERE TEST FOR FIELD @TRIGGERTYPENAME

I have tried to implement a split function in my .sql & have tried without:

[tfSplitStringByDelimiter1](@TriggerTypeName,',')))

I am not able to resovle this

Can you please point me to where this documentation is located:

But, according to the documentation, WF does not pass along multiple values in such a WHERE clause, and you'll just get a FOC1631.


thanks

quote:

I have followed all recommendations posted in this forum

Except one.

See whether MORE can be used here. Try this for starters:

TABLE FILE CWS3001_TESTING_TRIGGER
 PRINT
   CWS3001_TESTING_TRIGGER.ANSWERSET1.INVESTOR
   CWS3001_TESTING_TRIGGER.ANSWERSET1.CLAIMUSERNAME
   CWS3001_TESTING_TRIGGER.ANSWERSET1.SERVICERLOANNUMBER
   CWS3001_TESTING_TRIGGER.ANSWERSET1.CLAIMID
   CWS3001_TESTING_TRIGGER.ANSWERSET1.TRIGGERTYPENAME
 WHERE CWS3001_TESTING_TRIGGER.INPUT.@TRIGGERTYPENAME EQ 'AcceleratedClaim' ;
 ON TABLE PCHOLD FORMAT HTML
MORE
FILE CWS3001_TESTING_TRIGGER
 WHERE CWS3001_TESTING_TRIGGER.INPUT.@TRIGGERTYPENAME EQ  'DeedInLieu' ;
END  

Let us know ...

Hi:

Yes, i am able to get that to successfully pass into my proc when i use your recommendation.

THANK U very much

Thank you very much for your help & i was FINALLY able to resovle this after i opened a case with IBI.

The solution was:

But can you try just this:
-SET &LEN1= &TRIGGERTYPENAME.LENGTH;
-SET &LEN2= 'A'|&LEN1.EVAL;

-SET &WH_TRIGGER=STRREP(&LEN1,&TRIGGERTYPENAME,4,' OR
- ',1,',',&LEN1,'&LEN2.EVAL');
-TYPE &WH_TRIGGER


Thank you all for your help & this can finally be closed.

But if the incoming parameter from the HTML page will contain a variable number of selected values, the MORE approach will require some mechanism to isolate each of the value in the list, and append a variable number of

MORE
FILE ...
WHERE

blocks of code to the request.

Bonne Chance!