DeleteData

Description

Deletes data in the database according to the given TransferDef. The data will be deleted in reversed nesting level order. Rows appurtenant in underlying levels will also be deleted.

Signature
int DeleteData(string key, TransferDef transferDef)

Parameters

Name Data Type Description

key

string required

The authentication key

transferDef

TransferDefBase required

The transfer definition object. It can be a SimpleTransferDef or a TransferDef object.

Response

Data Type Description

int

Number of deleted rows.

Example

var communityPanelSoapClient = new CommunityPanelSoapClient();

/* Delete all panelists with panelist Id between 20 - 200*/
var transferDef = new TransferDef
            {
                ProjectId = "p123456789",
                AllChildrenLevels = true,
                Where = new WhereClause
                {
                    Item = new BinaryLogic
                    {
                        Type = LogicType.AND,
                        Item = new BinaryComparison
                        {
                            Item = new QueryForm
                            {
                                Name = "responseid"
                            },
                            Item1 = new QueryConstant
                            {
                                Value = "20"
                            },
                            Type = ComparisonType.GreaterThanOrEqual
                        },

                        Item1 = new BinaryComparison
                        {
                            Item = new QueryForm
                            {
                                Name = "responseid"
                            },
                            Item1 = new QueryConstant
                            {
                                Value = "200"
                            },
                            Type = ComparisonType.LessThanOrEqual
                        }
                    }
                }
            };

var numberOfDeletedRows = communityPanelSoapClient.DeleteData(key, transferDef);