Foundation

Hello Assume radio buttons A,C, Z, Other, F (db gets data in this manner) we can easily sort but other should be at end of the list The order is alphabetic but other to be end Using Query Records Ant Cat Frog Z Other if we just do sort, we can get below which is wrong as per req Ant Cat Frog Other Zebra

What are the challenges or Limitations of Appian

Hi All - I do have Designer access to the environment, however I'm unable to open a record summary page of all the records. Once I click on record link then I am ending up with below error.  Even, while I am trying to open Appian OOTB record 'USERS', once I click on user name then I am ending up with the same error. Any thoughts pls ? Do I need to be added any system groups to view the record summary ?

What is map function what it does and how we use it. I see in some interfaces it has been used in ruleinputs as a datatype.

Hi all, I am trying to solve the problem  that HTML to PDF (Page Number and Custom Fonts) Smart service Doesn't  Support Arabic language when  pdf document is generated. will this issue be solved by changing the Font document? or it's a plugin issue?

hi here i have plugged in the sub-interface in the main interface but am not able to view that interface only buttons i can see from that interface  sub-interface is working fine 

Hi, I am very excited to announce the release of my book "Low-Code Application Development with Appian". It will be available at the end of April and I can't wait to get your feedback. Meet me at Appian World Miami on Tuesday afternoon in the Community Hub to discuss all things Appian, low-code, and business process automation. I have a few discount codes I'd like to share with the you. Find the book at Amazon: https://www.amazon.com/dp-B09SZ5V53W/dp/B09SZ5V53W Happy low-coding, Stefan.

Hi All, Thanks in advance!! Here is my scenario, While data is retrieved successfully from a view(SQL Server) and displayed on the interface for some users, but for few users same data is not retrieved and shown on UI. It's simple queryentity rule where we pass Input for the data to be retrieved  with rows having same input field.

Hi all i have a requirement that user entered date time field to json format  "2022-08-15 00:00:00.0" how to convert it , from appian end, i tried text function - text(now(),"yyyy-mm-dd HH:MM:SS")  but it returns current date time it should be user entered. Thanks In Advance

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