How to get data from a filtered RecordType?

Certified Senior Developer

Hi,

I have an interface that contains a Grid based on a RecordType. So the latter can be filtered as need the users.

After being filtered, how may I get the datasubset of this RecordType ?

For example, on a 200 rows table, if the filtered RecordType displays only 5 rows, I need these 5 rows to be retrieved in my datasubset.

I need to work with this datasubset at anytime.

    

  Discussion posts and replies are publicly visible

Parents
  • Hi,

    Please try to use the below-mentioned code and generate a grid based on the local!dataSubset. So, you will get the filtered (using a!queryfilter) data in the local variable and you can work on that variable.

  • 0
    Certified Senior Developer
    in reply to Paresh Singh Rajoriya

    Paresh,

    Maybe I missed something, but what you sent me works only if do not use this datasubset to populate my RecordType grid :

    local!datasubset : a!queryRecordType(
      recordType: recordType!R_MyContracts,
        pagingInfo: a!pagingInfo(
          startIndex: 1,
          batchSize:200
      )
    ),

    If I do this below, the datasubset result is decorelated of the recordtype of my grid:

    a!gridField(
      label: "my contracts",
      labelPosition: "ABOVE",
      data: recordType!R_MyContracts,

    If I do that, the datasubset is not accepted in my grid (Appian error):

    a!gridField(
      label: "my contracts",
      labelPosition: "ABOVE",
      data: local!datasubset,

Reply
  • 0
    Certified Senior Developer
    in reply to Paresh Singh Rajoriya

    Paresh,

    Maybe I missed something, but what you sent me works only if do not use this datasubset to populate my RecordType grid :

    local!datasubset : a!queryRecordType(
      recordType: recordType!R_MyContracts,
        pagingInfo: a!pagingInfo(
          startIndex: 1,
          batchSize:200
      )
    ),

    If I do this below, the datasubset result is decorelated of the recordtype of my grid:

    a!gridField(
      label: "my contracts",
      labelPosition: "ABOVE",
      data: recordType!R_MyContracts,

    If I do that, the datasubset is not accepted in my grid (Appian error):

    a!gridField(
      label: "my contracts",
      labelPosition: "ABOVE",
      data: local!datasubset,

Children
No Data