PerkinElmer Informatics Support Forum
Decrease font size
Increase font size
Topic Title: Sql Query collection name which including Link to Supplementary Data section and imported file information
Topic Summary:
Created On: 3/7/2014 2:12 AM
Status Post and Reply
Linear : Threading : Single : Branch
Topic Tools Topic Tools
View topic in raw text format. Print this topic.
 3/7/2014 2:12 AM
User is offline View Users Profile Print this message


CarolineWang

Posts: 2
Joined: 3/7/2014

Customer would like to use sql to query information of SDM imported files.

Now we can directly query Username, Imported file name and created date information in ELNB_SDM.DM_FILE table.

The question is:

How can we query the collection name which including this Link to Supplementary Data section (That means the experiement which including this SDM information )

How to use sql to query all these data?(Collection name, User name, Imported file name, created date)

FuseTalk Basic Edition v4.0 - © 1999-2018 FuseTalk Inc. All rights reserved.