Pierre setteskog pierresetteskog
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| TestJjj |
pierresetteskog
/ elasticsearch
Last active
August 29, 2015 14:18
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELETE issues | |
| POST issues | |
| { | |
| "mappings": { | |
| "_default_": { | |
| "dynamic_date_formats": [ | |
| "yyyy-MM-dd", | |
| "dd-MM-yyyy", | |
| "date_optional_time" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE PROC [dbo].[SearchAllTables] | |
| ( | |
| @SearchStr nvarchar(100),@ColName nvarchar(128)=NULL | |
| ) | |
| AS | |
| BEGIN | |
| -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. | |
| -- Purpose: To search all columns of all tables for a given search string |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT EnovaCmsSiteGroup.Identifier, EnovaController.Guid AS controller, EnovaAction.Guid AS action, EnovaViewData.Guid AS viewdata, EnovaView.Guid AS enovaview, EnovaAction.ID AS actionid, | |
| EnovaView.ID AS viewid | |
| FROM EnovaViewData LEFT OUTER JOIN | |
| EnovaView ON EnovaViewData.ID = EnovaView.ViewDataID RIGHT OUTER JOIN | |
| EnovaCmsSiteGroup ON EnovaViewData.SiteID = EnovaCmsSiteGroup.ID LEFT OUTER JOIN | |
| EnovaController LEFT OUTER JOIN | |
| EnovaAction ON EnovaController.ID = EnovaAction.ControllerID ON EnovaCmsSiteGroup.ID = EnovaController.SiteID | |
| WHERE (EnovaView.Deleted = 0) AND (EnovaViewData.Deleted = 0) AND (EnovaCmsSiteGroup.Deleted = 0) AND (EnovaController.Deleted = 0) AND (EnovaAction.Deleted = 0) | |
| ORDER BY EnovaCmsSiteGroup.Identifier, controller, action |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT EnovaCustomer.FirstName, EnovaCustomerAddress.Street, EnovaCustomerAddress.PostalAddress, EnovaCustomerAddress.PostalCode, EnovaCustomerAddress.City, EnovaCustomerAddress.State, | |
| EnovaCustomerAddress.CountryName, EnovaCustomer.LastName, EnovaCustomer.SiteID, WebFoundationRole.ID AS RoleId, EnovaCustomerGroup.ID AS GroupId, WebFoundationRole.Name_lang1, | |
| EnovaCustomerGroup.Name_lang1 AS Expr1, WebFoundationRole.Name_lang2, WebFoundationRole.Name_lang3, WebFoundationRole.Name_lang4, WebFoundationRole.Name_lang5, | |
| EnovaCustomerGroup.Name_lang2 AS Expr2, EnovaCustomerGroup.Name_lang3 AS Expr3, EnovaCustomerGroup.Name_lang4 AS Expr4, EnovaCustomerGroup.Identifier, | |
| WebFoundationRole.Identifier AS Expr5 | |
| FROM LinkUserToUserGroup LEFT OUTER JOIN | |
| WebFoundationRole ON LinkUserToUserGroup.ID2 = WebFoundationRole.ID LEFT OUTER JOIN | |
| EnovaCustomerGrou |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT EnovaAction.Guid, EnovaController.Guid AS Expr1, EnovaViewData.Guid AS Expr2, EnovaController.SiteID, EnovaCmsSiteGroup.Name_lang1, EnovaViewData.ID AS viewdataid, EnovaAction.ID AS actionid, | |
| EnovaController.ID AS controllerid, EnovaView.ID AS viewid | |
| FROM EnovaViewData INNER JOIN | |
| EnovaView ON EnovaViewData.ID = EnovaView.ViewDataID INNER JOIN | |
| EnovaAction INNER JOIN | |
| EnovaController ON EnovaAction.ControllerID = EnovaController.ID INNER JOIN | |
| EnovaCmsSiteGroup ON EnovaController.SiteID = EnovaCmsSiteGroup.ID ON EnovaViewData.ID = EnovaAction.ViewDataID | |
| WHERE (EnovaViewData.Deleted = 0) AND (EnovaAction.Deleted = 0) AND (EnovaController.Deleted = 0) AND (EnovaCmsSiteGroup.Deleted = 0) AND (EnovaView.Deleted = 0) |