| Table of Contents | ||||
|---|---|---|---|---|
|
...
How does it work in the search window?
Select Create field in the search window toolbar, then select the Conditional operation. You need to specify three arguments:
Argument | Description | Data type |
|---|---|---|
if mandatory | Boolean field that will be used as the base of your condition. | boolean |
then mandatory | The value you specify here will be returned if the value of the Boolean field is true. | Any |
else mandatory | The value you specify here will be returned if the value of the Boolean field is false. | Same than or compatible with the data type selected in then (for example, integer and float are compatible types) |
The data type of the output values depends on the types selected in the then and else arguments.
Example
In the demosiem.logtrust.ecommerceweb.dataactivity table, we want to add a field that shows the string Client error responsesDelayed response when the values in our statusCoderesponseTime field are 4xx or 5xx codesabove 1, and Succesful Timely response when they are 2xx1 or below. To do itthis, we will create a new field using the Conditional operation but first, we need to create a Boolean field that detects client error responses.delayed responses (above 1)..
Step 1: Detect client error responses
The first step is creating a Boolean field that shows true when the codes numbers in the statusCode responseTime field are 4xx or 5xxabove 1, and false when they are 2xx1 or below. To do itthis, we will add a new field using the Greater or equal (ge, >=) the
Value - statusCode responseTime field
is greater than or equal to - Click the pencil icon and enter 400 1
...
Step 2: Create a new field using the Conditional operation
Select Create field on the query toolbar, then select Conditional as the operation. Fill the arguments as follows, and enter a name for the field (responseTyperesponseTimeDuration):
if - statusCode_type responseTime>1 field
then - Click the pencil icon and enter Client error Delayed response
else - Click the pencil icon and enter Successful Timely response
...
Click Create field and you will get the following result:
...
ifthenelse(boolean, value1_true, value2_false)
Example
You can copy the following LINQ script and try the above example on the demosiem.logtrust.ecommerceweb.dataactivity table.
| Code Block |
|---|
from demosiem.logtrust.ecommerceweb.dataactivity select statusCoderesponseTime > 4001 as statusCode_type`responseTime>1`, ifthenelse(statusCode_type`responseTime>1`, "ClientDelayed error response", "SuccessfulTimely response") as responseTyperesponseTimeFrame |