You are viewing limited content. For full access, please sign in.

Question

Forms Version 10

Updated July 25, 2017

asked on July 25, 2017

When using the Laserfiche Users (cf_users) in lookups for Drop-Down Lists, can I eliminate any system users from the drop-down list?

0 0

Answer

SELECTED ANSWER

replied on July 25, 2017 • Show version history

I would recommending adding a View to your LFForms database, and use the lookup on that instead of directly from the cf_users table.

Your View could be pretty simple, like this one that pulls in everything from the cf_users table that does NOT start with the text "svc-"

SELECT username, displayname 
FROM cf_users
WHERE username NOT LIKE 'svc-%'

0 0