A bug or an implicit restriction?

LabKey Support Forum (Inactive)
A bug or an implicit restriction? Leo Dashevskiy  2013-06-28 14:46
Status: Closed
 
Hey, folks!

SVN revision: 27177

I have a custom table:

CREATE TABLE opencyto_preprocessing.projections
(
    Container ENTITYID NOT NULL,
    name TEXT NOT NULL,
    path TEXT NOT NULL,
    x_axis TEXT NOT NULL,
    y_axis TEXT NOT NULL,
    x_key TEXT NOT NULL,
    y_key TEXT NOT NULL,
    gsId INT NOT NULL,

-- CONSTRAINT UQ_table UNIQUE (Container, <cols-list>), -- cols combination to make unique to the project
    CONSTRAINT PK_projections PRIMARY KEY (Container, name, x_axis, y_axis, gsId),
    CONSTRAINT FK_projections_gsTbl FOREIGN KEY (gsId, Container)
        REFERENCES opencyto_preprocessing.gsTbl (gsId, Container)
        ON DELETE CASCADE
);

<ns:table tableName='projections' tableDbType='TABLE'>
        <ns:description>
            The 'projections' table contains the projections information associated with gating sets.
        </ns:description>
        <ns:columns>
            <ns:column columnName='container'/>
            <ns:column columnName='name'/>
            <ns:column columnName='path'/>
            <ns:column columnName='x_axis'>
                <ns:columnTitle>X Marker and Channel Name</ns:columnTitle>
            </ns:column>
            <ns:column columnName='y_axis'>
                <ns:columnTitle>Y Marker and Channel Name</ns:columnTitle>
            </ns:column>
            <ns:column columnName='x_key'>
                <ns:columnTitle>X Channel Name</ns:columnTitle>
            </ns:column>
            <ns:column columnName='y_key'>
                <ns:columnTitle>Y Channel Name</ns:columnTitle>
            </ns:column>
            <ns:column columnName='gsid'/>
        </ns:columns>
    </ns:table>


I am writing (via Rlabkey package from R's data.frame) into some rows for all columns 'normal' text (call these rows 'regular') and for some rows (call them 'irregular') - 'Name' and 'Path' columns get 'normal' text and the other columns get a space ' '.

When I click on 'edit' or 'details' for a 'regular' row I get the pages with respective interfaces.

Whereas if I click for an 'irregular' row:

- on 'edit', then I get just the following message: "Could not find row in current project or folder." (no editable fields and action buttons)

- on 'details', then I get no details/summary table, the the 'Details' header and the 2 buttons on the bottom.

Thanks.
-Leo
 
 
cnathe responded:  2013-07-03 13:15
Leo,
I was able to reproduce the issue that you are seeing locally. I have opened a LabKey issue for this scenario:
https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=18187

I haven't looked too much into it yet, but I suspect that the issue is related to the spaces being inserted into the required fields. It looks like when you try to do the insert from the browser via the "Insert New" action, the spaces are trimmed off but when inserted via Rlabkey they are not.

-Cory
 
Leo Dashevskiy responded:  2013-07-03 13:34
I see, ok, thanks, I'll keep an eye out for the bug entry resolution...