Connect SQL rules
1. We know that using Obj methods is always a good practice and using RDB methods is not a good practice? Is there any particular reason why using RDB methods is not a good practice?
2. In the below example, what happens if the data type of "Column1" and "Property1" doesn't match?
Select Column1 as ".Property1"
3. Is there any significance of Applies To class in which you write a Connect SQL?
For example, if I write a Connect SQL in class "Data-HR-KB-Employee" and my SQL uses the where clause "Data-Customer-Address-Details", what is the background algorithm PEGA uses to execute this CONNETC SQL rule?
Applies to : Data-HR-KB-Employee