TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Sarah Nankivell <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 8 Nov 2016 10:13:37 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (24 lines)
Thank you for your response, however what I am trying to figure out is how to pull by text status. 

I can see that there is a TextStatusID field, which I think would give me the results I'm looking for, but I cannot figure out how to determine the TextStatusID number for the status I would like to pull.

I think my formula will work if it looks like this:

{TextTypes.TextType} = "Label - Brief" and
{TextEntries.TextStatusID} = # and
{TextEntries.TableID} = 108 and
{TextEntries.ID} = {?Pm-Objects.ObjectID}

However, what I can't figure out is how to find the text status ID number to insert for the # sign.

Thank you in advance!

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.

ATOM RSS1 RSS2