BI Publisher Conditions
We are in the process of updating our Employee Offer Letters in BI Publisher and we are not having much success getting 2 different paragraphs to display based on the Job Code the new employee will be hired into.
We would like different verbiage to display is they are SAL employee's vs HRLY and Union employees. The job codes for the Salaried start with an "S" and job codes for non salaried start with either "N", "O" or "U".
I have tried using a wild card '%' in the condition and also using an "if substr" code to only look at the 1st character in the job code and neither of these give us the desired results.