New to Appian

My goal is to produce an excel file from a set of Clergy Pension records.  My plan to do this is: 1.  Create an CDT to hold the data for the excel spreadsheet 2. Create an Expression Rule to create the data for the CDT 3. Use the Expression Rule in a Process Model to populate the CDT 4. Use the Export Data Store Entity to Excel smart service in the Process Model My problem is with the Expression Rule,  In the Expression Rule, I create two local variables; data and report.  The local variable holds the results of the query and the local variable report is formatted data for storage into the CDT. To create the local!data, I use a!queryRecordType() to pull the records I need.  The data comes from several tables and I use the Relationships from the main table of the query, CPMA Clergy Pension.  I filter and sort the data. Here is the code for local!data. local!data: a!queryRecordType( recordType: 'recordType!CPMA Clergy Pension', fields: { 'recor

Why I cant see the database and admin in top grid. I am trying to create a database for my application

Hello, Could you please confirm is there any way to test appian application using fitnesse and cucumber (Selenium BDD) both tools. Also, how to integrate fixture files in fitnesse for appian application. Thanks in Advance.

I am facing issue in identifying the objects using Selenium/Java on sample Appian application available at Community edition site as below: Similar issue I am facing in working project screens for one of the clients. 1. Multiple - Dropdown: The dropdown values are not defined as Static. The <div> id has changed whenever page is getting reloaded. 2. Date Selector: The <div> id has changed whenever page is getting reloaded. sendKeys () method is also not working since the field was changing dynamically.

In exercise 8, when I want to do "Start Process for Debugging", I get the following error whenever I try to enter values into the fields "Expression evaluation error [evaluation ID = FI5GM] in rule 'wsaa_addvehicleform' at function a!fileUploadField [line 107]: WSAA Vehicle can only be indexed into using square brackets or the index function" Could someone help me to fix this?

a!startProcess( processModel: cons!CE_GERAR_PIX, processParameters: { token: local!token, idSolicitacao: ri!idSolicitacao, valorPrevisto: local!value_for_payment, fileHistoricoContrib: local!uploaded_contrib_history_file[1], result: null }, onSuccess: a!save( local!test, fv!processInfo.pv ) ) The result is not being updated from process model As it's a portal, I can't use a form inside the process model. At the Output, as you can see, the result is being stored. The process instance stores the variable, but it doesn't load the `Result` for the interface The instance: So what should I do to accomplish it? Any documentation into that? the interface onSuccess calling doesn't fully load the values I am expecting

Hi  Please tell me how to use sync record smart service. here is my configure result. I got a error. I do not know what is causing issue

Hi, I am unable to login to my community edition site from my personal laptop but can do so from Company laptop. On giving creds, it says " Unable to sign in". Can anybody give me the reason for this ?

Hi Team, We are facing issue to select value in drop downs - Drop down 1 and Drop down 2. We are working on FitNesse /Appian 24.1 using Wiki Keywords as below: |populate field |Drop Down 1|with|Cover1| |populate field |Drop Down 2|with|Cover2| Error in Test - Timeout period reached: Wait for Field - Drop Down 1 Please suggest to resolve this issue and how to select respective values in both drop downs using Wiki Keywords. Thank you. Shivi Khan

Hi, We installed and configured the FitNesse for purpose of working with Appian sites to perform some AUT. Hence we configured with given Two Example by adding the appian url with version and username but getting following errors, cannot launch the appian site. 1. At first setup and launch of FitNesse worked but had issue in invoking the Appian site and throws following error 2. Unable run the Test itself also and throws following slim error message;  This was done after closing browser and than restarted the batch job of FitNesse & ran the test. Testing was interrupted and results are incomplete. Test Pages: 0 right, 0 wrong, 0 ignored, 0 exceptions     Assertions: 0 right, 0 wrong, 0 ignored, 0 exceptions (0.625 seconds) Could not complete testing: fitnesse.slim.SlimError: Error SLiM server died before Header Message could be read. Unable to start test system 'slim': fitnesse.slim.SlimError: Error SLiM server died before Header Messa

New to Appian, Hello, I'm doing step 10: Process Modeling 101, part 2. When creating a Related Action, step 7 of the exercise, when i click REQUEST MAINTENANCE to test the action, this error message appears (An error occurred while applying the context for the W0112AX Vehicle related action [identifier=41,530]. Details: No process parameter found corresponding to override [name=pv!vehicleId]. Non-parameter process variables cannot be overridden.)

In the documentation for the Send E-mail smart service, it says to put a semicolon between email recipients. This is the expression I am using. = toemailaddress( pv!spkrRecord['recordType!PMSO Speaker.fields.speakerEmail'] ); toemailaddress( pv!parishProfileRecord['recordType!PMSO Parish Profile.fields.parishContactEmail'] )  However, the first recipient receives the email, but the second one does not.  What am I doing wrong here?

Hi All, Is there a way to find user logged location in appian?

Hi! Has anyone else experienced difficulty uploading documents while creating a document in appian recently? When attempting to upload a particular document, there's a significant delay followed by an error stating, "File could not be uploaded. Please try uploading it again." 

hi I would like to ask a question I want to know how to use Query database, so I tried it, but it doesn't work. Here is my query database

Hello Experts, Currently, I'm working as an Associate Appian Developer for a company while also preparing for the Senior Developer certification. I believe practical knowledge is essential for this certification. Could you please suggest a use case for a proof of concept (POC) that covers topics relevant to the Senior Developer certification? This will help me learn with practical experience.[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

There is a user who is already present in the Appian environment. If I change the last name of the user will the user cab still access the application or the user's account will get reset and the user will automatically get logged out from the respective applications and groups. Example: In the current situation: User's First Name (dummy) : Vivian User's Last Name (dummy) : Richards The current name of the user is 'Vivian Richards' and the user is currently active in the system. I want to change the username as: User's First Name (dummy) : Vivian User's Last Name (dummy) : Williamson Richards Is it possible to change without affecting the user's credential or any actions related to application's specific group. Any inputs/solutions will be greatly appreciated. Thank you

I ran into this problem when creating an expression rule for pulling the current pastor for a given parish Id (organization Id).  The Id is passed in a Rule Input as parishId. I have three tables that are needed for this query, all are related. Clergy Member, Clergy Assignment, and the reference table for the Position name.  I need to pull the assignments that are current, i.e. where the Position Term Date is greater than today or null (for permanent assignments).  This is a very similar problem to the one I posted here:  [mention:aa603d0cc3424d8185dbd2f2ce5acf40:46448885d0e64133bbfbf0cd7b0fd6f7:label=queryRecordType%20with%20an%20%26quot%3Bor%26quot%3B%20condition]  Now that a!queryLogicalExpression is my new best friend (a big thank you to Stefan Helzle for the intro) is used a very similar logic.  Since I wanted the results to be a Clergy Member record type, I used that as the record in the a!queryRecord function. a!queryRecordType( recordType: '

I have taken appian associate developer exam yesterday, i got only 28 out of 60,but am confident to get more marks,any suggestions pls

Hi Everyone, I need to display multiple radio buttons in a single column of a grid. I am not sure if this is possible. If anyone can suggest would be helpful.

Hi Everyone, I am opening an interface 2 from interface 1 through record summary on click of link in interface 1. I need to have a cross icon in interface 2 upon clicking it, will open the first interface again. Can anyone please help me.

Hi Everyone, I am querying the db table through query record type. This query gives the list of db records. When I am using this in interface and using index to get the particular field, it gives this list of particular field. In case of null or single it also gives list. Can anyone please help me when it is null or single value should not give list.

I need an Expression Rule that has an or condition for a filed. I have a list of clergy assignments and I need to pull all current assignments and those that terminated over the last year.  The record type, CPMA Clergy Position has a termination date for the assignment, clergyPositionTermEnd which is a date formatted field.  If the assignment is for a fixed term, then there is a future date in the field.  If the assignment is a permanent assignment, then the field date is null.   The or function would look like this. or( RecordType!CPMA Clergy Position.field.clergypositiontermend >= today()-365, isNullOrEmpty(RecordType!CPMA Clergy Position.field.clergypositiontermend) ) However, I do not understand how to use this inside an Expression Rule.  My Expression Rule using the queryRecordType function looks like this. if( a!isNotNullOrEmpty(ri!clergyId), a!queryRecordType( recordType: 'recordType!CPMA Clergy Position', pagingInfo: a!pagin

HI team, i want to find the type of extension and Size of list of documents and i have used document function and build an expression rule it is working fine in expression rule as expected when i call that expression in an interfcae  it is shoowing error as document function is deleted.  a!localVariables( local!size: a!forEach(ri!documents, document(fv!item, "size")), local!extension: a!forEach( ri!documents, document(fv!item, "extension") ), toboolean( and(and(reject( fn!isnull, { a!forEach( local!extension, if(fv!item "pdf", false, null) ) } )), and(reject( fn!isnull, { a!forEach( local!size, if(fv!item > 5000000, false, null) ) } ) ))) ) when i use in interface getting error as shown below

Objective is to display the firstName of all active users. a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)).data ref {user() Function - Appian 23.2} throwing below error  Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.