Question

Section Department System Lookup Filter Expression

  • 8 December 2022
  • 1 reply
  • 101 views
A
Rank
Badge

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

1 reply

Robert Wood
Rank
Userlevel 3
Badge +11

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


Terms & ConditionsCookie settings