Create a filter using Text Field to fetch the particular details in grid

Hi 

So you need to filter on two fields PorjectID and StudentId. for multiple filters you need to use a!queryLogicalExpression() in your query entity like 

a!queryEntity(
entity: cons!RQA_double_item_ENTITY,
query: a!query(
pagingInfo: local!pagingInfo,
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "field",
operator: "=",
value: ri!PorjectID
),
if(
isnull(
local!fetch
),
{},
a!queryFilter(
field: "StudentId",
operator: "=",
value: local!fetch
)
)
}
)
),
fetchTotalCount: true()
)

dude i need to filter one row in grid field ...  using text filter .. how i can configure 

By using text filter you need to sort one  row in grid field?

Based on text which you have entered in text filed the sort has to apply for the grid correct ?

please correct me if i am wrong 

yes  ,  you r right ... any idea please share 

load(
  local!field,
  local!ascending: true(),
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: - 1,
    sort: a!sortInfo(
      field: if(
        isnull(
          local!field
        ),
        "id",
        local!field
      ),
      ascending: local!ascending
    )
  ),
  local!sampleData: {
    {
      name: "ABC",
      id: 2
    },
    {
      name: "XYZ",
      id: 1
    }
  },
  {
    a!textField(
      label: "Field",
      value: local!field,
      saveInto: {
        local!field,
        a!save(
          local!pagingInfo,
          a!pagingInfo(
            startIndex: 1,
            batchSize: - 1,
            sort: a!sortInfo(
              field: local!field,
              ascending: local!ascending
            )
          )
        )
      }
    ),
    with(
      local!datasubset: todatasubset(
        local!sampleData,
        local!pagingInfo
      ),
      local!dataForCurrentPage: local!datasubset.data,
      {
        a!gridField(
          label: "",
          totalCount: length(
            local!sampleData
          ),
          columns: {
            a!gridTextColumn(
              label: "Name",
              field: "name",
              data: local!dataForCurrentPage.name,
              alignment: "LEFT"
            ),
            a!gridTextColumn(
              label: "ID",
              field: "id",
              data: local!dataForCurrentPage.id,
              alignment: "LEFT"
            )
          },
          value: local!pagingInfo,
          saveInto: local!pagingInfo
        )
      }
    )
  }
)

check given code ,first by default it will sort on id  and if you give any value in text filed then it will sort on that value 

load(
  local!fetch,
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: cons!batch_no,
    sort: a!sortInfo(
      field: if(
        rule!APN_isEmpty(
          local!fetch
        ),
        "projId",
        local!fetch
      ),
      ascending: true()
    )
  ),
  with(
    local!StudentsData: a!queryEntity(
      entity: cons!RQA_double_item_ENTITY,
      query: a!query(
        filter: a!queryFilter(
          field: "field",
          operator: "=",
          value: ri!PorjectID
        ),
        pagingInfo: local!pagingInfo
      ),
      fetchTotalCount: true()
    ),
    {
      a!sectionLayout(
        label: "Fetch Details",
        contents: {
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!textField(
                    label: "Students ID",
                    required: true(),
                    value: local!fetch,
                    saveInto: local!fetch
                  ),
                  a!buttonArrayLayout(
                    buttons: {
                      a!buttonWidget(
                        label: "Search",
                        saveInto: {
                          a!save(
                            local!pagingInfo,
                            a!pagingInfo(
                              startIndex: 1,
                              batchSize: cons!batch_no,
                              sort: a!sortInfo(
                                field: local!fetch,
                                ascending: true()
                              )
                            )
                          )
                        }
                      )
                    },
                    align: "START"
                  )
                }
              ),
              
            }
          )
        }
      ),
      a!sectionLayout(
        label: "Students Details",
        contents: {
          if(
            rule!RQA_checkIsNullOrEmpty(
              local!StudentsData
            ),
            a!richTextDisplayField(
              label: "",
              value: "No Data Available"
            ),
            a!gridField(
              label: "",
              totalCount: local!StudentsData.totalCount,
              columns: {
                if(
                  rf!requesttype = cons!RQA_VALUES[1],
                  a!gridTextColumn(
                    label: "Students ID",
                    field: "student",
                    data: index(
                      local!StudentsData.data,
                      "student",
                      {}
                    ),
                    alignment: "CENTER"
                  ),
                  {}
                ),
                a!gridTextColumn(
                  label: "ClassID",
                  field: "classid",
                  data: index(
                    local!StudentsData.data,
                    "classid",
                    null
                  ),
                  alignment: "CENTER"
                ),
                
              },
              value: local!pagingInfo,
              saveInto: local!pagingInfo,
              rowHeader: 1/*selection: true()*/
              
            )
          )
        },
        isCollapsible: true()
      )
    }
  )
)

load(
  local!fetch,
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: cons!batch_no,
    sort: a!sortInfo(
      field: if(
        rule!APN_isEmpty(
          local!fetch
        ),
        "projId",
        local!fetch
      ),
      ascending: true()
    )
  ),
  with(
    local!StudentsData: a!queryEntity(
      entity: cons!RQA_double_item_ENTITY,
      query: a!query(
        filter: a!queryFilter(
          field: "field",
          operator: "=",
          value: ri!PorjectID
        ),
        pagingInfo: local!pagingInfo
      ),
      fetchTotalCount: true()
    ),
    {
      a!sectionLayout(
        label: "Fetch Details",
        contents: {
          a!columnsLayout(
            columns: {
              a!columnLayout(
                contents: {
                  a!textField(
                    label: "Students ID",
                    required: true(),
                    value: local!fetch,
                    saveInto: local!fetch
                  ),
                  a!buttonArrayLayout(
                    buttons: {
                      a!buttonWidget(
                        label: "Search",
                        saveInto: {
                          a!save(
                            local!pagingInfo,
                            a!pagingInfo(
                              startIndex: 1,
                              batchSize: cons!batch_no,
                              sort: a!sortInfo(
                                field: local!fetch,
                                ascending: true()
                              )
                            )
                          )
                        }
                      )
                    },
                    align: "START"
                  )
                }
              ),
              
            }
          )
        }
      ),
      a!sectionLayout(
        label: "Students Details",
        contents: {
          if(
            rule!RQA_checkIsNullOrEmpty(
              local!StudentsData
            ),
            a!richTextDisplayField(
              label: "",
              value: "No Data Available"
            ),
            a!gridField(
              label: "",
              totalCount: local!StudentsData.totalCount,
              columns: {
                if(
                  rf!requesttype = cons!RQA_VALUES[1],
                  a!gridTextColumn(
                    label: "Students ID",
                    field: "student",
                    data: index(
                      local!StudentsData.data,
                      "student",
                      {}
                    ),
                    alignment: "CENTER"
                  ),
                  {}
                ),
                a!gridTextColumn(
                  label: "ClassID",
                  field: "classid",
                  data: index(
                    local!StudentsData.data,
                    "classid",
                    null
                  ),
                  alignment: "CENTER"
                ),
                
              },
              value: local!pagingInfo,
              saveInto: local!pagingInfo,
              rowHeader: 1/*selection: true()*/
              
            )
          )
        },
        isCollapsible: true()
      )
    }
  )
)