Discussion Categories

Hi for this code am getting the error can someone suggest me what mistake i have done here a!dropdownField( placeholderLabel: cons!CR_APP_TXT_PLACEHOLDER_VALUE, disabled: ri!IsReadOnly_bool, choiceLabels: touniformstring( rule!APN_distinct( index( local!getContractIds_cdt, "contractId_int", {} ) ) ), choiceValues: touniformstring( rule!APN_distinct( index( local!getContractIds_cdt, "contractId_int", {} ) ) ), value: if( rule!APN_isEmpty( fv!item.value_txt ), {}, apply( trim( _ ), split( fv!item.value_tx

I'm trying to export SQL data to excel, but I'm facing an issue.  An error occurred in executing an Activity Class. can somebody assist with where information I'm going wrong Much obliged!!

Getting an error like this what to do ?

Hello, I am learning query entities and I am getting the warning message (missing domain prefix).  cons!UA_DSE_STUDENTSINFO is mapped to UA_Students DB. I believe it is configured properly because I use the same constant to write values to DB. I am getting the same warning message when I try to use sorting. 

Hi, Any one knows from where the Schema value will be pulled when we select Data Source value. No where I have given the Schema value during Data Store setup.

Certification fees and any center at Pune? I am looking to appear for Associate Developer to start with. And continue for most other exams.

It is showing like this 

Im new to Appian. I already log in with my email. But when im going to introduction to Appian. Im getting this message. Can someone help?

Hi, I have below setting customer.properties. conf.data.APPIAN_DATA_SOURCE=jdbc/SqlServerDataSource  tomcatResources.xml <Resource name="jdbc/SqlServerDataSource" factory="com.appiancorp.tomcat.datasource.EncodedPasswordDataSourceFactory" type="javax.sql.DataSource" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://xyz.nam.nsroot.net:2431;databaseName=TestDB" username="xxx" password="xxx"../> Now, by using above settings, how can I connect to the database. Do I need to use any specific object to read these properties and form a connection string or do I need to follow any other process. Can someone advise. Thanks.

Just Need Clarification ! It would be great If clarified !

I'm using escalations to send notification emails to managers every day until the task is completed. The first escalation email is sent correctly, but after 4 hours the system sends the second email. Thereafter the notification email is sent once a day, only the first day it's sent twice. Is that something with the time zone issue?

plz suggest the solution

Hello,  I downloaded the Fitnesse version for Appian and to run a test example I need the file log4j.properties which is missing. Has anybody had this same issue?

Hi Experts, Do we have any Field where user can search for exiting list of values from database, and if value is not there in the list then whatever value user has typed in can be written to DB on the form submission. Later the value will become part of the list. Thanks, Gaurav Singh

a!localVariables( local!isChanged:a!refreshVariable( value: ri!isChangesMade, refreshOnReferencedVarChange: false), a!formLayout( contents:{ a!buttonLayout( accessibilityText: "Select a Type of Service", secondaryButtons:{ }, ) } ) } ), a!radioButtonField( label:"Do you want to make changes to any services?", choiceLabels:{"No","Yes"}, choiceValues:{false,true}, value:local!isChanged, saveInto:local!isChanged, ), if( local!isChanged, rule!SS_ui_serviceGrid( ), {} ), }, ) )The Interface has different services listed at the top of the form. If I select one service, select 'Yes' for radio buttons, and make changes to the grid and go to other services. when I come back to the previous service, the cha

Does anyone know there are any vulnerability reports of appian？We want to use Appian, but our company's security team want to have this report to prove the security of Appian.

Hi can someone suggest me with the UI design for the below grid  so the first row contract number- if the user change that number based on that number below grid data has to be populated how can i achieve this? where can i configure remove button for this grid so that this complete grid will be removed but will be having multiple grids one after the other with different data based on the contract number  if not this can suggest for how can we removed that contract no data

Hi,  I have three new columns i need to pass to database table which doesnot comes from excel sheet. I tried using import excel to database plugin, it says below way to configure for new columns and values but same not working saying expression is open ended , has anyone able to use it ?

a!localVariables( local!oldCdt: rule!ITS_GetPQRRequestByPqrRequestId(pqrRequestId: 71), local!newCdt: rule!ITS_GetPQRRequestByPqrRequestId(pqrRequestId: 80), local!fields: split( stripwith( tostring( 'type!{urn:com:appian:types:ITS}ITS_PQR_REQUEST_DETAILS'() ), "[= " ), "," ), tostring( a!flatten( a!forEach( items: local!fields, expression: { if( exact( if( isnull(local!oldCdt[fv!item]), "", local!oldCdt[fv!item] ), if( isnull(local!newCdt[fv!item]), "", local!newCdt[fv!item] ) ), {}, fv!item & ": " & local!newCdt[fv!item] ) } ) ) ) ),

Through a form in an interface, I upload files or images and it is stored in my db as a number (I guess it's the ID, image bellow). The images are stored in a folder in my KC This is the expression of my fileupload a!fileUploadField( label: "Cedula: PARTE FRONTAL", labelPosition: "ABOVE", target: cons!CWA_OEC_DOCUMENTS_FOLDER_POINTER, fileNames: ri!CWA_OECClient.coeccedula&"_"&"c1_frontCI", maxSelections: 1, value: ri!CWA_OECClient.coecfile1, saveInto: ri!CWA_OECClient.coecfile1, required: true, validations: if( or(upper(fv!files.extension) = { "PDF","PNG","JPG" }), null, "Please upload a valid image type: png or jpg" ), uploadMethods: { "CAMERA", "CHOOSE_PHOTO", "CHOOSE_FILE" }, buttonDisplay: "LABEL_AND_ICON", buttonStyle: "PRIMARY", buttonSize: "LARGE"

Here is my code  I understand that error i how can i use the same nested if without error?

I have completed all the release training that was assigned to me but still my appian senior developer certification expiry date is still not extended kindly advise

Hello everyone We use the Appian(on premise version) and want to connect with MYSQL.I think we can use user id and PW to make it work ,but it means we need to store this sensitive info in our service(GCP) and someone can get by check the detailin < configure.bat >..file. So I want to know whether we can use the service account for database security authentication to connect with the DB or not ?

I need to convert .rpt file to appian document receiving from the response body , Can Appian Integration convert .rpt file to Appian document? or is there any solution?

Hey, Guys where I can find the SQL database for my Practice Test?