Hi Amber
There’s a special form for querying FlexFields, accessed via Advance Query: please see the attached.
Basically, select the FlexField Query Group and then Field Value from the drop-down; click on the zoom box and a new form appears where you can build your query. Let me know if you don’t receive the attachment (not sure if it will be included when replying to ListServ).
Best wishes
Jon
Jon Thristan | Project Consultant
[log in to unmask] | +44 20 7993 8402
GallerySystems | www.gallerysystems.com
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Morgan, Amber
Sent: 22 October 2012 18:55
To: [log in to unmask]
Subject: Searching flex fields
Has anyone been able to successfully search flex fields using the advanced query in TMS2010? I used to do this in 9.35 but it’s not working for me anymore. I’ve checked the configuration for queries and the fields are seemingly available. I get as far as you see in the image below, but the drop down menu for “Relation” won’t drop down, and I can’t type anything in for “Field Value.” Is there a possibility that I have something configured incorrectly? I don’t have access to the backend so I have to do all of my queries through TMS so I’m really hoping there’s a way to do this.
the warhol:
Amber E. Morgan
Associate Registrar
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org
The
One of the four Carnegie Museums of Pittsburgh
Email newsletter http://members.carnegiemuseums.org/email
Membership http://members.carnegiemuseums.org/SupportCMP
warhol: facebook | warhol: twitter
The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies. Any views expressed in this message are those of the individual sender.
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.