Jump to content
  • 0

Use 'contains' in a calculated field


Question

Does anyone know how to use 'contains' in a calculated field to see if the field contains a certain value, instead of using = to equal it. 

I have a tale with records that have a field with values like  524_789B, 524_788B, 524_794B, 524_791B, 524_1047B.

And an authenticated field value might be 524_794B.

I want to count the number of records that contain 524_794B. So in a calculated field I need something like below:

SELECT COUNT (ItemID)
FROM _V_Items Where  Assigned_To CONTAINS '[@authfield:Users_CID_StaffID]'

What is the syntax for 'contains'? 

Link to post
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...