Hi, 
I have not seen the webinar and the SQL query for flex fields can be very different depending on what you are looking for. But below is two examples for finding the objects having flex fields with some special values. Asuming you are planning to use the build-in functions for alerts in TMS. I hope that can help.

--Example 1: Search for values from only one flex field name.
--In this example: Flex field name 'Levereras' has value 'Bokat' and ValueDate is NULL
Select Objects.ObjectNumber, UserFields.UserFieldName, UserFieldXrefs.FieldValue, UserFieldXrefs.ValueDate
from UserFields
Inner join UserFieldXrefs ON UserFieldXrefs.UserFieldID = UserFields.UserFieldID
Inner join Objects ON Objects.ObjectID = UserFieldXrefs.ID AND UserFieldXrefs.ContextID = 1
--Set flex field name and value to search for. Also added if ValueDate is NULL
 Where ( UserFields.UserFieldName = 'Levereras' AND UserFieldXrefs.FieldValue = 'Bokat' AND UserFieldXrefs.ValueDate Is Null )
Order by Objects.ObjectNumber


--Example 2: Compare two specific values from two different flex fields names.
--In this example: Flex field name 'Levereras' has value 'Preliminärt' and flex field name 'Uppackad' has value '1' and
Select Objects.ObjectNumber
from UserFields
Inner join UserFieldXrefs ON UserFieldXrefs.UserFieldID = UserFields.UserFieldID
Inner join Objects ON Objects.ObjectID = UserFieldXrefs.ID AND UserFieldXrefs.ContextID = 1
-- Set name and value for the first flex field to search for below.
 Where ( UserFields.UserFieldName = 'Levereras' AND UserFieldXrefs.FieldValue = 'Preliminärt' )
-- Set name and value for the second flex field to search for below.
 OR ( UserFields.UserFieldName = 'Uppackad' AND UserFieldXrefs.FieldValue = '1')
Group BY Objects.ObjectNumber
Having Count(*) = 2
Order by Objects.ObjectNumber

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.