Add a URL Property: /home/

Add a URL Property

It can be handy to generate an active filtering link in a dataset. For example, we use a URL property to turn the values in the species column into links to a filtered subset of the data. When you click one species value, you get a grid showing only subjects of the same species. Another way to use a URL property in a list is to link to an outside file.

Create Links to Filtered Results

Click the Start Page tab.
From the Lists web part, click NIMHDemographics to open the grid view of the list.
Click the column header Species, then Filter.
Click the label Rat to select only that single value.
Click OK.
Notice the URL in your browser, which might look something like this - full path will vary, but the filter you applied is encoded at the end. This will show only rows where the species is Rat.

http://localhost:8080/labkey/Tutorials/List%20Tutorial/list-grid.view?name=NIMHDemographics&query.Species~eq=Rat

Click Design.
Click Edit Design.
Select the Species field by clicking in its Name box.
On the Display tab in the field properties box, enter this value for the URL field:

/list/grid.view?name=NIMHDemographics&query.Species~eq=${Species}

The filter portion of this URL replaces "Rat" with the substitution string "${Species}". (If we were to specify "Rat", clicking any species link in the list would filter the list to only show the rats!)
Scroll up and click Save.
Click Done.
Clear the filter by hovering over Filter: (Species = Rat) and then clicking Clear All.
Click Field mouse and you will see the demographics list filtered to display only rows for field mice.

Create Links to Files

A column value can also include link to a file. All the values in a column could link to a fixed file (such as to a protocol document) or you can make row-specific links to files where a portion of the filename matches a value in the row such as the Subject ID in this example. Open this link in a new browser window:

https://www.labkey.org/files/home/Demos/ListDemo/sendFile.view?fileName=20022.png&renderAs=IMAGE

Edit the URL, incrementing the file name 20023.png, 20024.png, 20025.png. These are simply cartoon images of our sample characters stored on a public server, but in actual use you might have slide images or other files of interest stored on your local machine and named by subjectId.

Here is a generalized version, using substitution syntax for the URL property, that you can use in the list design:

http://www.labkey.org/files/home/Demos/ListDemo/sendFile.view?fileName=%40files%2F${SubjectID}.png&renderAs=IMAGE

This generalized version is already included in the list design in our example archive.

Click Start Page, then click the NIMHDemographics list in the Lists web part.
Click Design.
Click Edit Design.
Select the CartoonAvailable field by clicking its Name box.
Notice the URL property for this field. It is the generalized version of the link above.
Click Cancel and return to the grid for this list.
Observe that clicking true in the CartoonAvailable column opens an image of the 'subject' in that row.

LabKey Support

LabKey Support