Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Stardust/Knowledge Base/Infrastructure System Administration Maintenance/SQL"
(New page: = SQL Commands Cookbook<br> = NOTE to authors: Please make sure to specify the IPP version on which a command was executed<br> === Retrieving structured data initialized with non-null ...) |
|
(No difference)
|
Revision as of 23:50, 18 October 2011
SQL Commands Cookbook
NOTE to authors: Please make sure to specify the IPP version on which a command was executed
Retrieving structured data initialized with non-null or null value (plus non-leaf data in the data structure)
IPP Version: 5.3.x
SELECT pd.ID, pi.OID, SUBSTR(sd.XPATH,1,20) as "XPATH", SUBSTR(sdv.STRING_VALUE,1,20) as "STRING_VALUE", sdv.NUMBER_VALUE FROM PROCESS_INSTANCE pi, PROCESS_DEFINITION pd, DATA_VALUE dv, STRUCTURED_DATA sd, STRUCTURED_DATA_VALUE sdv WHERE pd.OID = pi.processDefinition and pi.OID = dv.processInstance and dv.data = sd.data and sd.OID = sdv.XPATH and pi.OID = sdv.processInstance;
Retrieving structured non-initialized data
IPP Version: 5.3.x
SELECT pd.ID, pi.OID, SUBSTR(sd.XPATH,1,20) as "XPATH" FROM PROCESS_INSTANCE pi, PROCESS_DEFINITION pd, DATA_VALUE dv, STRUCTURED_DATA sd WHERE pd.OID = pi.processDefinition and pi.OID = dv.processInstance and dv.data = sd.data and sd.OID not in ( select sdv2.XPATH from structured_data_value sdv2 where sdv2.processinstance = pi.OID );