pierresetteskog

TestJjj

pierresetteskog

DELETE issues

POST issues
{
  "mappings": {
    "_default_": {
      "dynamic_date_formats": [
        "yyyy-MM-dd",
        "dd-MM-yyyy",
        "date_optional_time"

pierresetteskog

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

pierresetteskog

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

pierresetteskog

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

pierresetteskog

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)