Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Output format XML and count the no of lines

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Output format XML and count the no of lines
 Login/Join
 
Platinum Member
posted
Hi,

I have a fex with output format in XML to serve an ESRI Map in HTML canvas.
Is there any was i can do the &LINES checking similar to i do in HOLD or HTML format.
For XML &LINES check is not working it seems.
But i can see a LINES tag in XML output.
Did anyone worked on branching in XML output fex?

This message has been edited. Last edited by: FP Mod Chuck,


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Expert
posted Hide Post
I would suggest HOLD, check &LINES, then PCHOLD FORMAT XML


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
That fex with output format XML serves the ESRI map.
For some reason if i try to HOLD and then do other stuff ,Map is not refreshing after initial load.

I tried earlier the below scenario:
HOLD AS HLD1
Then checked &LINE conditon
-label
print HLD1 as XML

But map is not refreshing after initial load.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Expert
posted Hide Post
Can you post the code ?

Should be simple as:

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS CHECK
END
-RUN
-IF &LINES EQ 0 THEN GOTO ::Zero:Recs;
TABLE FILE CAR or CHECK if it has all the columns
PRINT COUNTRY
ON TABLE PCHOLD FORMAT XML
END

-RUN

-GOTO ::End

-::Zero:Recs

-* Zero Recs Handler
.
.
.

-::End


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
Hi Waz,

I a doing similar to what you have shown.
But the problem is map layer is not refreshing after initial load if i do branching like this.
If i am not branching and have the only main fex,it will refresh.

Here is the code i use.I changed filed names/table names.
 
TABLE FILE FACT_DEMO_TABLE

PRINT
     COMPUTE LATITUDE_LONGITUDE_POINT/A150 = GIS_POINT('4326', FACT_DEMO_TABLE.LONGITUDE, FACT_DEMO_TABLE.LATITUDE);
FACT_DEMO_TABLE.TYPE_DESCR
FACT_DEMO_TABLE.EVENT_NUM
FACT_DEMO_TABLE.LATITUDE
FACT_DEMO_TABLE.LONGITUDE

WHERE
( FACT_DEMO_TABLE.START_DATETIME GE '&START_DATE 00:00:00' )
AND ( FACT_DEMO_TABLE.START_DATETIME LE '&END_DATE 23:59:59')
AND FACT_DEMO_TABLE.DISTRICT_ID EQ &DISTRICT_ID
AND FACT_DEMO_TABLE.COUNTY_ID EQ &COUNTY_ID
AND FACT_DEMO_TABLE.CITY_ID EQ &CITY_ID
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLDMAPPTS FORMAT FOCUS
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
END

-IF &LINES EQ 0 GOTO :DONE;
TABLE FILE HOLDMICRPTS
PRINT
*
ON TABLE PCHOLD FORMAT XML
END

-EXIT

-:DONE
TABLE FILE FACT_DEMO_TABLE
PRINT
     COMPUTE LATITUDE_LONGITUDE_POINT/A150 = GIS_POINT('4326', FACT_DEMO_TABLE.LONGITUDE, FACT_DEMO_TABLE.LATITUDE);

COMPUTE TYPE_DESCR/A40V ='DUMMY VALUE';
COMPUTE EVENT_NUM/A40V ='DUMMY VALUE';
COMPUTE LATITUDE/A40V = '0';
COMPUTE LONGITUDE/A40V = '0';

 WHERE RECORDLIMIT EQ 1
 WHERE READLIMIT EQ 1
ON TABLE PCHOLD FORMAT XML
END
-EXIT
 


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Platinum Member
posted Hide Post
It seems like you would want a

-RUN

prior to your

-IF &LINES EQ 0 GOTO :DONE;


WebFOCUS 8.2.06
 
Posts: 210 | Location: Sterling Heights, Michigan | Registered: October 19, 2010Report This Post
Platinum Member
posted Hide Post
Added -RUN but stll the map layer wont refresh after first run.Looks like the map will only accept fields in a particular way.If i branch or do some processing out side of the main fex and pass the fields then map layer is not refreshing.

I will be happy if the map layer gets created even though the initial load gives zero output so that i don't have to do any pre/post processing of map fields.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
Expert
posted Hide Post
I would suggest using your browsers developer tools to look at the response from the call to see what is happening, perhaps compare to a successful one


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
okay.
"I think map engine hates seeing Dialog mgr commands & branching and chokes".

&LINES is the amper variable to check no of records/lines regardless of output format.?
Or is there any equivalent for XML output format.


WF8206,Windows 7,8,10
HTM,PDF,EXCEL
 
Posts: 229 | Location: MI | Registered: September 13, 2017Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Output format XML and count the no of lines

Copyright © 1996-2020 Information Builders