Discussion Categories

I'm adding a related action to my record type and it asks for a process model. However, after hours of testing, the related action isn't even calling the process model. Does anyone have any feedback? Or, how do I get the process model to work? James

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 all, I'm new at Appian and I need to install Appian on Local Windows desk. I've similar issues with 22.4. After I run  "password.bat -p <pw>", I get this error: Could someone help me?

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()

I am trying configure a related action to be nearly identical to how a a!submitLink works in the below code snippet. I need to reference a process model to configure a related action that can be setup like to my previous implementation of the a!submitLink logic. I am having a hard time determining if I can do what I need to do with a process model that would be the a!submitLink that allows for user confirmation of the action or cancel the action. See the code snippet below. Is it possible to convert this submitLink to a process model? If I am missing the documentation that documents the way to covert this a!submitLink into a process model instantiation/implementation, please let me know. Thanks! a!localVariables( a!cardLayout( contents: a!richTextDisplayField( value: { a!richTextItem( text: { "Rescind Case" }, size: "MEDIUM", style: "STRONG" ) }, align: "CENTER" ), link: a!submitLink( label: "

Hi! I'm using an a!match function in an interface. I have set the 'value:' parameter of the match function to the output of an expression which outputs a list of CDTs. Subsequently, I'm using this value parameter as 'fv!value' in other parameters. However, I'm receiving the 'improperly scoped variable' warning on multiple occasions when using fv!value (not in all cases). This warning is resolved when calling the same function that is called in the 'value:' parameter over and over again. However, I would prefer to refrain from doing this because of the performance implications of calling the same function multiple times. A code snippet is attached which shows the following: the times when fv!value is called in the 'whenTrue:' parameter (lines 6 & 14), no warning is given. When fv!value is called in the 'then:' parameter (lines 10, 20 & 23), however, a warning is issued. This does not rhyme with the expected b

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 )

Need help to design & create records for below requirement, Each day 1 parent file and 8 child files will be loaded into DB table. Each child file will be having separate columns except foreign keys. Consider fileReferenceId and dataId are foreign keys. I have to display parent file data on landing page and provide link on dataId. Once user clicked on any of the data Id, user will be redirected to new page where records from child table needs to be fetched & displayed using dataId and fileReferenceId. My Approach:  Create entity backed record using parent table. Whenever user click on dataId  , using 'fileReferenceId ' decide which child table needs to be called from 8 tables. Using 'fileReferenceId and DataId' display returned data on interface. Could you please suggest another approach to avoid so many DB calls. Is it possible to create separate record for each child table and link in the parent record. Thanks, Hemant.

Hi there, We have a requirement where we are calling  an API on tab out of field. If we have 20 fields 20 API calls will happen and in the payload we are every sending field. I know calling a integration in saveInto is asynchronous ,but loading will complete when all saveintos are executed.Is there any way to optimize it, because latency is very high (It is taking around 1 min to complete the loading). can we make it truly async like React or js based applications?

Dear Team, Am getting the following error message while calling a Endpoint from browser, only in one environment we are facing this issue and rest all working fine. Any advise would be helpful. {"resource":"\/suite\/webapi\/invalidWMUrl","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"} Thanks, Sunil

Hi team, Is there any way by which I can authorize the endpoints if the token expires without manual intervention? I can see we can use authorizationLink but that requires manual intervention. Thanks,

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

 i want to add the three fields into like eg firstname, middlename, lastname into one field as full name

Hi everyone, I have an interface which displays a list of documents (UI_ListOfDocument), and originally user need to choose one document in the list to preview it (UI_Preview  will be displayed accordingly showing that chosen document's content), then click back to the list to choose another document for preview.  The request is to create a pagination in the existing interface, so that user just needs to click the pagination buttons to see the next/ previous document preview. I already built the interface for the pagination, but was having trouble in linking the document to it to make it work.  Currently, all related document from the data table are queried using a!queryEntity(), and are saved in a local variable, including it's content.  If anyone has done this before, please leave an advise if possible. Thanks for your helps [emoticon:6d505171faa4497c85c5ca27290c555d]

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?

Hi there! We are looking for a plugin for QR Scan, We need scan and detect a QR from appian interface. Have we any way to do that? without take or upload photos? Usually we have seen this in many apps and Appian should have a way to do that. Thanks in advance!!

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

I have this stored procedure output where the column names are dynamic and may vary according to date range and the column names also have to be printed in the interface in Appian So can anyone help me with the way to print the field names in a dynamic way?

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"}  

Hi, I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text. When i try to verify the datastore, it is giving me the below error The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain. any help is appreciated.

Hi Everyone, I have a read only grid which is connected to Pie chart. When I open the report it should show all the rows with the selected filter but it is empty as below. When I click on any slice in pie chart, the grid is displaying the respective rows  These are filter options I have used in my grid configuration Please help me how to all the rows with selected filter (isresigned)  in the read-only grid when opening the report. 

Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!

How can i get the data from the api into the interface ? like in my scenario i want the movie details once i enter my movie name , and the thing as i had created the intergration using the link and it's working .now i just want to know how can get the values in my interface once i click the movie and submit button.

We have a solution based on record centric approach, hence all the database tables are mapped to Records, which have relationships too that vary from 3-4 per record to 10-11 on some of the records. All the interfaces are using records to display the data, recently an issue has been occurring while retrieving the data from records has become dead slow, causing time-out errors, or sometimes the interface takes forever to load. I have looked into the performance logs and server logs for any related cause and made certain performance improvement changes too but the issue still persists. The issue occurs intermittently, hence it is hard to figure out the exact cause of the issue. I'm looking out for what could be causing this and the best solution for this problem. Thanks in advance, your help is highly appreciated.