Hi Isomorphic,
same area as this one, but less important for me. In this request, the velocity variable is not replaced (11.1p_2018-04-11):
employees.ds.xml addition:
ARC request to http://127.0.0.1:8888/builtinds/sc/RESTHandler:
Resulting SQL:
Best regards
Blama
same area as this one, but less important for me. In this request, the velocity variable is not replaced (11.1p_2018-04-11):
employees.ds.xml addition:
Code:
<operationBinding operationType="update" operationId="updateSalary" allowMultiUpdate="true">
<criteria _constructor="AdvancedCriteria" operator="and">
<criteria>
<Criterion fieldName="OrgUnit" operator="equals" value="$values.Salary" />
<Criterion fieldName="OrgUnit" operator="equals" value="$criteria.Name" />
</criteria>
</criteria>
</operationBinding>
Code:
<request>
<dataSource>employees</dataSource>
<operationType>update</operationType>
<operationId>updateSalary</operationId>
<data>
<Salary>1000</Salary>
<_constructor>AdvancedCriteria</_constructor>
<operator>and</operator>
<criteria>
<criterion>
<fieldName>Name</fieldName>
<operator>equals</operator>
<value>Ralph Brogan</value>
</criterion>
</criteria>
</data>
</request>
Code:
UPDATE employeeTable SET Salary=1000.0 WHERE ((employeeTable.Name = 'Ralph Brogan' AND employeeTable.Name IS NOT NULL) --good AND ((employeeTable.OrgUnit = '$values.Salary' AND employeeTable.OrgUnit IS NOT NULL) [B]--bad[/B] AND (employeeTable.OrgUnit = '$criteria.Name' AND employeeTable.OrgUnit IS NOT NULL))) [B]--bad[/B]
Blama
Comment