picker and text field

Question

Hi all , 
 I have the requirement , 
 When user types in the field , it shows down the list as suggestion but it also allows to save what is not in list . (Eg: when "a" is typed : --> {"apple","aeroplane","awesome"} is suggested . But when user types "akward" ,which is not in list . It is still able to save this word in local variable. I refered to ( https://docs.appian.com/suite/help/19.4/recipe-configure-an-array-picker.html ) . But when I typed, whats not in list , it says "No search found" and doesn;t allow me to save what I typed. ANY HELP ? Kind Regards

vinayp0002 · Answer

Got the issue, In your suggested function , fetchTotalCount is not set but checking the condition based on total count. 
 So, It works fine now with the below code : 
 
 =if(
 isnull(ri!search),
 todatasubset({}),
 with(
 local!types: a!queryEntity(
 fetchTotalCount: true(),
 entity: ri!entity,
 query: a!query(
 filter: a!queryFilter(
 field: ri!fieldName,
 operator: "includes",
 value: lower(ri!search)
 ),
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 10,
 sort: a!sortInfo(
 field: ri!fieldName,
 asending: true
 )
 )
 )
 ),
 if(
 local!types.totalCount > 0,
 a!dataSubset(
 startIndex: 1,
 batchSize: 10,
 totalCount: local!types.totalCount,
 data: index(local!types.data, ri!fieldName, {}),
 identifiers: local!types.identifiers
 ),
 a!dataSubset(
 startIndex: 1,
 batchSize: 1,
 totalCount: 1,
 data: ri!search,
 identifiers: ri!search
 )
 )
 )
) 
 
 Thank you

arunramanathtm · Answer

Create an expression rule with the below code snippet and call this rule in your SUGGEST FUNCTION: 
 
 Expression Rule inputs: 
 choiceList: text(multiple) 
 searchValue: text 
 
 Code: 
 if( contains(ri!choiceList,ri!searchText), a!dataSubset( startIndex: 1, batchSize: -1, totalCount: count(ri!choiceList), data: ri!choiceList, identifiers: ri!choiceList ), a!dataSubset( startIndex: 1, batchSize: 1, totalCount: 1, data: ri!searchText, identifiers: ri!searchText ) )

picker and text field

Top Replies