Is there a why to create a local dynamic CDT in SAIL? I would be asking the user

Is there a why to create a local dynamic CDT in SAIL? I would be asking the users to give me the names of the columns and displaying the information in a grid.

OriginalPostID-157344

OriginalPostID-157344

  Discussion posts and replies are publicly visible

Parents
  • You can easily create a data dictionary of any structure in an expression just using { } type syntax.. such as this example

    load(
    local!MyCustomData:
    {
    {
    label: "Name",
    field: "c0",
    drilldownField: "dp0",
    configuredFormatting: "NORMAL_TEXT",
    configuredDrilldown: "PROCESS_DASHBOARD"
    },
    {
    label: "Priority",
    field: "c7",
    drilldownField: "dp7",
    configuredFormatting: "PRIORITY",
    configuredDrilldown: ""
    },
    {
    label: "Status",
    field: "c8",
    drilldownField: "dp8",
    configuredFormatting: "PROCESS_STATUS_ICON",
    configuredDrilldown: ""
    },
    {
    label: "Started by",
    field: "c1",
    drilldownField: "dp1",
    configuredFormatting: "USER_NAME",
    configuredDrilldown: ""
    },
    {
    label: "Start Time",
    field: "c2",
    drilldownField: "dp2",
    configuredFormatting: "DATE_TIME",
    configuredDrilldown: ""
    },
    {
    label: "Active Tasks",
    field: "c9",
    drilldownField: "dp9",
    configuredFormatting: "NUMBER",
    configuredDrilldown: ""
    }
    },

    /* Now you can refer to any element in your local variable using . delimeter.. such as */

    local!MyCustomData[1].label

    )


    This would return "Name".. the label value for the first element in the array.
Reply
  • You can easily create a data dictionary of any structure in an expression just using { } type syntax.. such as this example

    load(
    local!MyCustomData:
    {
    {
    label: "Name",
    field: "c0",
    drilldownField: "dp0",
    configuredFormatting: "NORMAL_TEXT",
    configuredDrilldown: "PROCESS_DASHBOARD"
    },
    {
    label: "Priority",
    field: "c7",
    drilldownField: "dp7",
    configuredFormatting: "PRIORITY",
    configuredDrilldown: ""
    },
    {
    label: "Status",
    field: "c8",
    drilldownField: "dp8",
    configuredFormatting: "PROCESS_STATUS_ICON",
    configuredDrilldown: ""
    },
    {
    label: "Started by",
    field: "c1",
    drilldownField: "dp1",
    configuredFormatting: "USER_NAME",
    configuredDrilldown: ""
    },
    {
    label: "Start Time",
    field: "c2",
    drilldownField: "dp2",
    configuredFormatting: "DATE_TIME",
    configuredDrilldown: ""
    },
    {
    label: "Active Tasks",
    field: "c9",
    drilldownField: "dp9",
    configuredFormatting: "NUMBER",
    configuredDrilldown: ""
    }
    },

    /* Now you can refer to any element in your local variable using . delimeter.. such as */

    local!MyCustomData[1].label

    )


    This would return "Name".. the label value for the first element in the array.
Children
No Data