Foundation

Hi All, before two days ago, Appian server crashed and we were not able to access it, how can I know what is the problem? Thanks.

How might I get the number of seconds between NOW() and a date in the database? I checked various other resources like this But was not fully satisfied with whether what I was doing is correct or not. Can someone Guide me? Much appreciated.

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 ?

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?

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

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"

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

Hi, I wanna check type file. How to check type file? Thanks,

An Error Has Occurred An error occurred while retrieving the data for "EISOP Employeeinterview". Details: Expression evaluation error while parsing rule 'eisop_candidatestatus': Missing right parenthesis in expression, found COMMA (APNX-1-4205-003) Where to find these issuse 

Hello  I need to update my data in db(new status) whenever the previous section completed and i don't need previous data(perious section). Thus if L1 has store the status in db as selected , then After L2 has store the status as selected in L2 ,  The L2 data has to update in db ,i don't need L1 status .  i just need final updated one. Please find my Attachments  Please ping me for extra information Thanks and regards  Pavan 

I'm getting 5 field values from CDT Aand  other 5 field values from another CDT BI need to save both 10 field values from (CDT A and CDT B) in CDT C. How can I Configure this Process model?

I have requirement where i have a interface in which I have two fields let's say "error" and "error type" And also I have the below fields, Personal details (section header)                 Name - jack                                 Last name - rayan                       Mailid - blank Then the result should be, Error          - personal details Error type - mailid

a!queryFilter( field: "completiondate", operator: "between", value: {today() - weekday(today(), 2) + 1, today()} ) }, ignoreFiltersWithEmptyValues: true ), Need clarification For value : ( 4 th line ) 

I want to perform this validation after clicking on submit button.

is there any way to find group Name by UUID? (tried get contentdetailsbyUUID) nothing worked...

Hi  my requirements is i have 2 grids one after the other when i add a row in the first grid i have to get one row automatically in the 2nd grid [second grid will be user input grid] can anyone help me on this 

Hi everybody, How to merge many file excel into a file excel with many sheet Do you have document about Merge Excel Document? Thanks a lot.

I have a requirement to get the top 3 documents list which are larger in size in a KC. I was a able to get the complete list with getfileslargerthansize() but doesn't know how to get top 3 documents onlly. Can anyone please help. Thanks in Advance

Hello I have a requirement to read a .txt file contents in Appian. We are getting this file via SFTP and this file has some Chinese characters. I tried using readlinesfromtextfile function which is part of Text File Function plugin. This works well for all data except the data/ text in Chinese. My sample data is 肖恩 and when I read it in Appian using readlinesfromtextfile I get ?? in place of these Chinese characters. I have enabled Chinese language from admin console. Anyone has any idea about this or any other way to read Chinese text from .txt file?