Jump to content

T3NN3SS33

Members
  • Content Count

    1
  • Joined

  • Last visited

  1. I am attempting to apply record level security to several calculation fields and I am receiving an error telling me the column from my user table is invalid. I have given some details below, hopefully someone will quickly see my error and get me back on track! This query works well but is not authenticated by user……. IsNull((SELECT COUNT([@field:specimen_ID]) FROM MDx_tbl_specimen WHERE [@field:spec_received] = 'false' AND [@field:spec_released] = 'false' AND [@field:spec_batch_deact_2] = 'true' ),0) This query works but is limited to one user. I only tested this one because I wanted to see where things break down. IsNull((SELECT COUNT([@field:specimen_ID]) FROM MDx_tbl_specimen WHERE [@field:spec_received] = 'false' AND [@field:spec_released] = 'false' AND [@field:spec_batch_deact_2] = 'true' AND [@field:MDx_tbl_specimen_spec_acct_ID] = '1234' ),0) This is the query I need that gives me RLS based on matching ACCT ID field from both user and records of interest – Caspio says it is invalid and gives an error (Invalid Column Name '@authfield:MDx_tbl_users_user_account_ID' . IsNull((SELECT COUNT([@field:specimen_ID]) FROM MDx_tbl_specimen WHERE [@field:spec_received] = 'false' AND [@field:spec_released] = 'false' AND [@field:spec_batch_deact_2] = 'true' AND [@field:MDx_tbl_specimen_spec_acct_ID] = [@authfield:MDx_tbl_users_user_account_ID] ),0)
×