|
Normally there is no "WHERE" clause generated by BST SQL for loading the resource file, so you will need to add it yourself. You must add the statements with the proper punctuation to work correctly. Any statements you add are inserted into the middle of the SQL statement generated by BST SQL, so you need to have your statements correct and include the appending pipe character at the end of the statement(s). You can add as many lines as you need to the text box.
For example adding this code in the text box prompts yields the following statement generated by BST SQL
' WHERE ' &| ' EMP_AssignedTo = <39>'& CLIP(LOC:MyGroup)&'<39> '&|
! Embed Point OF BSTBooking "Day" Before Header SQL Statement (resources).**** EMPLOYEE{PROP:SQL}=' SELECT ' &| ' EMPLOYEEID, SOCIALSECURITYNUMBER, FIRSTNAME, MIDDLEINITIAL, LASTNAME ' &| ' , ADDRESS_, ADDRESS2, CITY, STATECODE, ZIP ' &| ' , MARITALSTATUS, BIRTHDATE, DATEHIRED, JOBTITLE, DEPARTMENT ' &| ' , EMERGENCYCONTACT, EMERGENCYCONTACTPHONE ' &| ' FROM ' & 'EMPLOYEE' & ' ' &| ' WHERE ' &| ' EMP_AssignedTo = <39>'& CLIP(LOC:MyGroup)&'<39> '&| ' ORDER BY EMPLOYEEID ' ! Embed Point OF BSTBooking "Day" After Header SQL Statement (resources).**** |