Discussion Categories

Hi Everyone, Requirement: We need to segregate the process model based on the app name in the process task reports. We are creating the process reports based on all task, we need to fetch the app name based on the Process model ID.Any suggestions would be appreciated, Thanks in advance. 

I have defined a process calendar called "US calendar". I defined working hours for 14.2.2024 to be from 8am to 4pm. When calling calisworktime(datetime(2024,2,14,15), "US calendar") (checking if 4pm is working time) it returns true. Then i set working hours for 14.2.2024 to be from 8am to 5pm. Then i called calisworktime(datetime(2024,2,14,16), "US calendar") (checking if 5pm is working time) and it returned false. It appears that calisworktime() function does not behave consistently. I have tried searching for this problem but it appears nobody else has experienced it.

We have deployed app to prod environment back in 2020. After a few years it turned out that some features are not needed. We have deleted those objects on our dev environment then on git repo. During deployment to UAT or PROD based on version control system package.zip is created. This package does not contains deleted objects. This package is pushed to higher environment by Appian API - during deployment objects not available in package are not deleted from higher environment but Appian just remove them from deployed application. In other words objects remain in higher environment as not linked to particular application. How to use automated deployment via API and delete objects from higher environment automatically ? docs.appian.com/.../Deployment_Rest_API.html

Hi all - need som help withthe PowerBI Integration. I can: - Generate Report Extract using the PowerBI Connected System, for example for pdf or csv format - Get Report Extract Success returns a Success for both - Download Report from Export returns ok for the pdf but for the csv returns a integration error code: IntegrationError title"Error Code 418"(Text) message"Unsupported file type returned by PowerBI"(Text) detail"{"document-error:":"Unsupported content type returned","returned-content-type:":"text/csv"}" Attached are the integration configs etc. Anyone able to assist on this Thanks Debesh

Hi, We have an expression rule (see below image). We want to get the indices of numbers from the array (local!numberList) that would not make the local!initialValue negative when added together.   The result we are expecting from the sample values in the image is: {1, 2, 3, 5} If we have local!initialValue = 100 & local!numberlist = {5, 100, 15, 100, 25}, the result should be: {1, 3, 5} We're having a hard time thinking of the way we can do this. Would gladly appreciate your help.

I am facing an issue where i am getting expression evaluation error during file upload (line number 688)

Is there a way (or will be) to run a subprocess synchronously, containing a user task , passing pmid as a parameter? We would like to be able to execute a subprocess call in that way, passing the pmid as a parameter to control the flow of the process from, for example a Decision table.

Hi, Unable to sync the data in records below is the error and also screenshot. Unable to sync due to an error in the Record Data Source during batch number 2 Record Type Sync Alerts Record Type SG PersonDetails Source Type Web Service 1 item available Alert Caused By Unable to sync due to an error in the Record Data Source during batch number 2 The Record Data Source did not apply the batch number correctly. The first two responses returned the same data.

I am integrating an employee system with another system that tracks our employee background checks.  The Web API returns several records for an employee. body Dictionary LASTNAME "Smith"(Text) USER_ID 1234567(Number (Integer)) FIRSTNAME "Bob"(Text) BGCDATA List of Dictionary - 3 items Dictionary SERVICENAME "Fingerprinting"(Text) TYPENAME "Background Check Option for School Teachers"(Text) BGCDATE "July, 25 2018 00:00:00"(Text) BGCSTATUS "Complete"(Text) BGCCOMMENTS ""(Text) Dictionary SERVICENAME "MYB"(Text) TYPENAME "EMPLOYEE"(Text) BGCDATE "October, 24 2023 08:00:26"(Text) BGCSTATUS "Complete"(Text) BGCCOMMENTS null(Null) Dictionary SERVICENAME "MYB"(Text) TYPENAME "EMPLOYEE"(Text) BGCDATE "April, 19 2017 09:22:39"(Text) BGCSTATUS "Complete"(Text) BGCCOMMENTS null(Null) Here is the XSD for the CDT that I am storing the data into. @Column(length=255)

Hi [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] , I want to click the id number in which it should take me to the summary view of the particular page.This everything happens in send email smart service.Could you please help me. Thanks, Priyadharshini,S

Hello everyone. I am new in Appian and am trying to build a web app "Canteen" as part of my learning path. Couldn't find anything in other posts as I don't know how to search it. So my issue is the following... I have a Canteen Menu where each user can select products to add in the cart. On the interface I build a list of product variations (with a tempId in order to update something since I haven't saved anything on DB). When I press the "Place Order" button, I want to create a new "Order" with some fields and then get the ID of the created record. Then I will use the orderId and create the related "Product Variations" from the selected products list. How can I do this in the process model?   

Hi Recently i genereate the health check report in that it showing one finding in perticular interface like (InvalidGroupException) for getdistinctusers function but when go to that perticulat interface there is no error it's woriking fine but i don't no why we get this issues, somebody help me why we got this finding in that report

Hello, In user interface we have picker field defined in that if we select one userprofie and later we are calling another subinterface in which we are selecting some products from list and whatever we have selected will be moving to editable grid  For example in below screen 1.when we are selecting user we will have an option to selected products and link to editable grid which means selected products will be added under Linked products this details was defined in an other interface which we are calling to the current interface 2.If i am removing the user profile means the values from the Linked products which is defined in other interface also has to be removed but it was not removing Please find the logic available under user profile   saveInto: { a!save( ri!record['recordType!{63a0b9c7-fe03-4c99-8667-a1d9a63acf3f}DIL Users.fields.{d05ec5c4-2ec2-45df-813f-59993f59acd5}profile'], t

I am trying to check the version of the appian community environment. This is to verify if it is a compatible version to do the exercises that i have in the courses.

Hello, I’m new to Appian building and process. I do have extensive knowledge from a business analyst view and have worked within an actual build and gathered criteria. I’m looking over the optional IT project in the learning path and although I’ve gone through the courses, I am completely lost on where to start. They do have the example AIS build but no step by step guides. Any suggestions on how to approach this? I feel like I didn’t learn anything, which I know is untrue, but the level of “lost” is real! I would love to practice with this build but not sure how to go about it. I learn best by seeing and hands on or watch and do as I go. Thank you in advance. 

I have a record type named Patient and in that there are columns like Name ,Age and Gender. I need to store the value in Gender as M and F. There is another recordtype named reference and there I have 2 columns such as gender code and gender name .There are 2 records ,one is gender code M for gender name Male and second is gender code F for the gender name female .When I am displaying the record list I need to show the gender values as Male and Female instead of M and F by mapping to the recordtype reference . Please tell me how to configure this .

How we will covert ("INDIA") TO {"I","N","D","I","A"}. How we will write in expression rule?

We are using smart service 'export data store entity to excel'. While downloading the excel it has 4036 rows but in table in database it has more than 4036 records. We tried same with different table, limiting number of columns but each time it only generates 4036 rows in excel even if data in table is 4080 or more.  Can anyone suggest is there any limit in number of rows being generated through this smart service, or we can find any alternative method to this issue. 

Hi , I need some calculation logic in appain that gives difference of ration numbers example shown below in the screenshot. Can someone help me to write the logic for this on priority? Here actual and threshold values are user inputs based on those inputs variance col data to be shown .

Hello Team, My Community Edition site appears to be in inactive mode. I've attempted to activate it but haven't been successful. The registered email associated with it is prashant.kumbhar@telusinternational.com. It seems the system has been inactive since February 8th, 2024. Could you please assist me with this? Thank you.

HI,As Length function doesn't consider the null values but Can anyone explain me why the below code has returned value 4 ? Thanks

I have to do an integration with a SOAP service with BinarySecurityToken using an X509 digital certificate, has anyone ever done that? What type of authentication do I have to put in the creation of a connected service?

Hi, I have a record action which shows "Add Artwork Milestones" and after completing/adding the artwork details the record action should get updated to "Edit Artwork Milestones". But it is showing to Edit Artwork Milestones Action only after page refresh but not immediately after the action submission.  I used a local variable to call the record action with a!refreshvariable() but still it is not getting updated dynamically without refreshing the screen. PFA code and help me resolving this issue.a!localVariables( local!recordAction: a!refreshVariable( value: a!recordActionField( actions: { a!recordActionItem( action: 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.actions.{9cb9fc4e-57ad-4aaf-b21b-6dabf15c4a55}addOrUpdateArtworkDetails', identifier: ri!labelChangeCountry['recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a

Hi everyone, Please help me How we can make the start process synchronosly 

Iam trying to add a new row link to the editable grid, The data entered in the new row shoud be saved to Database. anyone give suggestions.