Compare text

Find the difference between two text files

Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Tools
Diffchecker Desktop icon
Diffchecker Desktop The most secure way to run Diffchecker. Get the Diffchecker Desktop app: your diffs never leave your computer!Get Desktop

Untitled diff

Created Diff never expires
56 removals
Lines
Total
Removed
Words
Total
Removed
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
149 lines
6 additions
Lines
Total
Added
Words
Total
Added
To continue using this feature, upgrade to
Diffchecker logo
Diffchecker Pro
101 lines
{
{
"meta": {
"meta": {
"$_GET": [
"$_GET": [
{
{
"type": "text",
"type": "text",
"name": "userid"
"name": "userid"
},
},
{
{
"type": "text",
"type": "text",
"name": "sort"
"name": "sort"
},
},
{
{
"type": "text",
"type": "text",
"name": "dir"
"name": "dir"
}
}
]
]
},
},
"exec": {
"exec": {
"steps": {
"steps": {
"name": "queryUserLocations",
"name": "queryUserLocations",
"module": "dbconnector",
"module": "dbconnector",
"action": "select",
"action": "select",
"options": {
"options": {
"connection": "CandSv3",
"connection": "CandSv3",
"sql": {
"sql": {
"type": "select",
"type": "select",
"columns": [
"columns": [
{
{
"table": "LL_Location",
"table": "LL_Location",
"column": "LocationId",
"column": "LocationId",
"schema": "dbo"
"schema": "dbo"
},
},
{
{
"table": "LL_Location",
"table": "LL_Location",
"column": "LocationName",
"column": "LocationName",
"schema": "dbo"
"schema": "dbo"
}
}
],
],
"params": [
"params": [],
{
"operator": "equal",
"type": "expression",
"name": ":P1",
"value": "{{$_GET.userid}}",
"test": ""
}
],
"table": {
"table": {
"name": "LL_Location",
"name": "LL_Location",
"schema": "dbo"
"schema": "dbo"
},
},
"primary": "LocationId",
"primary": "LocationId",
"joins": [
"joins": [
{
{
"table": "DL_SiteUserLocation",
"table": "DL_SiteUserLocation",
"column": "*",
"column": "*",
"type": "INNER",
"type": "INNER",
"clauses": {
"clauses": {
"condition": "AND",
"condition": "AND",
"rules": [
"rules": [
{
{
"table": "DL_SiteUserLocation",
"table": "dbo.DL_SiteUserLocation",
"column": "LocationID",
"column": "LocationID",
"operator": "equal",
"operator": "equal",
"operation": "=",
"operation": "=",
"value": {
"value": {
"table": "LL_Location",
"table": "LL_Location",
"column": "LocationId"
"column": "LocationId"
},
}
"schema": "dbo"
}
}
]
]
},
},
"primary": "UserLocationID",
"primary": "UserLocationID",
"schema": "dbo"
"schema": "dbo"
}
}
],
],
"wheres": {
"wheres": {
"condition": "AND",
"condition": "AND",
"rules": [
"rules": [],
{
"id": "dbo.LL_Location.IsActive",
"field": "dbo.LL_Location.IsActive",
"type": "boolean",
"operator": "equal",
"value": true,
"data": {
"table": "LL_Location",
"column": "IsActive",
"type": "boolean",
"columnObj": {
"type": "boolean",
"nullable": true,
"name": "IsActive"
},
"schema": "dbo"
},
"operation": "="
},
{
"id": "dbo.DL_SiteUserLocation.UserID",
"field": "dbo.DL_SiteUserLocation.UserID",
"type": "string",
"operator": "equal",
"value": "{{$_GET.userid}}",
"data": {
"table": "DL_SiteUserLocation",
"column": "UserID",
"type": "text",
"columnObj": {
"type": "uuid",
"nullable": true,
"name": "UserID"
},
"schema": "dbo"
},
"operation": "="
}
],
"conditional": null,
"conditional": null,
"valid": true
"valid": true
},
},
"orders": [
"orders": [
{
{
"table": "LL_Location",
"table": "LL_Location",
"column": "LocationName",
"column": "LocationName",
"direction": "ASC",
"direction": "ASC",
"schema": "dbo",
"recid": 1,
"recid": 1
"schema": "dbo"
}
}
],
],
"query": "select [dbo].[LL_Location].[LocationId], [dbo].[LL_Location].[LocationName] from [dbo].[LL_Location] inner join [dbo].[DL_SiteUserLocation] on [dbo].[DL_SiteUserLocation].[LocationID] = [LL_Location].[LocationId] where [dbo].[LL_Location].[IsActive] = @p0 and [dbo].[DL_SiteUserLocation].[UserID] = @p1 order by [dbo].[LL_Location].[LocationName] ASC"
"query": "select [dbo].[LL_Location].[LocationId], [dbo].[LL_Location].[LocationName] from [dbo].[LL_Location] inner join [dbo].[DL_SiteUserLocation] on [dbo].[DL_SiteUserLocation].[LocationID] = [LL_Location].[LocationId] order by [dbo].[LL_Location].[LocationName] ASC"
}
}
},
},
"output": true,
"output": true,
"meta": [
"meta": [
{
{
"type": "text",
"type": "text",
"name": "LocationId"
"name": "LocationId"
},
},
{
{
"type": "text",
"type": "text",
"name": "LocationName"
"name": "LocationName"
}
}
],
],
"outputType": "array"
"outputType": "array"
}
}
}
}
}
}
Saved diffs