Support

Expand all | Collapse all

Where are field values stored in Database

  • 1.  Where are field values stored in Database

    Posted 06-20-2017 09:06
    Hoping someone here can help me out. Im on day two of digging through the database schema.

    I have my documenttypeID for the item type, I have the lookuptypeID for the field im looking for, I have the list of document ID's that are of the documenttypeID.

    Can someone tell me where the standard field values are recorded. Im looking for field values that are not custom. I can get that list fine, I just need to find that values of the standard field like "review status".


    ------------------------------
    Luigi Salce
    Bose Corporation
    ------------------------------


  • 2.  RE: Where are field values stored in Database

    Posted 06-21-2017 05:15
    Edited by Dana Medhaug 06-27-2017 19:11
    I recommend to start reading here:
    Database Schema

    Download the schema matching to your Jama Software version and have look at the relationships.


    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 3.  RE: Where are field values stored in Database

    Posted 06-21-2017 08:06
    Hey Harald!

    Thanks for the response, im new to the database game and im teaching myself BIRT and Velocity.

    I've downloaded the schema last week and have been bashing my head trying to find out where those field values are stored. I see no clear relationship between standard fields and where their values are stored. I can find all the customfieldvalues no problem, I can find the usage metrics no problem, I just can't find where the standard field values for items are being recorded in the database.

    Very frustrating.

    I think im going to submit a support ticket on this, dont want to waste anymore time digging myself.

    ------------------------------
    Luigi Salce
    Bose Corporation
    ------------------------------



  • 4.  RE: Where are field values stored in Database

    Posted 06-21-2017 08:37
    document is dependent on documenttype.

    The id of documenttype is stored in the documenttypeid of document.

    The same pattern applies for status and all lookupfields, they point to lookup.

    ------------------------------
    Harald Hotz-Behofsits
    Frequentis AG
    ------------------------------



  • 5.  RE: Where are field values stored in Database

    Posted 06-21-2017 14:34
    I have submitted a ticket on this and am waiting for a reply.

    I appreciate the help, Harald. I dont think I've explained this properly.

    I have a list of items i've pulled from the documents table. I need to check the review status field value for every one of those items. I know where the field value correlates to an id in the lookup table and the ID of field itself in the lookuptypeID, but I have no idea how that relates to back to the items i've pulled from document table.

    ------------------------------
    Luigi Salce
    Bose Corporation
    ------------------------------



  • 6.  RE: Where are field values stored in Database

    Posted 06-21-2017 14:54
    This is what I got along with  a list of 1,000 Document.id's. I just need to get it all together.

    I need to know what the current status field value is for document.id="267430".....

    Project:

    project.Id = "70"

     

    Item:

    DocumentType.id = "49"

     

    Field:

    documentField.id = "200"

    lookupTypeID = "177"

    documentTypeFieldDefinition.id = "449"

     

    Field Values:

    Lookup.id = "464"

    Lookup.id = "465"

    Lookup.id="466"

    Lookup.id="467"

    Lookup.id="468"



    ------------------------------
    Luigi Salce
    Bose Corporation
    ------------------------------



  • 7.  RE: Where are field values stored in Database

    Posted 06-21-2017 15:24
    Alright, I got it!

    Thanks for all the help. I believe I am good to go.

    Thanks for the guidance, Harald.

    ------------------------------
    Luigi Salce
    Bose Corporation
    ------------------------------



  • 8.  RE: Where are field values stored in Database

    Posted 06-21-2017 16:02
    Awesome, Luigi! We had someone working the ticket (who is a newbie so they wanted someone else to check their work), but I'm glad to hear you don't need us after all. ;)

    As always, thanks @Harald for your knowledge of everything.

    ------------------------------
    Kristina King
    Jama Software
    ------------------------------