General

Hi!   We are currently passing in a folderId over a WebAPI call to Appian - from there we are using a!startProcess to run the Document Zipper smart service to zip the folder and output the resulting documentId. Is there a way to allow the resulting zip document to be downloaded via the WebAPI call, or will I have to use some workaround like using an additional GET method to pull the document after using POST to run the smart service? Thanks!

What are the challenges You people faced while developing ? How did you resolved it?

Just Installed Appian on Linux (Centos) But the site is not redirecting to /suite page. What am I missing? I get the error below when I load the site Any help will be appreciated. Thanks

a!formLayout( label: "View Document", contents: { a!sectionLayout( contents: { a!documentViewerField( label: "Document Viewer", labelPosition: "ABOVE", document: 5080, height: "MEDIUM" ) } ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, value: "Submit", saveInto: ri!buttonvalue, style: "PRIMARY", loadingIndicator: true ) }, secondaryButtons: { a!buttonWidget( label: "Back", submit: true, value: "Back", saveInto: ri!buttonvalue, style: "NORMAL", validate: false ) } ) ) I want to see the document  in the interface with the help of this code but  I am not able to do this. Its directly download the document how can I see the document ?

Hi, i am getting this error but there is no further information on which expression rule might be causing this. Checked the tomcat logs but the stack trace does not show any further useful information either. Error evaluating UI expression Expression evaluation error [evaluation ID = 43f47:2469d] : Invalid index: Cannot update value of length 5 by assigning value of length 1 Anyone can advise on how to troubleshoot this error further?

Hii All, I have one  dropdown field in my interface , which is consists of 12 items in those 12  for 5 items , if i select particular item one integer field should be visible . the thing is if anyone of the item selected in those 5 items the common integer field is to visible ,  if we select remaining 7 items in drop down the integer field should not visible note only single integer field is used in interface  we need to map 5 items in the dropdown out of 12 to a single integer field to give visibility based on selection  IN 12 ITEMS : 2 OR 3 OR 7 OR 8 OR 10  is selected then only the integer field should visible or else  disable the visibility  please help me on this thanks 

Hi Team, I recently took Appian Associate Developer certification got my certificate. There is a name mismatch between the last name I provided in my Profile and the certificate I got. Could anyone please tell me how to correct this name or whom should I contact. I have contacted Examity support but they told that they doesn't have controls over it. Thanks in Advance

Hey there! It's been 18 months since we launched the Appian Certification program. Now that A-scores have completely retired, we're embarking on updating the certification exams and starting with Associate Developer. A team of Appian developers recently put together a revised list of test objectives and topics, and we'd like your input as well. The results of this survey produce an "Exam Blueprint," which will influence which topics make it to the final exam and how many questions we ask under each topic.  We have a short turnaround on these surveys as we need to perform analysis of the results and provide to the exam writing team who will start very soon. The survey should take you about 20 minutes to complete, and ends Tomorrow (November 16th) at the end of the day.  Please find the survey here: https://docs.google.com/forms/d/e/1FAIpQLSfaaE4bBqkpKiDlFMeBOZmrJHiC0kqqqB71QQC7CDXKJo4O-A/viewform If you missed it, then no worries. We'll be doing

hi, i am using log reader plugin to read rdbms logs, the latest "rdbms-audit.log.yyy-MM-dd" is being read properly, find the code readlog( "audit/rdbms/rdbms-audit.log.yyy-MM-dd", ) after 10mb size limit the log is getting rotated and is changed to "rdbms-audit.log.yyy-MM-dd.1" and readlog("audit/rdbms/rdbms-audit.log.yyy-MM-dd.1",) is not returning any data Can someone please let me know how to read the "rdbms-audit.log.yyy-MM-dd.1" log using readlog()

a!queryEntity( entity: cons!ITS_PQR_REQUEST_DSE, query: a!query( selection: a!querySelection( columns: { a!queryColumn(field: "phaseAdvisory", alias: "Phase_Solution_Impact"), a!queryColumn(field: "lengthAdvisory",alias: "Length_Solution_Impact"), a!queryColumn(field: "valveClosureAdvisory"), a!queryColumn(field: "operatingCondtionAdvisory"), a!queryColumn(field: "flowRateAdvisory"), a!queryColumn(field: "fluidPropertyAdvisory"), a!queryColumn(field: "fluidTypeAdvisory"), a!queryColumn(field: "pipelineMaterialAdvisory"), a!queryColumn(field: "leakCharacteristicsAdvisory"), a!queryColumn(field: "systemAdvisory"), a!queryColumn(field: "tiePointAdvisory"), } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "pqrRequestId", operator: "=", value: ri!pqrRequestId )

How to apply sort on the data that we get from  executestoredprocedure() while displaying on read only Grid?

Hi, Can anyone let me know the following regarding rdbms logs? I can see multiple rdbms logs created for a day, will these files merged before they are converted to .gz at 11:59 PM when exactly does the merging happen?

In the editable grid I want to add 2 rows on click of add row link, please help me out how to add dt ?

In an interface intially we didnt use this field for file upload and it displayed like below , all the upload buttons are greyed out. Later we used Disabled : false() for the same fileUpload and the out come is as below, upload button is enabled By default as it should be false and the upload should be enabled,but it was grayed out. Can anyone explain why it was like this

while trying to generate excel through smart node - EXPORT SQL to EXCEL,   i am getting the below error in process - The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk.  And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}  

I ran into small copy and paste typo in Appian 22.3 docs. Don't know where to submit this, I know it's not really a question. Hope someone can route this to right team correct it.  https://docs.appian.com/suite/help/22.3/Oauth_connected_system.html  https://docs.appian.com/suite/help/22.3/oauth_client_credentials.htmlIn this case it think it should mention Client Credentials Grant instead of Authorization Code grant. 

I have a string "a,b,c" I want to convert that to array of string.

Hi everyone, I'm having above error message after using a!todatasubset(), my code is as below:  local!pagingInfo: a!pagingInfo( 1, 1, a!sortInfo( field: local!emailsRelatedToCase.id, ascending: false ) ), local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo ), within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email. Did anyone see this error before? Thanks a lot,

I have table by name abc which have columns id(pk),refId(FK),uniqueId,languageId,locationhere language Id is : id for languages ex: english =1 , french=2, hindi=3 etc unique id is: if say for refId(fk) there are 5 location then unique id is 1,2,3,4,5 for language id 1, unique id is 1,2,3,4,5 for language id 2, unique id is 1,2,3,4,5 for language id 3 etc so here my requirement is based on selection of ref Id I want to add location using grid but here challenge is user can allow to add location in all available languages and need to maintain uniqueid's same.one thing need to consider is unique Id should be the next number to existing unique id for that particular refId.Please do help, am struggling to implement it.                                                                        &

In a gridField() fed by record data, when you try to use the disableRowSelectionWhen param, record references fail to be evaluated. As an example, we were trying to disable row selection based on a date time in the record data. Originally we had it wrapped in a todate() so we could compare it to a date, but the logic was failing to disable the desired rows. Just for fun we removed the todate() around the record field reference, only to be smacked with an error about not being able to compare Null to a date. That's right, the record reference evaluated to Null. For more fun, we tried using fields that were not dates, and the same thing happened on integer fields, i.e. the record reference evaluated to Null. Has anyone else run into this? 

how to redirect to site record page by using record link. a!linkField( links: a!recordLink( label: fv!row['recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type.fields.{986b4d5b-200e-4665-a365-33808cab1533}name'], recordType: 'recordType!{3a9fe53d-c80b-44ca-9818-c29c6bd853a5}TRM Request Type', identifier: fv!identifier, dashboard: "summary", openLinkIn: "NEW_TAB" ) )

only document id shown  is there any changes in Interface ?

a!localVariables(local!x:{{name:"rajini",marks:25},{name:"vamshi",marks:30},{name:"rajini",marks:40},{name:"venkatesh",marks:88}},/*using index,wherecontains() need to fetch only rajini details*/)

Is there a way to filter a grid on the rows that you selected or have not selected. Use case being if your grid is really large and data are on multiple pages. When you go through pages selecting items, maybe you want to filter by selected items to see all the items you've selected? Is there a way to make a selected filter? Not sure if this can be a user filter.