Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016
    Posts
    1

    Unanswered: Help with Query.

    Hello, first of all I'm not a DBA and have limited knowledge. I'm currently managing CMDBuild server and need to create a new report, one that pulls out our devices make and model numbers, the thing is that when I create a query the Make Model output is displaying numbers, looks to me if the query is pulling the field ID rather than the field data. This is the query I'm running:
    SELECT "StorageArray"."Code", "StorageArray"."MakeModel"
    FROM "StorageArray"

    "StorageArray"."Code" pulls the Serial numbers of the devices and "StorageArray"."MakeModel" supposed to pull the make and model of the devices, but its not. MakeModel is a lookup type, what am I doing wrong?

    Thanks in advanced.

  2. #2
    Join Date
    Oct 2007
    Posts
    153
    Provided Answers: 9
    you'll have to tell us. From your description the MAKEMODEL must be a GUID in another table, that when using that number will give you the actual make and model. Seeing as we do not have access to your schema or model, this is the only guess I can give you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •