Select fields from all datasets (study) with a custom query

LabKey Support Forum (Inactive)
Select fields from all datasets (study) with a custom query trent  2014-08-15 00:32
Status: Closed
 
Thanks for the tip Josh.

I'm probs missing something basic but I didn't have any success with metadata passed into the query web part having any impact.

I pass: (note I tried making a change to the column title just to check the metadata was having an impact)

<tables xmlns="http://labkey.org/data/xml"><table tableName="Dummy" tableDbType="NOT_IN_DB"><columns><column columnName="lsid"><isKeyField>false</isKeyField></column><column columnName="ABC"><columnTitle>ABD</columnTitle><isKeyField>true</isKeyField></column></columns></table></tables>

No change however.

As an additional test, I applied that xml against the actual dataset through the schema browser - the metadata is then reflected in the Query Schema Browser, however even then, the lsid is returned from the querywebpart :(.

Cheers,
Trent

nb: I realise this example is different again to my original post, but I did also try assigning the ParticipantSequenceNum as the primary key - and just wanted to provide a sample of applying xml. And here is the full code:

<script type="text/javascript">
    var dummyWebPart =
        new LABKEY.QueryWebPart({
                renderTo: 'container',
                title: 'Dummy',
                schemaName: 'study',
                queryName: 'Dummy',
                showRecordSelectors: true,
                buttonBar: {
                    includeStandardButtons: true,
                    items:[
                      {text: 'Show Vials', onClick: "console.log(dummyWebPart.getDataRegion().getChecked())", requiresSelection: true},
                    ]
                },
                metadata: {
                    type: 'xml',
                    value: '<tables xmlns="http://labkey.org/data/xml"><table tableName="Dummy" tableDbType="NOT_IN_DB"><columns><column columnName="lsid"><isKeyField>false</isKeyField></column><column columnName="ABC"><columnTitle>ABD</columnTitle><isKeyField>true</isKeyField></column></columns></table></tables>'
                }
        });
</script>
<div id="container"></div>