Foundation

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

Hi, I have link as below . To make it more noticeable to the user I would like to add a border to it and make it look like a button. I tried to use cardlayout but it is displaying like in 2nd image. Can someone help me how to display border just order the richtext link, not the entire row. a!cardLayout( contents: a!richTextDisplayField( value: a!richTextItem( text: "Add Meeting Minutes", link: { a!startProcessLink( processModel: cons!RGRACSLBL_PROCESS_LEAD_LAST_APPROVAL, processParameters: { requestId: ri!requestId, labelChangeCountryId: ri!labelChangeCountryId_int, fromHQ: if( local!requestDetails.workflowType_txt = cons!RGRACSLBL_LabelUpdate_WorkflowType[1], true(), false() ), labelChangeRequest: cast( typeof(

HII  i am getting this error - Expression evaluation error [evaluation ID = NYEY6] in rule 'gai_displaybatchrecordsummary' at function a!gridField [line 59]: Cannot update Map using null index (APNX-1-4522-005) How can i resolve this  i have added my code a!gridField( showWhen: a!isNotNullOrEmpty( ri!record['recordType!{43099841-b468-444e-97af-bc369b79a6fc}GAI Batch.fields.{c835857e-c9ec-40d4-a818-f2d8593b1100}batchNumber'] ), label: "Batch Details Grid", labelPosition: "COLLAPSED", data: a!recordData( recordType: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{975fa1c0-6a6a-494c-bdf3-1b0d87ea07e0}GAI Batch Detail.relationships.{3cd6a92f-954f-48e2-

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

Hello, I have stored different values of a grid in my local variable local!DatosLineas (read-only fields which result on querying another record  + extra column which must be completed by the user).  I want to "write" some of the fields of my local variable in another record fields. For example, the id_pedido of my local variable (which has been created by querying another record, "CPF_Lineas_Pedido") would be the id_Pedido in my other record ("CPF_Lineas_Recepciones") In this case, I don´t know how to match the fields and write my new record with the data of my local variable. I have to point that the INFO SHOWN IN THE VALUE OF EACH FIELD CORRESPONDS TO THE PREVIOUS RECORD (CPF_Lineas_Pedido), but I want to save the values in a NEW RECORD (CPF_Lineas_Recepciones) My code is below: a!localVariables( /*mirar para incluir columna extra en variable local*/ local!DatosLineas: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-42

I'm trying what should be a very simple task ... and I can't get it working!  I've created a Related Action to update a record - just used the automatic creation tool that built me an interface and a process.  In my user interface, if I include the related actions dropdown on the record view, this update works perfectly. The interface shows all the fields and allows me to update and hit Save. Perfect. But now instead of using that interface from the related action dropdown, i'd like to place it in a view so that it shows as a toolbar menu item across the top toolbar. But now, when I hit Save on that interface, nothing happens. It's like it's not calling the process at all.  Here's my related action and my view - what am I missing?

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!

Hi is there any way to input this type of sticky pad into appian interface and the save the written values to the database without the use of process model.

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 have the following error, I am trying to display a card info on vehicles. Expression rule works properly. Please help me on how to understand this error. Thank you.

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 querying data and getting all the desired data  from DB. And Ids are one of them.Now I need to move these data from expression rule to process model after doing required changes in the rule. These Ids are like {123456, 345789, 567890, 120078}. I stored them in map like map(id: {123456, 345789, 567890,120078}). But when I am trying to extract these Ids from the map using indexing  and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}.  Kindly help me to get my Ids as they are without these unnecessary commas

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

I made some changes in my interface through the Edit List function but when I save changes and update the interface, this changes do not apply to the read-only grid. I tried to eliminate this read-only grid and add it again and this way the changes were applied.  Example of the changes and the interface are the following: The changes to apply in the interface are the following: And the interface remains unchanged (notice the "€" sign is not applied): Does anyone know any other (less sophisticated and destructive) way to update the read-only grid and directly apply new changes? Thanks! 

Hi, We are planning to implement a requirement where we need to scan a product page that contains 3 barcodes. And read data from those 3 barcodes. The current barcode field, scans one barcode at a time. To achieve same , we can keep 3 barcode components in UI but this is not our expectation from UI point of view. Is there any way we can read details from all 3 barcodes at once (without user taking photo/scanning it 3 times individually) ? Thanks,

Hi Champs, I have a site where one of the page names is little, bigger. So, on the site the name is showing truncated. Can I increase the width of the same so that it will show the full name of the text. Regards, Ghanashyam

Hi  is there any way to download document file directly from Process Model by just  initiating the process without any link