Custom SQL Queries | Jon (LabKey DevOps) | 2017-06-21 10:42 |
Status: Closed | ||
Hi Tek, I'm not sure I'm understanding your question properly here. From the LabKey side: Views (specifically Grid Views) are separate from the Schema Browser. To make a view available for anyone to use, you need to make sure that you save the view with the option "Make this grid view available to all users" for Sharing checked on. That view would only apply to that specific table or query you're viewing. Regarding tables and queries, the Schema Browser will only display that information under the following conditions: 1. It is created via a module. - https://www.labkey.org/Documentation/wiki-page.view?name=addCustomQueryView - https://www.labkey.org/Documentation/wiki-page.view?name=addSQLQuery - https://www.labkey.org/Documentation/wiki-page.view?name=sqlScripts 2. It is created via the UI. - Via Schema Browser to create new queries off of existing tables or queries (https://www.labkey.org/Documentation/wiki-page.view?name=createQuery) - Via Schema Browser to add a linked schema (https://www.labkey.org/Documentation/wiki-page.view?name=filterSchema) - Via Schema Browser to add an external schema (https://www.labkey.org/Documentation/wiki-page.view?name=externalSchemas) - Through lists, studies (i.e. datasets), and assays. There really isn't a good way to try and shoehorn in that table you're referring to if you created it within the Study schema directly via PostgreSQL. You would have to alter your study module to accommodate that change and we really would advise against that. The preferred method would be to create a module, have the module build a brand new schema and tables, and whenever that module is used for any given project/folder, it will automatically be seen in the Schema Browser for that specific project/folder. Does that make sense? Regards, Jon |
||