• State Verified Answer
  • +4 person also asked this people also asked this
  • Replies 43 replies
  • Answers 3 answers
  • Subscribers 13 subscribers
  • Views 55493 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Configuring 'Search' for Service Backed Record

kumaraveln

 Hi., I have an entity backed record with a grid view. As per the documentation, the 'Search' is applied across all columns of the grid.

Our requirement is to make the search happen against selective columns say 4 out of 10. For this purpose i am trying to create a service (Expression) backed record which has control over the search functionality.

 

My search works fine if i configure it against any one column but it stops working if i add multiple queryFilters (with OR condition).

Attaching the code for reference. Any pointer would be helpful. 

Fullscreen ServiceBackedRecord_SourceExpression.txt Download 
with(
  /* 
    Get the first CDT containing one or more of the following:
    Logical Expression, Query Filter, Search Query. It is called
    a logicalExpression|filter|search -- abbreviated as LFS
  */
  local!parentLFS: index(
    ri!rspQueryObj,
    "logicalExpression|filter|search",
    null
  ),
  /* 
    Check to see if the above CDT has a nested LFS in it. This can happen
    if the user has clicked multiple filters or searched on filtered results.
  */
  local!childLFS: index(
    local!parentLFS,
    "logicalExpression|filter|search",
    null
  ),
  /*
    Get the LFS containing the filter(s) and/or search.
    Basically, if the child exists, it will contain all the information.
    If it doesn't then we want to parent.
  */
  local!mainLFS: if(
    isnull(
      local!childLFS
    ),
    local!parentLFS,
    local!childLFS
  ),
  /* Get runtime types of LFS (type!QueryFilter or type!Search) */
  local!types: apply(
    fn!runtimetypeof,
    {
      local!mainLFS
    }
  ),
  
  /* Get the search CDT, if there is one. It has its own type that we can look for. */
  local!searchCdt: index({local!mainLFS}, where(local!types='type!{http://www.appian.com/ae/types/2009}Search'), null),
  
  /* Gets filter CDTs if there are any. We can find them by their type. */
  local!filterCdts: index({local!mainLFS}, where(local!types='type!{http://www.appian.com/ae/types/2009}QueryFilter'), {}),
  
  
  local!recSearchText: if(
    isnull(
      local!searchCdt
    ),
    "",
    tostring(
      index(
        cast(
          'type!{http://www.appian.com/ae/types/2009}Search',
          local!searchCdt
        ),
        "searchQuery",
        ""
      )
    )
  ),
  
  local!recFilters: if(
    rule!APN_isEmpty(
      local!filterCdts
    ),
    {},
    cast('type!{http://www.appian.com/ae/types/2009}QueryFilter?list', local!filterCdts)
  ),
  
  /* Get filters' fields and values to avoid function repitition */
  local!filterFields: if(rule!APN_isEmpty(local!recFilters), {}, index(local!recFilters, "field", {})),
  local!filterValues: if(rule!APN_isEmpty(local!recFilters), {}, index(local!recFilters, "value", {})),  
  
  /* Get filtered 'Request Status' */
  local!requestStatusFilterValues: if(
    rule!APN_isEmpty(local!filterFields), 
    "", 
    displayvalue(
      "requestStatus_txt",
      local!filterFields,
      local!filterValues,
      null
    )
  ),
  
  /* Get filtered 'Request Type' */
  local!requestTypeFilterValues: if(
    rule!APN_isEmpty(local!filterFields), 
    "", 
    displayvalue(
    "requestType_txt",
    local!filterFields,
    local!filterValues,
    null
    )
  ),  
  
  a!queryEntity(
    entity: cons!WMG_GBL_REQ_TRACK_VIEW_ENTITY,
    query: a!query(
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          /* Default Filter */
          a!queryFilter(
            field: "businessUnit_txt",
            operator: "=",
            value: ri!businessUnit_txt
          ),
          if(
            rule!APN_isEmpty(
              local!requestTypeFilterValues
            ),
            {},
            a!queryFilter(
              field: "requestType_txt",
              operator: "=",
              value: local!requestTypeFilterValues
            )
          ),          
          if(
            rule!APN_isEmpty(
              local!requestStatusFilterValues
            ),
            {},
            a!queryFilter(
              field: "requestStatus_txt",
              operator: "=",
              value: local!requestStatusFilterValues
            )
          )
          logicalExpression: a!queryLogicalExpression(
            operator: "OR",
            filters: {
              if(
                rule!APN_isBlank(
                  local!recSearchText
                ),
                {},
                {
                  a!queryFilter(
                    field: "requestId_int",
                    operator: "=",
                    value: local!recSearchText
                  ),
                  a!queryFilter(
                    field: "accountNumber_txt",
                    operator: "=",
                    value: local!recSearchText
                  ),
                  a!queryFilter(
                    field: "clientName_txt",
                    operator: "=",
                    value: local!recSearchText
                  ),
                  a!queryFilter(
                    field: "taxIdValue_txt",
                    operator: "=",
                    value: local!recSearchText
                  )                
                }
              )
            }
          )            
        }
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 10,
        sort: a!sortInfo(
          field: "createdDate_dt",
          ascending: false
        )
      )
    )
  )
)

  Discussion posts and replies are publicly visible

  • 0
    A Score Level 1
     in reply to Vinay Kumar Rai
    Query entity is working fine separately.
    Infact in the code as I mentioned, my user filters are also working fine. The issue is if I incorporate the generalSearch logicalExpression.

    Any suggestions.
  • +1 in reply to komalc3

    Ok got the issue,

    Your If condition is incorrectly placed, to check the local!generalSearch is null

    /*Code for rule!PH_QE_getDetailsFromGenericView() */

with(
  local!queryInformation: rule!parseRspQuery(ri!rspQuery),
  local!filterFields: index(local!queryInformation.filters, "field", {}),
  local!filterValues: index(local!queryInformation.filters, "value", {}),
  local!generalSearch:local!queryInformation.searchText,
  
  local!status: displayvalue(
    "status",
    local!filterFields,
    local!filterValues,
    ""
  ),
  local!typeDetail: a!forEach(
    displayvalue(
      "typeDetail",
      local!filterFields,
      local!filterValues,
      ""
    ),
    tostring(fv!item)
  ),
  
  a!queryEntity(
    entity:cons!GENERIC_VW_DE,
    query:a!query(
      selection: a!querySelection(
        columns:{
          a!queryColumn(
            field:"id",
            visible:true
          ),
          a!queryColumn(
            field:"code",
            visible:true
          ),
          a!queryColumn(
            field:"number",
            visible:true
          ),
          a!queryColumn(
            field:"typeDetail",
            visible:true
          ),
          a!queryColumn(
            field:"status",
            visible:true
          ),
          a!queryColumn(
            field:"fullName",
            visible:true
          )
        }
       ),
       logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          /* Default Filter */
      		 a!queryFilter(
            field:"typeDetail",
            operator:"in",
            value:cons!TYPES_OF_DETAIL
          ),
		  /*Status and Type Detail are user filters */
    	 if(
            rule!APN_isBlank(local!status),
            {},
              a!queryFilter(
              field:"status",
              operator:"=",
              value:local!status
            )
          ),
          if(
            rule!APN_isBlank(local!typeDetail),
            {},
              a!queryFilter(
              field:"typeDetail",
              operator:"in",
              value:local!typeDetail
            )
          )
		},
  		logicalExpressions: 
		
		if(
			rule!APN_isBlank(local!generalSearch),
			{},
  		  a!queryLogicalExpression(
              operator: "OR",
              filters: {
        			
                    a!queryFilter(
        				  field:"code",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
                    a!queryFilter(
        				  field:"number",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ) ,
                   a!queryFilter(
        				  field:"typeDetail",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
				  a!queryFilter(
        				  field:"status",
        				  operator:"includes",
        				  value:local!generalSearch
        		    ),
		         a!queryFilter(
        				  field:"fullName",
        				  operator:"includes",
        				  value:local!generalSearch
        		  ) 
               
             }
          ) 
		)
      ),
      pagingInfo:local!queryInformation.pagingInfo
    )
  )
)

  • 0
    A Score Level 1
     in reply to Vinay Kumar Rai

    Hi

    One more question.

    My record list view would be created just like the way we create for an entity backed record right?

    However, I am facing a weird issue that when I am opening my record via. the link in the record list view, everytime the first record that shows up in the grid opens and not the corresponding expected record.

     

    Below is the code snippet for the link:

     

    a!recordLink(
  label: rf!code,
  recordType: rp!type,
  identifier: rp!id
)

     

    Kindly suggest.

  • 0 in reply to komalc3

    Hi,

    You can not populating unique Identifier on your Source expression,

    local!uniqueIdentifier: displayvalue(
    "rp!id",
    local!filterFields,
    local!filterValues,
    null
    ),

    when user click on the record link the local!uniqueIdentifier holds the value,

    local!uniqueIdentifier -> holds primary key value.

    please check for null, if local!uniqueIdentifier is null then query all the values with pagination else get the detail by local!uniqueIdentifier



    Thanks
    Vinay

  • 0
    A Score Level 1
     in reply to Vinay Kumar Rai

    Hi

    Yes search issue is fixed, thanx again!!

    If I am not wrong by using unique identifier you mean I modify my code as below:

     

    /*Code for rule!PH_QE_getDetailsFromGenericView() */

with(
  local!queryInformation: rule!parseRspQuery(ri!rspQuery),
  local!filterFields: index(local!queryInformation.filters, "field", {}),
  local!filterValues: index(local!queryInformation.filters, "value", {}),
  local!generalSearch:local!queryInformation.searchText,
  
  local!uniqueIdentifier: displayvalue(
    "rp!id",
    local!filterFields,
    local!filterValues,
    null
  ),
  
  local!status: displayvalue(
    "status",
    local!filterFields,
    local!filterValues,
    ""
  ),
  local!typeDetail: a!forEach(
    displayvalue(
      "typeDetail",
      local!filterFields,
      local!filterValues,
      ""
    ),
    tostring(fv!item)
  ),
  
  a!queryEntity(
    entity:cons!GENERIC_VW_DE,
    query:a!query(
      selection: a!querySelection(
        columns:{
          a!queryColumn(
            field:"id",
            visible:true
          ),
          a!queryColumn(
            field:"code",
            visible:true
          ),
          a!queryColumn(
            field:"number",
            visible:true
          ),
          a!queryColumn(
            field:"typeDetail",
            visible:true
          ),
          a!queryColumn(
            field:"status",
            visible:true
          ),
          a!queryColumn(
            field:"fullName",
            visible:true
          )
        }
       ),
       logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          /* Default Filter */
      		 a!queryFilter(
            field:"typeDetail",
            operator:"in",
            value:cons!TYPES_OF_DETAIL
          ),
          if(
            rule!APN_isBlank(local!uniqueIdentifier),
            {},
              a!queryFilter(
              field:"id",
              operator:"=",
              value:local!uniqueIdentifier
            )
          ),
          
		  /*Status and Type Detail are user filters */
    	 if(
            rule!APN_isBlank(local!status),
            {},
              a!queryFilter(
              field:"status",
              operator:"=",
              value:local!status
            )
          ),
          if(
            rule!APN_isBlank(local!typeDetail),
            {},
              a!queryFilter(
              field:"typeDetail",
              operator:"in",
              value:local!typeDetail
            )
          )
		},
  		logicalExpressions: 
		
		if(
			rule!APN_isBlank(local!generalSearch),
			{},
  		  a!queryLogicalExpression(
              operator: "OR",
              filters: {
        			
                    a!queryFilter(
        				  field:"code",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
                    a!queryFilter(
        				  field:"number",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ) ,
                   a!queryFilter(
        				  field:"typeDetail",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
				  a!queryFilter(
        				  field:"status",
        				  operator:"includes",
        				  value:local!generalSearch
        		    ),
		         a!queryFilter(
        				  field:"fullName",
        				  operator:"includes",
        				  value:local!generalSearch
        		  ) 
               
             }
          ) 
		)
      ),
      pagingInfo:local!queryInformation.pagingInfo
    )
  )
)

    If I am doing something like this, then on clicking the link I get the error of retrieval of data.

     

    Kindly suggest.

  • 0 in reply to komalc3

    Hi

    Please try the below code,

     

    /*Code for rule!PH_QE_getDetailsFromGenericView() */

with(
  local!queryInformation: rule!parseRspQuery(ri!rspQuery),
  local!filterFields: index(local!queryInformation.filters, "field", {}),
  local!filterValues: index(local!queryInformation.filters, "value", {}),
  local!generalSearch:local!queryInformation.searchText,
  
  local!uniqueIdentifier: displayvalue(
    "rp!id",
    local!filterFields,
    local!filterValues,
    null
  ),
  
  local!status: displayvalue(
    "status",
    local!filterFields,
    local!filterValues,
    ""
  ),
  local!typeDetail: a!forEach(
    displayvalue(
      "typeDetail",
      local!filterFields,
      local!filterValues,
      ""
    ),
    tostring(fv!item)
  ),
  
  
  
 if(
    rule!APN_isBlank(local!uniqueIdentifier),
     
   a!queryEntity(
    entity:cons!GENERIC_VW_DE,
    query:a!query(
      selection: a!querySelection(
        columns:{
          a!queryColumn(
            field:"id",
            visible:true
          ),
          a!queryColumn(
            field:"code",
            visible:true
          ),
          a!queryColumn(
            field:"number",
            visible:true
          ),
          a!queryColumn(
            field:"typeDetail",
            visible:true
          ),
          a!queryColumn(
            field:"status",
            visible:true
          ),
          a!queryColumn(
            field:"fullName",
            visible:true
          )
        }
       ),
       logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          /* Default Filter */
      		 a!queryFilter(
            field:"typeDetail",
            operator:"in",
            value:cons!TYPES_OF_DETAIL
          ),
          if(
            rule!APN_isBlank(local!uniqueIdentifier),
            {},
              a!queryFilter(
              field:"id",
              operator:"=",
              value:local!uniqueIdentifier
            )
          ),
          
		  /*Status and Type Detail are user filters */
    	 if(
            rule!APN_isBlank(local!status),
            {},
              a!queryFilter(
              field:"status",
              operator:"=",
              value:local!status
            )
          ),
          if(
            rule!APN_isBlank(local!typeDetail),
            {},
              a!queryFilter(
              field:"typeDetail",
              operator:"in",
              value:local!typeDetail
            )
          )
		},
  		logicalExpressions: 
		
		if(
			rule!APN_isBlank(local!generalSearch),
			{},
  		  a!queryLogicalExpression(
              operator: "OR",
              filters: {
        			
                    a!queryFilter(
        				  field:"code",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
                    a!queryFilter(
        				  field:"number",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ) ,
                   a!queryFilter(
        				  field:"typeDetail",
        				  operator:"includes",
        				  value:local!generalSearch
        		     ),
				  a!queryFilter(
        				  field:"status",
        				  operator:"includes",
        				  value:local!generalSearch
        		    ),
		         a!queryFilter(
        				  field:"fullName",
        				  operator:"includes",
        				  value:local!generalSearch
        		  ) 
               
             }
          ) 
		)
      ),
      pagingInfo:local!queryInformation.pagingInfo
    )
  ),
  
   
    a!queryEntity(
    entity:cons!GENERIC_VW_DE,
    query:a!query(
      selection: a!querySelection(
        columns:{
          a!queryColumn(
            field:"id",
            visible:true
          ),
          a!queryColumn(
            field:"code",
            visible:true
          ),
          a!queryColumn(
            field:"number",
            visible:true
          ),
          a!queryColumn(
            field:"typeDetail",
            visible:true
          ),
          a!queryColumn(
            field:"status",
            visible:true
          ),
          a!queryColumn(
            field:"fullName",
            visible:true
          )
        }
       ),
	   
	   filter:a!queryFilter(
               field:"id"  /* Your Primary Key Column*/,
               operator:"=",
               value:local!uniqueIdentifier
            ),
	   
         pagingInfo:topagingInfo(1,1)
    )
  )
     
  
  )
  
  
)

  • 0
    A Score Level 1
     in reply to Vinay Kumar Rai
    Hi

    Thanx for your prompt response.

    I have tried your suggestion, however I am getting the error of retrieval of data when I click on link in record grid list.

    Any suggestion.
  • +1 in reply to komalc3
    please try

    filter:a!queryFilter(
    field:"id" /* Your Primary Key Column*/,
    operator:"=",
    value:tointeger(local!uniqueIdentifier)
    ),

© 2024 Appian. All rights reserved.