Resolution:
Description:
============
In a record query webservice, regardless of the value set for ACTIVE flag, deleted records are returned.

Environment:
============
TIBCO Product name and version: TIBCO Collaborative Information Manager 8.0.1
Operating System(s): All Operating Systems

Symptoms:
============

Both the following requests return the deleted records in the repository:

    &ltTransaction>
        &ltCommand type="Query">
            &ltMasterCatalogRecord etype="Entity">
                &ltExternalKeys>
                    &ltKey name="MASTERCATALOGNAME" type="string"&gtACT</Key>
                    &ltKey name="PRODUCTID">*</Key>
                    &ltKey name="ACTIVE"&gtN</Key>
                </ExternalKeys>
            </MasterCatalogRecord>
        </Command>
    </Transaction>

    &ltTransaction>
        &ltCommand type="Query">
            &ltMasterCatalogRecord etype="Entity">
                &ltExternalKeys>
                    &ltKey name="MASTERCATALOGNAME" type="string"&gtACT</Key>
                    &ltKey name="PRODUCTID">*</Key>
                    &ltKey name="ACTIVE"&gtY</Key>
                </ExternalKeys>
            </MasterCatalogRecord>
        </Command>
    </Transaction>


Cause:
======
A defect has been logged.

Resolution:
=========
As a workaround, to retrieve deleted records use the following request:

        &ltTransaction>
            &ltCommand type="Query">
            &ltMasterCatalogRecord etype="Entity">
            &ltExternalKeys>
            &ltKey name="MASTERCATALOGNAME" type="string"&gtACT</Key>
            &ltKey name="PRODUCTID">*</Key>
            &ltKey name="ACTIVE"&gtN</Key>
            </ExternalKeys>
            </MasterCatalogRecord>
            </Command>
        </Transaction>

and to retrieve active records, use the following request:

        &ltTransaction>
            &ltCommand type="Query">
            &ltMasterCatalogRecord etype="Entity">
            &ltExternalKeys>
            &ltKey name="MASTERCATALOGNAME" type="string"&gtACT</Key>
            &ltKey name="PRODUCTID">*</Key>
            &ltKey name="RECORD_STATE"&gtCONFIRMED</Key>
            </ExternalKeys>
            </MasterCatalogRecord>
            </Command>
        </Transaction>


Attachments:
===========
N/A

References:
===========
None

In record query webservice irrespective of the value set for ACTIVE flag, deleted records are returned.