Need to run queries to identify certain data set for analysis and it would be quick to get reports with sql on DB client itself. This is an iterative process (with different criterias each time), hence looking for sql option.
@ANKIT_D Using BIX extract data can be retrieved from BLOB irrespective of DB that is used. If its above 8.x pega version PegaBIX comes as part of product itself. Configure the RSV in your application and formulate an extract and execute it manually.
Here is how you can retrieve data from a property that is not optimized (i.e. Blob), using SQL.
1. First of all, make sure UDF "pr_read_from_stream" is installed in your database.
2. Run below query. In this example, I am trying to obtain value from "MyBlobProperty" property of a work object whose pzInsKey is "MyCo-MyApp-Work P-1". Transform this SQL to meet your needs in your environment.
select rules.pr_read_from_stream('.MyBlobProperty', pzInsKey, pzPVStream)
where pzinskey = 'MYCO-MYAPP-WORK P-1';