Discussion Categories

Greetings, I am having an issue with a!exportDataStoreEntityToExcel() but I do not have an issue with a!exportDataStoreEntityToCsv(). They use the same inputs. I have uploaded a screenshot of the error message on the interface. I checked the tomcat-stdout log file and it says java.nullpointerexception. We are using a View on a PostgreSQL database. I am not too positive but it might have stopped working after manually erasing some rows in the tables for the View. We optimally want the Excel one working. Does somebody know what is wrong or have a similar issue? a!buttonWidget( label: "Generate Export of SFNS Orders", tooltip: "Export Available for Product Creators", /* tooltip: if(local!productCreatorUserStatus = true, null, "Export Available for Product Creators"),*/ saveInto: { a!exportDataStoreEntityToExcel( entity: cons!PMT_DSE_VIEW_SFNS_VIEW_ORDER_GRID, selection: { a!querySelection(

a!localVariables( /* 1 - requestId, 2 - Department, 3 - Sub Department, 4 - Requestor, 5 - Status, 6 - Ship Name, 7 - Task Status */ local!inputList: split(ri!input, "#$"), local!requestId: tointeger(local!inputList[1]), local!deptIdList: tointeger(split(local!inputList[2], "-$-")), local!subDeptIdList: tointeger(split(local!inputList[3], "-$-")), local!requestor: touniformstring(split(local!inputList[4], "-$-")), local!shipId: tointeger(local!inputList[6]), local!statusIdList: touniformstring(split(local!inputList[5], "-$-")), local!taskStatus: toboolean(local!inputList[7]), local!result: a!flatten( a!forEach( items: enumerate(5), expression: a!localVariables( local!batchSize: 2000, local!startIndex: if( tointeger(fv!index) = 1, 1, 1 + ((fv!index - 1) * local!batchSize) ), /*rule!BUS_QE_getBUSReqViewDetails, BUS_QE_getBUSReqVWDtlsTest*/ rule!BUS_QE_getBUSReqVWDtlsTest( fetchtotalcount: t

Hi everyone, Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the data store [CR Data Store]. No values have been written. Details: could not insert: [CRModuleCommentsDT2354] (APNX-1-4208-004) This error will not be displayed to the user viewing this form.  I am getting this error in interface,as per the requirement made changes  and in the existing implementation  a!writeToMultipleDataStoreEntities used in UI. Can anyone suggest me a solution for it? Thanks in advance.

Hi everyone, here is my interface a!startprocess in this interface always return the same result even if I update cusNum parameter still same value and here is my process model: when i run the process model: here is the call integration data outputs :

Hi Appian, Is there a way that we could find if document object exists by document id? Thank you

appian send email for user input task. How i resist submitted task  appian email.... After task submit, this message come. I dont want below message in email . How I resist it .

Hi Team, I have a requirement to send email outside our organization with an embedded link to either accept or reject the mail. Once the recipient receives the mail, he/she should click on the link which would open up a page for the user to either accept or reject the mail. This information then has to be passed back to Appian and the work-flow to be continued then. This email response from user is time-bound. If within specified time the user does not respond then the default work-flow is to be followed. We don't want to use a delay timer. We would like these processes to be asynchronous. Can someone suggest me how to achieve this? Any help is appreciated. Thank you!!

Hi, I am trying to export entire Application code to install/deploy on a different server. Once after export is done I was able to see .zip file. Now when I try to open the .zip file it was showing an 1 errors/warnings Any one faced this kind of issue.

Process Model ran successfully but Values were not written in DB in Write to multiple data store entity. We have the values available in variable, what can be the cause?

We are currently using "SFTP Smart Services" (https://community.appian.com/b/appmarket/posts/sftp-smart-services#) to connect SFTP and retrieve and send files to folder of SFTP. We connect using External System Key that uses username and password. Recently, the requirement has changed to have a multi factor authentication for this connect, i.e., every time we connect to SFTP there will be an OTP sent to an email ID and that needs to be used to connect to SFTP along with user credentials. Please let me know any leads on this.

Hello, The documentation says I should be able to execute and return the results of a robotic task in an interface, but I'm having trouble figuring this out. My task is working correctly in the RPA, and I'm also able to run it in a process model, but I can't figure out the SAIL recipe to get the results in an interface. The farthest I've gotten is that I know I need to use a!testRunResultForId(), but it says I need to input the "Test run ID," and I don't know where to find that. Can someone help me out? Thank you, Jason

Hi techie,Is it possible in Appian to give a value inside the donut chart like I below?

Where/ How do I view the record Identifier?  What is the identifier? Attempting to setup a a!syncRecord and unsure the value to put in for the identifier.

Hi, I am trying to find out key column value and if it contain {3,9}, I want to show the specific column. But, I am encountering below error. Can someone advice what needs to be done. Thanks in advance. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 2]: Invalid types, can only act on data of the same type (Number (Integer), Record Field)

I have a .pem and .key file provided by ADP. I have uploaded to the Admin Console under "Certificates" --> "Trusted Server Certificates", when I add it to the "Client Certificates" I get a error for missing key file even though I'm not sure how to add it as well since its only looking for a .pem file. First question: is this correct to add it under the "Trusted Server Certificates" to use in an integration that calls the web service or should it be in "Client Certificates" and if so, how do I add the key? Now I read in the documentation that you're supposed to create a "Connected System" with HTTPS and set Authentication to "None". But I have a client id and client secret to add but to the body. Second question: Do I create a Connected System with None Authorization, then create an Integration that adds the client id/client secret to the Body in there? Third question: how do I utilize the client certificat

I have a table with value column. Already I have implemented download link in my report based on the table. I need to add a new column with formatted value, front end I have done this, but download part, how can I manage(I dnt want to change backend table)

Hi Guys, In my project, we currently did a webapi to get the base 64 from system and pass into different system as base64. Due to this in prod we are facing large memory sizing and I came to know instead of passing bas64 we have a option to pass todocument to reduce the memory size . However, my question how other system can read if we are passing document? Please confirm the approach is possible or else suggest some other approach. Thanks, Pradeep Sridharan

Can anyone please help me on subjected issue as I am not able to access admin console. Also while debugging the process model, it is not getting completed after user input task form has been submitted. Kindly guide!

just wanted to know the step how to trigger an record action from submit button

As there is so much white space shown .. how to prevent in interface ,extra white space

Hi  I want to add two user filters in record the data to those two filters is two columns data from DB when i tried was getting error like below  And the data have duplicate values but need unique values only kindly suggest for this also a!recordFilterList( name:rule!ATRFA_translateLabel(field:"wbs"), options:a!forEach( items:cons!ATRFA_ENTITY_SETTLE_REQUEST, expression:a!recordFilterListOption( id:fv!item.wbs, name:fv!item.wbs&" ["&fv!item.wbs&"]", filter:a!queryFilter( operator:"=", field:"wbs", value:fv!item.wbs ) ) ) ) Error: The Requested Record Type Is Not Available The WBS user filter expression for record type ATRFA_Settle_Request failed to evaluate. Details: [Expression evaluation error at function a!forEach [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!recordFilterListOption [line 7]: Invalid index: Cannot index property 'wbs' of type Text into type

If I want to develop look alike application as IDP in a simple way. What are things need to be considered in designing, development?

Is Appian supported with multi-factor authentication for the created applications? i.e. end-users will be required to login with 2FA whether SMS OTP, Email, or Google Authenticator. I found a link here in the community, however, it's broken.

Hi Experts, We got a specific scenario from our client where we have to keep our process waiting until a time provided by user matches with the server time. So from the UI user is providing date in one field as &quot; MM/DD/YYYY&quot; and time in a different field as &quot;HH:MM:SS&quot; and timezone in another field.The process node must only gets triggered or move to next node only when time provided by user matches with the server time.I&#39;m using below code but its not working as expected a!localVariables( local!split: split(ri!endSearchTime, ":"), local!day: day(ri!endSearchDate), local!month: month(ri!endSearchDate), local!year: year(ri!endSearchDate), local!endSearchDateTime:datetime( local!year, local!month, local!day, local!split[1], local!split[2], local!split[3] ), todatetime( if( local!endSearchDateTime - ((gmt(local!endSearchDateTime) - local!endSearchDateTime) - rule!TEST_ER_TimeZoneOffset(ri!endTimeZone)) < now(), now

Hi, Is there a way we can provide a link in an interface to download the data in an excel from a recordtype. Thanks