List design and labkey.selectRows

LabKey Support Forum (Inactive)
List design and labkey.selectRows Jon (LabKey DevOps)  2016-02-23 21:12
Status: Closed
 
Hi Laura,

That's really strange. I couldn't reproduce the problem when I created a list using an integer for my Key (not the auto-increment kind).

Does this duplicate field appear when you access any list or just the one?

Can you run the same query against our LabKey.org site using this list (I've provided you access to a special folder that has a special integer list created):

listtest <- labkey.selectRows(
  baseUrl="https://www.labkey.org",
  folderPath="/Support%20Tickets/TestLists",
  schemaName="lists",
  queryName="RocheSkylineListTest",
  colNameOpt = "fieldname",
  containerFilter=NULL
)

This should bring up just three fields if you run a str(listtest) against it and you should only see three columns of data.

Regards,

Jon