Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1179
igGrid - formating a link in a column using a template
posted

Hi,

I'm trying to display some json data in the grid (2017.1). I've set the grid up as follows:

            $("#jobs").igGrid({
                dataSource: gdata,
                width: "100%",
                renderCheckboxes: true,
                autoGenerateColumns: false,
                columns: [
                    { key: "Haulier", headerText: "Company", dataType: "string" },
                    { key: "Job", headerText: "Job", dataType: "string", unbound: true, template: jobTemplate },
                    { key: "JobType", headerText: "Job Type", dataType: "string" },
                    { key: "CollectionFrom", headerText: "Collection", dataType: "string" },
                    { key: "DeliveryTo", headerText: "Delivery", dataType: "string" },
                    { key: "DateAssigned", headerText: "Assigned to you", dataType: "date", format: "yyyy-MM-dd HH:mm" },
                    { key: "AssignedTo", headerText: "Driver", dataType: "string" }
                    ],
                features: [
                    {
                        name: "Filtering"
                    },
                    {
                        name: "Paging",
                        showPageSizeDropDown: false
                    },
                    {
                        name: "Sorting"
                    },
                    {
                        name: "Selection",
                        inherit: true
                    }
                ]
            });

jobTemplate is defined as < a href=/SupplierPortal/Itinerary/Itinerary/${ItineraryID}>${Reference}< /a>  (spaces added to avoid being interpreted as HTML)

So I want a link that ends in the value of the ItineraryID fields from the json, and displays the Reference field on the page. The column on the grid remains blank though (the other columns are populated okay). I presume I'm not specifying the column template correctly - can anyone tell me what it should be?

The json looks like this (but with more rows):

[{"ItineraryID":"b7a46736-4a06-4cf5-94e7-5a2b67c1ad3e","Haulier":"Test","Reference":"RX356562","JobType":"Collection","CollectionFrom":"JGRG233396/1: Bousbecque 59166","DeliveryTo":"","DateAssigned":"2016-10-07T13:11:00","AssignedTo":null}]

Parents
  • 1179
    Offline posted

    I've followed it through a bit further, and it looks like something not working the way it should. If I replace the template contents with this, then it "works":

    < a href=/SupplierPortal/Itinerary/Itinerary/${ItineraryID}>Test< /a>

    So if the link text is a static value then it is displayed correctly (though the result is not very useful!)

    I wondered if it didn't like referencing multiple fields in the template, so tried the following:

    < a href=/SupplierPortal/Itinerary/Itinerary/${ItineraryID}>${ItineraryID}< /a>

    This reverted to leaving the cell blank again. 

    Should what I'm try to do work? I want the link address and the display text to be determined by the underlying data. I'm hoping it's something I can resolve quickly, as this would be a show stopper for us :-(

    Kevin

Reply Children