Make a Image visible by Department in Design Studio

We currently have the script in design studio for employee photos. Because of PII concerns the business only wants the HR dept to view the photos. I was trying to do a formula something like if(table.DEPARTMENT=='54620'|| then image visible = true.

what is the best approach using design studio.

Find more posts tagged with

UI Design

Comments

Legacy Contributor

Is this Syteline ?

CSF SM Project Generation, Invoicing and Collection

Legacy Contributor

No, this is for Lawson 10.0. S3

mseppanen

I do something similar except by Site ID, Use the Condition Rule as a Parent and have a Child Screen Rule that contains the Screen option for the pictures to be executed.

As far as the actual Condition: Setup a Usr Lookup Variable for the User Department and then reference that variable in your Condition to create the boolean.

I do not know how Lawson treats the Login and session tables, but that would be where I would start looking to pull.

Legacy Contributor

I agree with mseppanen,

Create a SQL lookup to grab the department number, then test to see if the lookup resulted in a valid value and is the HR department number; if it is, then set the image variable. If it isnt the HR department, set the image value to "".

I like using the ImageLink variable since you do not have to set it in a screen rule to view the image, it will automatically present in the configurator session. That is, if you are just trying to have the image show in the right hand side.

Suggested Variable Rule Code:

ImageLink =<image file location(s)>

...

Department =usr.Department

Department =IF(IsNullOrBlank(ToString(Department))=False,Department,"")

ImageLink =IF(Department="54620",ImageLink,"")

Copyright © 2025 Infor. All rights reserved.