We created a custom Single-Select field on our contact user forms.We want to use the values in a Lookup Filter expression on our forms to restrict the results of our Single-Select Contact User field but cannot find the correct syntax to include:We’ve tried multiple variations like below:FROM usr as contactUser WHERE contactUser.$W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’FROM usr as contactUser WHERE contactUser.$new.W(‘RAD’).shortCode = ‘ADULT REPRESENTATION SERVICES’Currently on version 11.6.3 of assyst.Any ideas?
Does anybody have a method for telling if an authorization task was flagged as not authorized so that we can generate the following tasks dynamically? Currently, we use a decision task following the authorization that uses the function below (called in AP) to evaluate the answer and take a decision. However, this doesn’t work in workflows that have multiple authorizations occurring at the same time since it evaluates whether any “Not Authorized” was taken.function evalAuthTasks(parmEventId) --LOGGER:info("First line in evalAuthTasks") local sSql = [[SELECT COUNT(id.u_num2) NOTAUTH_COUNT FROM act_reg ar INNER join act_type at on at.act_type_id = ar.act_type_id INNER join inc_data id on id.incident_id = ar.incident_id INNER join incident i on i.incident_id = ar.incident_id INNER join incident i2 on i2.incident_id = id.u_num2 WHERE id.u_num2 = (select u_num2 from inc_data WHERE incident_id = ]] .. parmEventId .. [[) and at.act_typ
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.