Drillable Chart

Certified Senior Developer

I have column chart as shown in image and have made it drillable.

How do I filter records to show corresponding months records?

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer


    a!gridField(
        
        data: a!recordData(
          recordType: 'recordType!recordName',
          filters: ri!filters
        ),
    )
    /*ri!filters is of any type 
    Calling Interface*/
    a!localVariables(
      local!month: 2,
      local!year:2022,
      /*whenever you change a month use saveinto in the dynamic link and change the value of local!year and local!month*/
        rule!drillableInterface(
        filters:
        a!queryFilter(
            field: 'recordType!{af5896a5-34b7-4d2f-9d8a-901d89ca73fb}ABSB Case Record.fields.{createdAt}createdAt',
            operator: "between",
            value: {  date(local!year,local!month,1), eomonth(date(local!year,local!month,1)) }
            )
        )
    )

    Please refer to the code here you need to pass filters in the grid field as rule input of type any type. And where you are calling set the rule input as shown in the code. 

Reply
  • 0
    Certified Senior Developer


    a!gridField(
        
        data: a!recordData(
          recordType: 'recordType!recordName',
          filters: ri!filters
        ),
    )
    /*ri!filters is of any type 
    Calling Interface*/
    a!localVariables(
      local!month: 2,
      local!year:2022,
      /*whenever you change a month use saveinto in the dynamic link and change the value of local!year and local!month*/
        rule!drillableInterface(
        filters:
        a!queryFilter(
            field: 'recordType!{af5896a5-34b7-4d2f-9d8a-901d89ca73fb}ABSB Case Record.fields.{createdAt}createdAt',
            operator: "between",
            value: {  date(local!year,local!month,1), eomonth(date(local!year,local!month,1)) }
            )
        )
    )

    Please refer to the code here you need to pass filters in the grid field as rule input of type any type. And where you are calling set the rule input as shown in the code. 

Children
No Data