herewith the SQL Query
Code: Select all
SELECT
CASE
WHEN ColoursReverse > 0 THEN 2 ELSE 1 END
FROM EstimatePart INNER JOIN MainJobDetails ON EstimatePart.EstimateID = MainJobDetails.EstimateID
WHERE JobNo = '19224'
vvd
Code: Select all
SELECT
CASE
WHEN ColoursReverse > 0 THEN 2 ELSE 1 END
FROM EstimatePart INNER JOIN MainJobDetails ON EstimatePart.EstimateID = MainJobDetails.EstimateID
WHERE JobNo = '19224'
laurentd wrote: ↑Fri Aug 19, 2022 10:57 am Here is an example:
name=[Database.Text:SQL="SELECT Name FROM EnfocusTeam WHERE Initials = '[Metadata.Text:Dataset="Submit",Model="XML",Path="/field-list/field[tag='Initials']/value"]'",Connection="SwitchPublishPrint"]
email=[Database.Text:SQL="SELECT Email FROM EnfocusTeam WHERE Initials = '[Metadata.Text:Dataset="Submit",Model="XML",Path="/field-list/field[tag='Initials']/value"]'",Connection="SwitchPublishPrint"]
Code: Select all
[Database.Text:SQL="SELECT CASE WHEN ColoursReverse > 0 OR 0 = ' ' THEN '2' ELSE '1' END FROM EstimatePart INNER JOIN MainJobDetails ON EstimatePart.EstimateID = MainJobDetails.EstimateID WHERE JobNo = '19244'",Connection="Tharstern"]