Skip to main content
Question

Section Department System Lookup Filter Expression

  • December 8, 2022
  • 1 reply
  • 141 views

Forum|alt.badge.img

I’ve created two custom fields in assyst, one allows you to select a Branch, and the other should provide a selection list of the Section Departments in that Branch.

 

The Branch system lookup field has a shortcode of ORG BRANCH

 

Here’s my Lookup Filter Expression:

from sectn_dept as SectnDept where SectnDept.section.branch.shortCode = @*@$new.W("ORG BRANCH").shortCode@*@ and SectnDept.csg.shortCode = 'SHARED'

 

This works in assystNET (Self-Service Portal).

 

If I attempt to alter the value via assystWEB, I get an application error.  So, I’m guessing my filter expression is incorrect.

 

Has anyone any advice?

 

Thanks

Robert Wood
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • January 10, 2023

Hi Alistair, 

It does sound like something is going wrong somewhere. It’s a little tricky to diagnose here on the community forum, I’d probably suggest logging a ticket with the support team to have a closer look.

If you can replicate the issues and provide a server log that covers the time of replication the error message thrown should give them a good starting point.

Cheers,
Robert


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings