Untitled diff
Erstellt Diff läuft nie ab
54 Entfernungen
| Zeilen | |
|---|---|
| Gesamt | |
| Entfernt | |
| Zeichen | |
| Gesamt | |
| Entfernt | |
5 Hinzufügungen
| Zeilen | |
|---|---|
| Gesamt | |
| Hinzugefügt | |
| Zeichen | |
| Gesamt | |
| Hinzugefügt | |
{
{
"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"
}
}
}
}
}
}