General

Hi Team, When  try to open and application in the designer , It is taking too long time and showing 503 error, Not sure, I been working on that from yesterday but today when i try to open the application it is not opening, I cancelled all the running instances as well in that app process models which contains , Need to connect appian on this ? Thanks, Udayasai

Hello, I was wondering if there was a function which takes as input a string and returns the same string stripped of any accents (ex: été -> ete). If not, what would be the most efficient way of achieving this result within an expression rule? Thank you

I have a scenario where there is a web api returning a basic textual response, and this web API has to be triggered when the user clicks on submit button.This is something that we do with Integrations, similarly I have to call a webAPI on the click of a button.

Hi all, how can input the documents destination in the move document smart service process node without hard cording the folder name, depending on todays date the document will be sent to a specfic folder. for examle I have a parent folder called Documents. inside I will 4 subfolders, Period 1, Period 2 , Period 3, Period 4. but these will be created throughout, so for now I only have Period 1.  If today is a date is january 2 t will go to period 1. but when we reach the date of march 1 it will create the second folder period 2, and then any documents after this date I want them to go to period 2 folder and so on.  What is the best way to approach this? thanks in advance

Hello All, I have passed some invalid userid to the function isusernametaken and it returns true.

Can we convert SAIL code  to HTML?

In the context of an on-premise server, we have the capability to manage log files by archiving, compressing, and uploading them to S3 for efficient on-premise server disk storage management. However, when our application runs on Appian Cloud, we are aware that we can access the log files via the /logs URL, as shown in the attached screenshot. While it's possible to manually download these files one by one, compress them, and then upload them to S3, we are trying to find the best and most efficient approach to streamline this process. Any insights on the quickest and most intelligent way to handle this step would be greatly appreciated please.

so i  have a requirement. here can see for the collateral type and description need to generate two separate documents. but here i have to check for the customer collateral type is their or not if type(451) is present then generate 4 docs in 2 colms.  we need to show the it gird how is in the requirement  can someone plz let me know how to proceed. i have checked for the customer the type is present or not then next steps am not getting

Can someone help with example. How to do batching in Query. I have clear understanding of how it works but need clarity while implementing.  Eg: create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},local!pagingInfo(startIndex: 1, batchSize: 100)))after this what i need to do? I need to fetch 7000 records

The expression rule below should return a list of dictionary containing loanAmount and monthlyPrincipal. It gives me a strange Expression evaluation error : with no specific errors. If I change ri!loanAmount <= 0, to be ri!loanAmount <= 28824, it works for some reason. Not sure why and not sure what's going on. This rule has a rule input called ri!loanAmount of type number(decimal) which I am testing with 100000 as a test scenario to make this work.  Any ideas what's going on? If there are any other ways to get this to work without doing recursion, please let me know. a!localVariables( local!principalPayment: 100000, local!interest: 15, local!loanTermYears: 30, local!periodicInterestRate: (local!interest/100)/12, local!periodicInterestRateModified: 1+local!periodicInterestRate, local!periodicInterestRateModifiedToPower: power(local!periodicInterestRateModified, local!loanTermYears*12), local!xx: local!periodicInterestRateModifiedT

I have a requirement where based on condition I need to fetch the table name so am storing it in Data Store Entity Type. Am able to fetch the value, but I need to convert this to table name. Can some one help how to convert it. Do help with code or if we have any function Eg: Am getting value in Process Model in Pv!table: 473c45d0-5c99-4665-a335-f772838ccb37@2232 but I need to display exact table name. Note: table is of type Data Store Entity

I have record type that get its source from data store entity and it has default filter and other user filters how can i query the same data using expression rule ? for example we have fields in the data store entity      startedBy , status , location , department  , empId , addedOn and the rule inputs for the expression rule are searchText , selectedLocation and createdOn this is the default filter  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field:"status", operator: "=", value: 2, applywhen: a!isUserMemberOfGroup(loggedInUser(), cons!SP_MANAGER_GROUP) ), a!queryFilter( field: "startedBy", operator: "=", value: loggedInUser() ) } ) and this is the user filters that i want to use (this for user search )  logicalExpressions:  a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "empId", operator: "=", value:tointeger(ri!s

"An error occurred while retrieving the data. Details: The data source [jdbc/Appian] cannot be reached or its configuration is invalid. Details: could not extract ResultSet" I keep encountering this error while trying to add some filters to the data retrieved from a query entity. The query runs fine and retrieves all the data, however, when I go to add some dynamic filters to this data I keep encountering this error. I am reaching out to see if anyone from the community has come across the same error and what solution worked for them. Basically trying to add a few specific data filters to a search bar in the application. Any suggestions are welcome. Thank you

Hi, Does anyone know how to convert a document stored in appian to an url? to use it as a dynamic link in a json. Thanks!

Is it possible to build a process report that shows me all processes (and id's) that are showing as error ? i can use the existing report that lives under Perf Monitor to view how many instances have errors - but I want to build a house keeping task that will go back and cancel these cases and for that I need to get the process id's for a named procedure. (date filtered) Alternatively how much impact is there when deleting process instances in bulk. 

Hello everyone I have a requirement to remove the decimal point in the value. For example 15.50 into 1550. Is it possible? 

Hello. I built some process flow logic that's checks if a value isn't null and then performs an action. The value is for a property of a CDT processVariable: Ex: if(  a!isNotNullOrEmpty(pv!requestItem.field),  do something, do nothing) I came across an issue where the flow was performing the action when the value is null (value is verified) I'm debugging in an expression rule and can replicate the issue when the query returns a Dictionary list, and I get the intended behavior when using data[1]. The issue makes sense here since the null checks were originally against the list. However, the process variable isn't a list, its a single entity ("Multiple? is No and verified). So I'm not sure why the behavior is happening. Has anyone experienced this and found a solution?

Anyone know how can I change from this format: "mm/dd/yyyy h:m PM" to this format: "dd/mm/yyyy h:m PM". I only want to switch the order for the day and month.  I have tried the following expression, however this way it doesn´t show PM/AM. a!gridColumn( label: "Fecha Recepción", sortField: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion', value: if( isnull( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'] ), fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], datetext( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], "dd/mm/yyyy hh:mm" ) ), align:

Hi, is there an easy way to know how many times and where a component (for example a!hierarchyBrowserFieldTree) was used in an Application? Many Thanks

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

I am getting this error while debugging PM How to resolve this ? 2019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/2023

I am getting error like Premature End of file while generating Pdf how can i resolve this ? a!localVariables( local!voucherDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getVoucherDetails(batchNum: ri!batchNum).data ), local!batchDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getBatchDetail(batchNumber: ri!batchNum).data ), local!date: today(), local!xmlData: if( a!isNullOrEmpty(ri!batchNum), null, concat( "", "", ri!batchNum, "", "", local!date, "", "", index(local!voucherDetails, "description", {}), "", "", index(local!voucherDetails, "claimname", {}), "", "", index(local!voucherDetails, "fundsource", {}), "", "", index(local!voucherDetails, "fundamt", {}), "", "", index(local!voucherDetails, "invoicedate", {}), "", "", index( local!voucherDetails, "invoicen

Hi Team, When using import CSV to Database smart service, is there a way to update the data after uploading the document Eg: In my excel file, I have 3 columns id, name, updatedon id and name values will be availble in the csv file, after uploading the file and when writing to DB we need to update the updatedon value with the updatedon time.

Hi, When I'm trying to upload a document by using startprocess , I'm not able to get the name using document() function. It's showing error as document doesn't exist/ has been deleted. But the document is present in target folder and docid is present..Let me know if am missing anything: