What is the way to enforce that a user can only insert unique values for a certain field in a custom list? [EOM]

LabKey Support Forum (Inactive)
What is the way to enforce that a user can only insert unique values for a certain field in a custom list? [EOM] Jon (LabKey DevOps)  2015-10-28 16:17
Status: Closed
 
Hi Leo,

I was able to use the following XML without any issue after restarting Tomcat:

<customView xmlns="http://labkey.org/data/xml/queryCustomView">
    <columns>
        <column name="Name" />
        <column name="Number" />
    <column name="Key" />
    </columns>
    <sorts>
        <sort column="Key" descending="true"/>
    </sorts>
</customView>

This successfully came up as a View option along side the default for that specific list I was looking at. Maybe you just need to remove the :cv part and just have the equal sign instead for the first line?

Also, a .query.xml file is to be used only on tables that are being generated by .sql files and not pre-existing queries. It is explained in the following page after addCustomQueryView (https://www.labkey.org/wiki/home/Documentation/page.view?name=addSQLQuery)

"If supplied, the metadata file should have the same name as the .sql file, but with a ".query.xml" extends (e.g., PeptideCounts.query.xml) (docs: query.xsd)"

The two RegEx questions:

Regarding the first RegEx question, that is definitely a bug that is overshooting it's close function that I'll need to get filed.

Regarding the other RegEx question where the validator section where the X to delete it doesn't come up, I believe this might be function by design since the only time the option to get the X appears is when an update is going to occur on that tab. I'll submit it as a separate bug to be looked at.

Regards,

Jon