Foundation

Hi, There is an issue i am facing with query databse smart service, Where i am executing a stored procedure which fetches data from multiple tables and insert same data to a table. - It works if i execute the stored proc with same parameters by SSMS(SQL Server Management Studio) - By Query Database Smart Service it sometimes gives me error -  The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. attached screenshot for reference Thanks 

Hi All,  I am working on a use case where i need to first convert CSV to excel then import converted excel with extra column to a staging table.  Reason to use import excel to database intend of directly using csv to database is i need to dynamically add process instance id in staging table. I didn't find any option to achieve same in CSV to Database.  CSV to excel is working fine. I am able to generate XLSX file and passing it to import excel to database. My process is getting completed successfully but i don't see data in staging table.  I tried converting csv to xlsx in my local machine and used locally converted xlsx in process model, it worked but same when i am trying to achieve from CSV to excel smart service generated excel, data is not getting imported. I don't have auto generated column in my XLSX file. Please advice what can be done resolve this issue.  Thanks in advance for your help. 

Hello Community, I have an interface that displays two types of data coming from two methods that delivers the json values. If this is an individual I have built out a CDT that ties into the method "individualResult".  If it's a group, I will have to tie into the "groupResult" method.   The properties are the same, but the methods are different.  I'm wondering if anyone has a recommendation as to how to build this out? Let me know if more information is required. Thank you.

Hi All, In our application folder more than 4000 child folder reside inside the folder. First of all, I want to extract all the folder and show in the grid and then I want to seach them by folder creation Date. Kindly guide me on how to do this. Regards, Vikram Kumar Singh

Hi  all,  may I know, how to extract data from an xml file Thank You

Hi There, I’m trying to use card as buttons pattern to call an interface. Interface is having gridfield used inside a!headerContentLayout() to display task lists. However, I’m not sure how can I call call this interface using card as buttons pattern. Is that a right way of calling ? Please do let me know if you need any more details.

Hi All,           I have a requirement that to display the month name & Year  from two particular dates .Is there any direct function or please give any valuable suggestions on the same. Ex:11/2021 --10/2022  It should display Nov2021,Dec 2021.....Oct 2022 Thanks & Regards Saidivya Minna.

Hi everyone, I just created one interface which queries data from a record type, to build a dashboard.  I want to call that interface into a bigger interface, in which if I click the card field, the dashboard will show up. This existing interface is using a!cardLayOut for displaying other field, and I couldn't find any solution to call the new interface into it, as the a!cardLayOut link parameter only accepts  a!documentDownloadLink(), a!dynamicLink(), a!newsEntryLink(), a!processTaskLink(), a!recordLink(), a!reportLink(), a!safeLink(), a!startProcessLink(), a!submitLink(), a!userRecordLink(), or a!authorizationLink(). Is there any way I can work around with it?

Example:  Rule input has no. of items 24, I want to retrieve in batches of 10. i.e at 1st I need to get top 10, 2nd time next 10 items and 3rd time should get 4 items

Hi everyone,  I'm quite new to process model things, so there were something that I have heard of but didn't understand.  1. What is process model engine? Is there any documents about it? 2. How to set the sub process to be executed on the same engine with its parent process? And is there any benefit on that?  Really appreciate your helps!

Hi team I'm needing some help to force an answer in a dropdown field where a given answer is selected in another dropdown field.  Here is a screenshot of the editable grid. I want to force "not used" in the "how important" column when "never" is selected  in the "how often" column The software names are returned from an existing table. This is how the answer table is set up: Answer Table id Name questionID 1 Daily 1 2 Weekly 1 3 Monthly 1 4 Quarterly 1 5 Annually 1 6 Never 1 7 Vital 2 8 Important 2 9 Useful 2 10 Not Useful 2 11 Not Used 2 The questionId corresponds to the two column headings. Here's the expression for teh editable grid: { /* For the Software Title Column*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.softwareID.name, color: "ACCENT", size: "MEDIUM", style: "STRONG" ) ), /* For the Frequency Of Use and Vitality Columns*/ a!forEach( item

I am creating a new record with id, as soon as I click to create I want to redirect to that particular record summary page but it's going our site home page, Can anyone help on this Thanks in Advance

Hi All, I am getting an error while adding a new page (which consist  a rule input  ) in the site . Previously I was able to add the pages with rule inputs but from today its showing error. Please help me to rectify this error.

Good Afternoon! I'm trying to deploy downloaded package in Appian environment using internal API of Appian. https://docs.appian.com/suite/help/22.3/Deploy_Package_API.html 1) Could you please advise how to use it more correctly. For example I need to describe name of the package - how I can set path for local downloaded package with the next deployment? 2) Can I use API body without sending DB scripts? Could you please provide examples for understanding? Thank you! Best Regards, Aleksandr

Hi, I am experiencing the problem with task "Write Maintenance Record" from the learning exercise. The problem goes on saying that it is impossible to write to the source due to system error. Error Details: Field 'MaintenanceScheduled' doesn't have a default value. Any ideas how to fix this?  Thank you.

Hi, when I try to configure a script task in a process modeler I cannot put anything in the Target field in the Data Output tab. It simply does not allow to open it. Moreover, everything that I save to the Data Input tab in the field Value is cleared afterwards, so when I get back to this tab, the field Value is blank again. How can I solve those issues?  Thank you.

Hi all, I'm creating a record hours system app, I made the interface that lets the user insert his start time, and leaving time then, the system should calculate the duration between start time and leaving time. the problem is when I finished the code, I got a problem which is A null parameter has been passed. then I've tried to solve this issue by adding this before the first if sentence:  if( a!isnullOrEmpty(ri!ES_Working_Hours_Record), null, hour(ri!ES_Working_Hours_Record)) but I have a casting problem now, I got this: Interface Definition: Expression evaluation error at function 'hour' [line 36]: Could not cast from ES_Working_Hours_Record to Time. Details: CastInvalidCould not cast from ES_Working_Hours_Record to Time. Details: CastInvalid this is the code:  a!formLayout( label: "Working Hours Record", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!dateTimeField( label: "Start Time", labelPosition: &qu

Hi All, I'm getting an error while trying to view a  pdf document using view document interface . It states that "Document Not Available" so can anyone help me how to solve this issue ? see attachment/resized-image/__size/320x240/__key/communityserver-discussions-components-files/14/Screenshot-_2800_546_2900_.png

Hi, As the "Save Draft" is a completely internal Appian function, is there any way to retrieve those data with an Appian function or plugin?

How to suppress rows in record view grid based on some condition, and expand the hidden rows after button is clicked.

Hi all! While working on Exercise 10 (Process Modeling 101, Part 1) I encountered an error in an expression in process model properties at process start form. It says "Neither variable(s) nor rule(s) found: recordtype". Therefore, I cannot publish the interface. At this stage the Process Start Form contains "AX_AddVehicle" as an interface with 'vehicle' as Rule input, 'AX Vehicle (Record Type) as type and 'vehicle' as value. In Variables section the vehicle with AX Vehicle (Record Type) is also named. So I followed the instructures as the step-by-step exercise prescribes. What could be the problem? The recordtype definitely exists. The previous work has been done without mistakes. Thank you. 

Hi, A process model had to be deployed from Preprod to Prod, but because of a Deployer error, the Deployer failed. To unblock the situation, the process in Prod has been deleted first in Prod before to be re-deployed with success.  The Process Model works fine in Prod, but what about the active instances ? Question : Once such a process is re-deployed is it a problem for all the active instances still waiting? Because this Process model is a "long life" process, can this one be deleted safetely (and then replaced by the new version)?

Does anyone know if there is a way for the value to be multiple possible values? So for example when I select the option label truck it will look in the data for IDs that are 3 or 4 and not just 3? Thanks

I'm attempting to populate a record section from the click of a grid.  Not sure how to populate the record...also wanted to ensure I'm building out the grid properly. Thank you. a!localVariables( local!selection, local!selectedRows, { a!sectionLayout( label: "Results", labelSize: "SMALL", contents: { a!gridField( label: "", data:{ a!map(id: 11, Name: "Elizabeth Ward", dept: "Engineering", role: "Senior Engineer", team: "Front-End Components", pto: 15, startDate: today()-500), a!map(id: 22, Name: "Michael Johnson", dept: "Finance", role: "Payroll Manager", team: "Accounts Payable", pto: 2, startDate: today()-100), a!map(id: 33, Name: "John Smith", dept: "Engineering", role: "Quality Engineer", team: "User Acceptance Testing", pto: 5, startDate: today()-1000), }, columns: { a!gridColumn(

Hi All, How to know if anyone/who deleted the documents from folder in appian ?Will it be recorded in any logs?if yes then How can I check. Thanks in Advance