AnsweredAssumed Answered

Displaying an icon in a portal based on a value in join table

Question asked by duncanbaker on Mar 9, 2013
Latest reply on May 7, 2013 by wrwaugh

Hi folks

 

Been banging my head against this wall most of the day, so time to reach out... In simple terms, I have:

Devices - DEV (say a computer)

Accessories - ACC (say a printer)

ACC get assigned to DEV via a join table JDA

 

I want to indicate if the ACC (in this case printer) is the default ACC for the device, so I have a field in JDA "Default" which is populated with "Yes" via a script if the user selects it as a default device.

 

I have a portal based on DEV going dev>jda>acc - portal works fine for the name of the ACC etc. But I want to display an icon in the portal if the ACC is default.

 

So I'm trying to set up a calculated container field such that if in the join, Default = Yes then container field = stored global container field and of course it's shown on the portal.

 

I've got close with:

Case (

dev.JDA_JoinDeviceAccessory::Default = "Yes" ;

dev.ZRE_z_Resources~Cartesian::Icon_DefaultPrinter_g ;

""
)

 

but this shows an icon for all instances of the printer on all DEV records. I know I've had to deal with this kind of thing before, but it's been a while and I'm stumped - might be something to do with a List function? Any help appreciated, or if I need to clarify anything, let me know.

 

Thanks

Outcomes