Reference Qualifier "Does not contain"

[roxaneamanda1]

Hi,

I have created a u_type field on the a reference table, I have then added Reference qual:typeCONTAINS......... which works fine and only displays the values in the reference field where the type is as specified,

however, I would like to say typeDOES NOT CONTAIN??? can anyone help me to do this?

Thanks

[brad_hicks]

I believe the DOES NOT CONTAIN equates to NOT LIKE.   If you put typeNOT LIKE..... that should do what you want.

[JordanLind]

You can use the breadcrumb filter to get the syntax for a qualifier.

Build your filter on the table you want to reference, and then right click on the ending breadcrumb, select Copy query.

A pop up will appear containing the syntax you can use in your qualifier.   Copy and paste that value into the qualifier field.