Posted: 22 Feb 2016 14:22 EST Last activity: 24 Feb 2016 14:36 EST
I am new to BIX. I know BIX is a java tool that can extract data from BLOB (pzPVStream) and write data into specified format, such as XML, CSV etc.
In our application, we have work object of class "ACME-Work", whenever a work object is saved, we use database trigger (please note, this is not PRPC Rule-Declare-Trigger) to insert the BLOB from work table into an "AuditHistory" table.
We also have a class "AuditHistory-ACME-Work", which maps to this "AuditHistory" table; even though in the pzPVStream column, it contains the BLOB data of "ACEM-Work" work object.
The question is:
How to configure BIX, to make it extract data from pzPVStream of "AuditHistory" table, and knows that data in BLOB is of class "ACEM-Work", and generate output file correctly? Is it possible out-of-box? We are using PRPC 6.2 SP2
1) AuditHistory-ACME-Work does not inherit from ACME-Work currently, but we can make it so. They are not part of same classgroup. They are in separate tables.
2) We are using the get all properties option. We will try create extract rule on AuditHistory-ACME-Work, and see whether it works.
My question to you, does your comments above imply that if "get all properties option" is used, then BIX will ignore the pxObjClass and property definition in the class etc. , and it will dump whatever in the BLOB into a XML file, without validation etc? Actually, that is what we need, Can you please confirm?
My note was to make you aware if you select specific properties to extract and that has pxObjClass as one of the properties because the class of the extract is different from what is stored in the table, the extract will fail.
In the extract rule, we used "get all properties option". The apply to class of the extract rule is "AuditHistory-ACME-Work".
Class "AuditHistory-ACME-Work" maps to a table. In the table, in the pxObjClass column, we set the value to "AuditHistory-ACME-Work". In the same table, in pzPVStream, we insert the BLOB of work object "ACME-Work"
BIX runs, and get XML from the BLOB without any issue.
Apparently, BIX does not perform validation when "get all properties option" is used to generate XML.