Hi Stephanie,

In the available hierarchies (in DB Config), first expand "Objects" then "Object Components" and select "Current Location Transaction." Sublevel is listed here for you to drag and drop to your desired Query Group to be available to front-end users.

Best,
Laura

Laura Wenzel
Collection Database Administrator
Phoenix Art Museum
[log in to unmask]

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Stephanie Lyon
Sent: Friday, August 23, 2013 3:58 PM
To: [log in to unmask]
Subject: Re: Query on Location SubLevel field

I do not see the ObjLocations table through the DBCONFIG Query Groups function.  Is there a configuration setting that controls which database tables and fields show up in the Query Group function?


-----You wrote----------

Re: Query on Location SubLevel field
Friday, August 23, 2013 2:42 PM

From: 
    "Smith Jeffrey" <[log in to unmask]>
To: 
    undisclosed-recipients

Sublevel is in ObjLocations., which is your object/component location history field.

-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Stephanie Lyon
Sent: Friday, August 23, 2013 4:29 PM
To: [log in to unmask]
Subject: Query on Location SubLevel field

I am looking to 'expose' the location SubLevel field to the frontend for user queries.

This field is on the MoveAssistant screen.  You can supply a numeric Level value and a text SubLevel value.  The Level value shows up in the current location query list.  I am unable to location the SubLevel field in neither the user interface, nor the DBConfig query groups area.

Since both Level and SubLevel are displayed front and center with the current location information it seems it must be there and I am just not finding it.  I am thinking maybe it has a different label than SubLevel in the field lists?

Thanks,
Stephanie Lyon
IT
Museum of International Folk Art

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.

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.