---
# System prepended metadata

title: Untitled

---

```
SELECT 
a.NAME,
a.[TYPE],
c.OPERATOR,
V.*
FROM CONDITIONROW c 
LEFT JOIN ATTRIBUTEDEFINITION a ON a.id = c.ATTRIBUTEDEFINITION_ID 
LEFT JOIN (
	select 
	ca.CONDITIONROW_ID,
	ca.STRINGVALUE,
	ca.NUMERICVALUE,
	ca.DATETIMEVALUE,
--	a.NAME 'Attr Name',
--	a.[TYPE] 'Attr Type',
	a2.LABEL,
--	a2.[TYPE] 'RANGE_TYPE',
	r.CODE
	from CONDITIONDEFINITION ca 
--	LEFT JOIN ATTRIBUTEDEFINITION a ON a.id = ca.ATTRIBUTEDEFINITION_ID
	LEFT JOIN ATTRIBUTERANGE a2 ON a2.id = ca.RANGE_ID 
	LEFT JOIN RULEBASEREFERENCEDATA r on r.id = ca.RULEBASEREFERENCEDATA_ID
	
--	WHERE a.NAME IS NOT NULL
) V ON V.CONDITIONROW_ID = c.ID
```

Hi Nick MH Hsieh (謝明樺) here is the link to the prod https://sng.iam.checkmarx.net/ tenant name is prudential-group

{"dependencies":
    {"alasql":"^4.5.2","deasync":"^0.1.30"},
 "devDependencies":
     {"es-check":"^9.1.2"}
}

------
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.pca.common</groupId>
  <artifactId>pca-common-function</artifactId>
  <version>1.4</version>
  <properties>
		<spring.framework.version>4.3.4.RELEASE</spring.framework.version>
		<java.version>1.8</java.version>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  </properties>
  
  
  <dependencies>
  	<!-- Spring -->
		
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>${spring.framework.version}</version>
		</dependency>

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${spring.framework.version}</version>

		</dependency>
		
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.framework.version}</version>
		</dependency>
		

		
		<!-- Apache Common -->
		<dependency>
			<groupId>commons-collections</groupId>
			<artifactId>commons-collections</artifactId>
			<version>3.2</version>
		</dependency>
		<dependency>
		    <groupId>org.apache.commons</groupId>
		    <artifactId>commons-lang3</artifactId>
		    <version>3.4</version>
		</dependency>
		
		<dependency>
		    <groupId>commons-lang</groupId>
		    <artifactId>commons-lang</artifactId>
		    <version>2.6</version>
		</dependency>
		
		<dependency>
			<groupId>commons-codec</groupId>
			<artifactId>commons-codec</artifactId>
			<version>1.7</version>
		</dependency>
		
		<!-- antlr -->
		<dependency>
			<groupId>antlr</groupId>
			<artifactId>antlr</artifactId>
			<version>2.7.7</version>
		</dependency>
		
		<dependency>
			<groupId>javax.mail</groupId>
			<artifactId>mail</artifactId>
			<version>1.4</version>
		</dependency>
		
		<!-- zip4j -->
		<dependency>
			<groupId>net.lingala.zip4j</groupId>
			<artifactId>zip4j</artifactId>
			<version>1.3.2</version>
		</dependency>
		<!--  Apache Http Client -->
		<dependency>
		    <groupId>org.apache.httpcomponents</groupId>
		    <artifactId>httpclient</artifactId>
		    <version>4.3.3</version>
		</dependency>
				
		<dependency>
		    <groupId>commons-httpclient</groupId>
		    <artifactId>commons-httpclient</artifactId>
		    <version>3.1</version>
		</dependency>
		
		<!-- google gson -->
		<dependency>
			<groupId>com.google.code.gson</groupId>
			<artifactId>gson</artifactId>
			<version>2.3.1</version>
		</dependency>
  </dependencies>
  
  <build>
    <sourceDirectory>src</sourceDirectory>
    <resources>
      <resource>
        <directory>src</directory>
        <excludes>
          <exclude>**/*.java</exclude>
        </excludes>
      </resource>
    </resources>
    <plugins>
	   <plugin>
	        <artifactId>maven-compiler-plugin</artifactId>
	        <version>3.5.1</version>
	        <configuration>
	          <source>${java.version}</source>
			  <target>${java.version}</target>
			  <encoding>${project.build.sourceEncoding}</encoding>
			  <showWarnings>true</showWarnings>
	        </configuration>
	      </plugin>
		
    </plugins>
  </build>
  
  <distributionManagement>
		<!-- use the following if you're not using a snapshot version. -->
		<repository>
			<id>pcalt-releases_1</id>
			<name>PCALT_Releases</name>
			<url>http://ltvc88:8080/nexus/content/repositories/pcalt-releases_1
			</url>
		</repository>
		
	</distributionManagement>
</project>
 
 
<dependency>
			<groupId>com.enterprisedb</groupId>
			<artifactId>edb-jdbc</artifactId>
			<version>17</version>
			<scope>provided</scope>
		</dependency> 
        
        
https://github.com/jasonSOUI/TimeCard/tree/master        



set "JAVA_HOME=C:/tools/jdk-17.0.10+7/"
 kafka-storage.bat random-uuid
 
kafka-storage.bat format --standalone -t E8isf76cSZaAv2rQkgv2Pw -c ../../config/server.properties

kafka-server-start.bat ../../config/server.properties