Foundation

Hi All I am working on version 22.3. My requirement is to get data from DB and provide it to user in excel format. This I have achieved using OOTB node "Export Data Store Entity to Excel". The excel sheet obtained looks something like below: However, I want to transpose the excel data as below: Can anyone please suggest how is the above achievable. Thanks in advance!!

Hi, I have a very basic process model where I'm setting a new value for a users first name and last name, then setting a new value for the username and finally deactivating the user. The process has been working as expected for approx. 1 month but is now showing this error on the Rename Users Smart Service: The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete. It also sporadically shows the following error, again on the same Rename Users Smart Service node: An error occurred in executing an Activity Class. Error in the tomcat.stdOut log: 2022-03-23 09:46:44,983 [ajp-nio-0.0.0.0-8009-exec-836] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536877698, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.initiateProcess.userMsg=Failed to st

Can anyone provide me road-map to study for L2 Certification?

I am trying to create an excel sheet with the data present in my PV variable, this data is not directly from the SQL database as i have to modify it before writing it to the excel. Can you please tell me which smart service i can use. Export Data Store Entity to Excel/CSV isn't giving me the desired result as the requirement is to use the data in PV variable not from the DB. Please help me here. Thanks, Preji

Do Appian has provided a course for Appian L2 Certification? I am unable to find it.

how to import old data for task report? We are migrating old data to db and  we have some process/task report which is not updating tha db data to UI grids.

How to ensure a process have a well-defined life cycle? (select multiple from bellow options) a. configure process data management settings b. use a terminate end node to complete workflow c. configure all processes as sub-process that are quick task d. configure exceptions on every node in process. 

how can we import the process instance from one env to another??

i want to select 5 dates in One Date Calender field. is there any Method or field are there ?

Hi, There is a CDT which is calling a Sequence in Oracle as a primary key. Below is the extract from CDT. <xsd:element name="recordId" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="RECORD_ID") @Id @GeneratedValue @SequenceGenerator(name="sequence", sequenceName="A_RECORD_ID", allocationSize=1)</xsd:appinfo> </xsd:annotation> </xsd:element> For some reason, when we are trying to insert data in the table some other sequence is being called and we are getting "Unique key Violation". We are able to identify that sequence but not able to figure how this is happening. We could not find any trigger in the table. Any pointers would be highly appreciated.

Hello world, I am currently representing Infosistema, a portuguese IT company and we are on a hunt for Appian Developers! We need someone with :  1 + years of experience in Appian Spanish/Portuguese and English language skills We offer both remote or relocation options. If you are interested or know anyone who might be, please contact me either through here or through my linkedin. Thank you very much.

I am planning to give a certification exam and have to use my company account, but I'm leaving the company in a few days. Would it be possible to move my certification later, to the account with my personal email?

Hi , I am not able to login to community site from 4 days getting error message as below. Appreciate your help! Regards Nishtha Bhatnagar

I have the following:a!localVariables( local!countries: rule!PT_GetAvailableCountries(), local!selectedCountry: rule!PT_GetAvailableCountries()[1], local!states: rule!PT_GetStateByCountry(local!selectedCountry), a!formLayout( label: "Create Customer", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "First Name", labelPosition: "ABOVE", value: ri!record['recordType!{cf9a6a37-c43d-422f-b4f7-bef6f0e8d9a3}PT Customer.fields.{421eacda-bfa9-4e18-8a6f-4428e01b5e23}firstName'], saveInto: ri!record['recordType!{cf9a6a37-c43d-422f-b4f7-bef6f0e8d9a3}PT Customer.fields.{421eacda-bfa9-4e18-8a6f-4428e01b5e23}firstName'], characterLimit: 30, required: false ), a!textField( label: "Last Name", labelPosition: "ABOVE", value: ri!r

 hi all, We have a view for bar cart field which recently bracked in prod due heavy volume of data approx (1,048,576) records in my sql db .  so we plan to query data going with sp with (executestoredprocedure) function. my question is can we query data in a barcart field with SP ? while executing SP  with mandatory  parameters getting error as "Use the Execute Stored Procedure Smart Service to modify data. This function must only be used to query data, not modify." if i pass optional parameters also getting error as "The conversion from UNKNOWN to UNKNOWN is unsupported". Below is the code for SP,  a!localVariables( local!sp: fn!executestoredprocedure( cons!DATA_SCOURCE_NAME, cons!TASK_GRAPHIC_SUMMARY, { { name:"assignedTo", value:ri!currentUserEmail }, { name:"categoryName", value:ri!categoryName }, { name:"lob", value:ri!lob }, { name:"assignedcategory", value:ri!assignedcategory },

Hi All,I am facing below issue while trying to passed formatted json (a!fromJson()) data as parameter and again converting same json date using a!toJson() format at that time of passing the parameter. Please find the below code sample and share me if any solution. step1- Finding enter json data local!jsonData: if(a!isNullOrEmpty(ri!jsonData), {}, a!fromJson(ri!jsonData) ), step2 -  Binging with local variable  local!exceptionResults:property(local!jsonData, "ScreeningSummary", null), step3-  Passing the local variable with using a!toJson to child interface (rule!PM_ScreeningExceptionSummary) rule!PM_ScreeningExceptionSummary(a!toJson(local!exceptionResults)), Step 4- Binding Json preparties within the Appain ready only grida!localVariables( local!exceptionResultsFound: if( a!isNullOrEmpty(ri!exceptionResults), {}, a!fromJson(ri!exceptionResults) ), { a!sectionLayout( label: "Exceptions", labelSize: "SMALL", contents:

Hi, I have an interface with a read-only grid. I am loading the data into read-only grid using RECORD TYPE and also I have used selectable, selectionValue, selectionSaveInto properties. I would like to implement delete functionality, where I need to allow multiple rows to be selected and click on "DELETE" button so that those selected rows of data should be deleted from the database table.

My Appian Timezone is set to Pacific time Below functions are returning correct time now()  -   2/20/2023 5:40 AM PST datetime(year(now()),month(now()),day(now()),hour(now()),minute(now()))   -  2/20/2023 5:40 AM PST However, when I try to create datetime where I want to change the date and time acc to my preference, the timezone offset gets added.  datetime(year(now()),month(now()),day(now()),0,0) – 2/19/2023 4:00 PM PST   I want the output as - 2/20/2023 12:00 AM PST       Requirement for which I want to create datetime in specific timezone. Now I want to create a datetime so that I can use it to filter the datetime column stored in DB I need to fetch all rows from DB where the createdDate is say 2/20/2023 so for that I thought of creating a query filter as Date between (2/20/2023 12:0AM PST and 2/20/2023 11:59 PM PST). However I am unable to create datetime in particular time zone  

Hi all. I'd like to know if Appian can be integrated with a versioning software like CVS. The goal is to store each Appian component version with the ability of identify who modified a component, what changes are made and recover old version. Thanks in advance.

I am trying to Execute a SP from Query database Smart Service in Process model and getting a Timeout Error.I wish to Handle the Process flow and not let the Process stop immediately and continue the Exception path. Note : i cannot use Execute Store Procedure Smart Service as my SP is taking longer than 10 min.

Dear community, within our project we have the requirement of full traceability from a work-item in azure devops to the actual code changes. Are there best practices to do that within the Appian environment or possibilies which would allow us for example to force the user to enter a description before he can save an object, automatically export the objects from Appian via a Rest-Api and then commit them in git ?  Thanks, Patrick

Hello, I am trying to randomly sample x amount of rows from a CDT by generating x random numbers in the range 1:length(myCdt). The issue I am getting is that some of these random numbers are repeated.  Is there a way to generate random numbers  in a given interval and have them be unique?  Here is what I have so far: local!randomNumbers:if( length(local!query)>15, 1+ tointeger(rand(15) * length(local!query)), local!query, ),

Hi Champs, I have a requirement where I have to show the record related action in a link format along with the helptooltip/description (whichever is fine). I am using a!recordActionField to achive the same as I have to open the interface in a pop-up. but in the same component there is no helptooltip available. What is the alternative approach for the same. I need something like this I can see in Appian related action it shows in this format. Not sure how they have  done this.

Hi Team, just got this Requirement So when i click the Collaspe all button The box layout which is below should get Collapsed. Any one can help me with this I made like after clicking this button a local variable is changed to true and after that i wrote that in iscollapsible condition but not working

created web api with below code but getting below error local!entities: a!queryEntity( entity: cons!TI_FINALEXCELTODATABASESTORE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: true ).data, An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TIFinalExcelToDatabaseDT7969], query: [queryentity expression], order by: [[Sort[null asc]]], filters:[null])