Hi Appian Experts,
Need you help in an issue that I am facing in the Portal.
We have one Portal UI which is having a Custom Picker field which is extracting/suggesting the values based on the input given by the user from the Record Type which is fetching data from the DB:
The below image is taken when accessing via a personal Admin account on the Interface itself:
When using the Service account(Which is added in the Users group and having Viewer permissions) while accessing the Portal the custom picker field is showing No Results found:
The below image is taken when accessing the Portal via a Service Account:
We are unable to identify why the list is not populating on the Portal. Although earlier it was working well. Do anybody else faced something like this while using the Portal ? If Yes, then what they did differently.Need help in this regards.Thank you for your time and patience!
Discussion posts and replies are publicly visible
Do you see any error messages? tomcat-stdout?
How do you lookup the data? Any code you can share?
we are querying the data from a recordType object sourced from a database table.
No, we are not seeing any error messages. This is the code of the function that we are using for fetching the data from the Record Type.
a!localVariables( local!data: a!refreshVariable( value: index(a!queryRecordType( recordType:'recordType!{3967e573-1ec5-494e-bcc0-bcfa6bd689e7}CDMP Agency', fields: {}, filters: a!queryLogicalExpression( operator: "OR", filters: a!queryFilter( field: 'recordType!{3967e573-1ec5-494e-bcc0-bcfa6bd689e7}CDMP Agency.fields.{agencyEn}agencyEn', operator: "includes", value: ri!search ), ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ), fetchTotalCount: false ),"data",{}), refreshAlways: true() ), local!topics: if( ri!toAppend, append( property( local!data, 'recordType!{3967e573-1ec5-494e-bcc0-bcfa6bd689e7}CDMP Agency.fields.{agencyEn}agencyEn', null ), ri!search ), property( local!data, 'recordType!{3967e573-1ec5-494e-bcc0-bcfa6bd689e7}CDMP Agency.fields.{agencyEn}agencyEn', null ), ), /* Add the search value to the data set! It will be cleared below if it is found already */ local!distinctTopics: union(local!topics,local!topics), local!top10: reject(a!isNullOrEmpty,index( local!distinctTopics, enumerate(min(10, length(local!distinctTopics))) + 1, null )), a!dataSubset( startIndex: 1, batchSize: 10, totalCount: length(local!distinctTopics), data: local!top10, identifiers: local!top10 ) )
I suggest to put a simple queryRecord on the portal interface to see whether the service account can fetch data at all.
There was some Service Account issue, the portal is working fine now. Thank you Stefan Helzle for your time.
Hi Stefan,
Could you please suggest if there could be anything with the expiry of the API Key created with the service account of if there could be some transaction limit.We published the portal with a different service account and then we republished it with the same service account which we were using earlier and it started to work.
As far as I know, service accounts and API keys do not expire. And I do not know of any relevant transaction limit for the communication between the portal and the Appian core system.