INSERT INTO

INSERT INTO TableName
(TableName.CLIENT,
TableName.ENTITY,
TableName.CREATEDBY,
TableName.CREATEDATE,
TableName.UPDATEDBY,
TableName.UPDATEDBY,
TableName.INTERVINIENTTYPEID,
TableName.INTERVINIENTSRELATIONSHIPID,
TableName.[ClientNumber],
TableName.[EntityNumber])

SELECT TableName.[Id], TableName5.[Id],
'7',GETDATE(),'7',GETDATE(),
TableName2.[Id], TableName3.[Id],
TableName4.LTNCLI,TableName4.LTNTIT
FROM
[DataBaseName].[dbo].[TableName4]
LEFT JOIN DataBaseName.dbo.TableName ON LTRIM(RTRIM(TableName4.[LTNCLI])) = LTRIM(RTRIM(TableName.[ClientNumber]))
LEFT JOIN DataBaseName.dbo.TableName5 ON LTRIM(RTRIM(TableName4.[LTNTIT])) = LTRIM(RTRIM(TableName5.[EntityNumber]))
LEFT JOIN DataBaseName.dbo.TableName2 ON TableName4.[LTRCLI] = TableName2.[ExternalCode]
LEFT JOIN DataBaseName.dbo.TableName3 ON TableName4.[LTRCPE] = TableName3.[Description]
AND TableName3.[isActive] = 1
Read More

Duplicated records

SELECT "Key and/or Foreign Key" ,COUNT(1)
FROM "TableName"
GROUP BY "Key and/or Foreign Key"
HAVING COUNT(1) > 1
Read More

Import Excel to SQL

BULK INSERT 'tablename ' FROM 'path filename.csv'

WITH (FIELDTERMINATOR = ';');
Read More

Service Studio 4.X

ServiceStudio-4.2.4.63

ServiceStudio-4.2.4.54

ServiceStudio-4.2.4.51

ServiceStudio-4.2.4.49

ServiceStudio-4.2.4.43

ServiceStudio-4.2.4.38

ServiceStudio-4.2.4.33

ServiceStudio-4.2.4.26

ServiceStudio-4.2.4.21

ServiceStudio-4.2.4.20

ServiceStudio-4.2.4.18

ServiceStudio-4.2.4.16

ServiceStudio-4.2.4.15

ServiceStudio-4.2.4.13

ServiceStudio-4.2.4.12

ServiceStudio-4.2.4.9

ServiceStudio-4.2.4.8

ServiceStudio-4.2.4.5

ServiceStudio-4.1.3.61

ServiceStudio-4.1.3.58

ServiceStudio-4.1.3.55

ServiceStudio-4.1.3.47

ServiceStudio-4.1.3.42

ServiceCenter-4.1.3.69
Read More

Plataform Server 4.X

PlatformServer-4.2.4.26

PlatformServer-4.2.4.23

PlatformServer-4.2.4.20

PlatformServer-4.2.4.19

PlatformServer-4.2.4.16

PlatformServer-4.2.4.15

PlatformServer-4.2.4.13

PlatformServer-4.2.4.12

PlatformServer-4.2.4.8

PlatformServer-4.2.4.5

PlatformServer-4.2.4.62

PlatformServer-4.2.4.54

PlatformServer-4.2.4.51

PlatformServer-4.2.4.49

PlatformServer-4.2.4.45

PlatformServer-4.2.4.43

PlatformServer-4.2.4.38

PlatformServer-4.2.4.33
Read More

Integration Studio Version 4.X

IntegrationStudio-4.2.4.55

IntegrationStudio-4.2.4.49

IntegrationStudio-4.2.4.43

IntegrationStudio-4.2.4.38

IntegrationStudio-4.2.4.13

IntegrationStudio-4.2.4.26

IntegrationStudio-4.2.4.38_2

IntegrationStudio-4.2.4.16

IntegrationStudio-4.2.4.15

IntegrationStudio-4.1.3.48

IntegrationStudio-4.2.4.9

IntegrationStudio-4.2.4.8

IntegrationStudio-4.2.4.5
Read More

Filter Date

EnterParameters
@dt_Incio
@dt_fim

((@dt_inicio = @Nulldate and @dt_fim = @Nulldate) OR
((CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) >= @dt_inicio AND
(CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) <= @dt_fim))
Read More

How to replace single quotes

How to solution replace " for ' it's simple you can use ASCII table chr(34)


To solve such problems, use the command like this

replace(,chr(34),”'“)
Read More

Nulldate Filter Outsystems/SQL

((@dt_inicio = @Nulldate and @dt_fim = @Nulldate) OR
((CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) >= @dt_inicio AND
(CAST(FLOOR(CAST( {EMAIL}.[Created_DateTime] as FLOAT)) AS DATETIME)) <= @dt_fim)) AND
({EMAIL}.[Subject] LIKE ('%' + @SearchKeyword + '%') OR {EMAIL}.[Message] LIKE ('%' + @SearchKeyword + '%') OR @SearchKeyword = NULL)
Read More

Worldwide Launch of Agile Platform 6.0

Worldwide Launch of Agile Platform 6.0 from OutSystems on Vimeo.

BRUTALLLLLLLLLL
Read More

Table TEMP for BIG Tables(ROWS)

SELECT

    {TRANSACTION}.[Id],{TRANSACTION}.[PostDate],

    {TRANSACTION}.[Iban], {TRANSACTION}.[Amount]

INTO #TEMP

FROM {TRANSACTION}

WHERE {TRANSACTION}.[Nconta]= <variable>

SELECT #TEMP.*

FROM #TEMP

Read More

List Tables used by one eSpace - Query by eSpace Name

SELECT ENESPACE.NAME, ENENTITY.NAME, ENENTITY.PHYSICAL_TABLE_NAME
FROM dbo.ossys_Espace ENESPACE INNER JOIN dbo.ossys_Entity ENENTITY
ON ENENTITY.ESPACE_ID = ENESPACE.ID
WHERE ENESPACE.NAME = 'espacenameHERE'
Read More

Outsystems - Project

Was this schedule developed faster and quicker One PlatformThis program was developed in a fairly rapid implementation of system integration but not just for the purpose of integration.This video demonstrates a WorkFlow ah-doc which shows a procedural flow of a municipality. Covers four types of documents Informaçõess, Pareceress,  Despachoss and Ofícioss which the routing is done via email with attachment document.
Ofícioss are only made to external entities. When shipped generate a random number that follows with the Office by email. The entity receives the email with a URL and the random code embedded where answered.



Read More

Agile Platform 5.1 Introduction - Webinar Recording

In this short 35 minute webinar we provided an introduction to the newest features of the Agile Platform. As an OutSystems customer or partner this will help you understand the new capabilities of the platform and plan for your next project.

During the webinar you will see a live demonstration of the Agile Platform. We will show off many of the new features by demonstrating the creation of a CRM application from scratch – speed to delivery like you have never seen before

Read More

Outsystems

This is the best aplication for integration systems...



Read More