Question
NASCO
US
Last activity: 21 Feb 2017 6:36 EST
How to send BLOB data directly to the consumers in excel sheet without using BIX extract.
How to send BLOB data directly to the consumers in excel sheet without using BIX extract.
Pegasystems Inc.
IN
Hi Krishna, Good morning!
- could we try reading ....
- through Obj- methods
- build a page list
- then pass the page list to RULE-OBJ-ACTIVITY @BASECLASS PXCONVERTRESULTSTOCSV
Please share your thoughts/comments, Thank you!
psahukaru
NASCO
US
Hello,
Thank you!
Can we do anything from the DB side without using Pega?
Regards,
Krishna!
Pegasystems Inc.
IN
or would creating a report definition be of quick use/help?
Pegasystems
IN
Quick question for understanding: The BLOB is a compressed Pega specific format of representing the data (in clipboard). It is essentially a byte stream that only Pega platform can make sense of. Please clarify why you would need that stream in Excel?
Murex
LB
I believe you can use a UDF to read the values of a specific property from within the BLOB. Maybe then you could export the results of the query to xls or csv?
Pegasystems
IN
Note that UDF queries are extremely slow and can only work with scalar references. So if your BLOB contains a nested structure, then it would not be possible to get all entries. Example - page list property where the list may have different number of entries in each row.
Tech Mahindra
IN
Is there any pega libraries available or any other means to extract the BLOB into a readable format (could be XML) without using pega application. External teams have access to database so need to know how can they access BLOB content?
This comment has been branched out as a new node and the new thread can be followed here
Pegasystems Inc.
IN
Hi Naveen,
You have replied to an older thread which lacks activity. To gather better visibility for your question, I have branched it to a new question. You may continue your conversation on this thread: https://pdn.pega.com/community/product-support/question/there-any-pega-libraries-available-or-any-other-means-extract
Hope the information is helpful.
Thanks!