-
Recently active
hi all,,, i have an editable grid interface in which when i choose a dropdown value for "subsidiary" field, the other 2 fields(businessunit and objectamount) will get autopopulated values..i need to add multiple rows also,,but when clicking on add row button,,iam getting error message like this: Expression evaluation error [evaluation ID = a5ba0:92723] in rule 'i2cemea_editablegridbookingfssc' (called by rule 'i2cemea_genericwriteoffform') : An error occurred while executing a save: Expression evaluation error at function 'append' [line 123]: Insert is not supported for I2CEMEA FSSC Booking Info types CODE: a!localVariables( local!Subsidiary: if( a!isNullOrEmpty(ri!companyCode), 'recordType!{837731a9-893a-4a24-aa84-dedd7697c0b8}I2CEMEA MW GL Account'(), rule!I2CEMEA_QR_getMWGLAccount(companyCode: ri!companyCode,processType: ri!processType).data ), local!bussinessUnitorObjectAccount: if( a!isNullOrEmpty( ri!bookingFSSC['recordType!{0
HI team, i want to find the type of extension and Size of list of documents and i have used document function and build an expression rule it is working fine in expression rule as expected when i call that expression in an interfcae it is shoowing error as document function is deleted. a!localVariables( local!size: a!forEach(ri!documents, document(fv!item, "size")), local!extension: a!forEach( ri!documents, document(fv!item, "extension") ), toboolean( and(and(reject( fn!isnull, { a!forEach( local!extension, if(fv!item "pdf", false, null) ) } )), and(reject( fn!isnull, { a!forEach( local!size, if(fv!item > 5000000, false, null) ) } ) ))) ) when i use in interface getting error as shown below
Objective is to display the firstName of all active users. a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', fields: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{firstName}firstName', filters: a!queryFilter( field: 'recordType!{SYSTEM_RECORD_TYPE_USER}User.fields.{active}active', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)).data ref {user() Function - Appian 23.2} throwing below error Expression evaluation error at function a!queryRecordType: The record type [identifier=SYSTEM_RECORD_TYPE_USER] cannot be queried because it is a service-backed record type.
Hi All, I am using a date time component inside the interface. But it also accepting the special characters if we enter manually. After submitting, it is displaying the system date. Eg: I gave 12/06/2024* 5:00 PM. After submitting it is displaying system date and time. Is there any way to restrict the user entering the special characters inside a date time component or show any validation message based on some condition. It would be very helpful if I could able to achieve Thanks
Hi all, I have seen that the decodeJWT function of JWT Tools plug-in returns the decoded token but only if the signature is valid, otherwise it returns null. This function needs jwks url to retrieve the proper public key and validate the given token. Does anyone know if there is a way to decode a JWT without validating the signature? It is possible to decode a JWT with a private key stored in scs? Is there any other plug-in to create and validate JWTs? Thanks in advance.
Hi, I'm calling MsGraph API from Appian in a two steps methop, I have to send the content-length from the previous integration as a header information in another call. How can I capture or insert into a variable an http request from an integration? Or are some way to calculate the content-lenght? Regards
Hi folks, can we configure another URL masking for a particular site in an environment?current URL: www.abc.appiancloud.com/suite/sites/mysite another URL: www.abc.com/mysite.
Hello, Can anyone help me in this: How to hide these categories text(Qt1, Qt2, Qt3, Qt4) from column chart? Also, numbers/range(0-100) from y axis column? Note: For this column chart configuration, I am using records. Thanks
Hi All, I recently came across this issue while using the write records smart service to update a single specific column(eg: textCol} for an existing record. I'm using the recordType constructor to specify the primary key value and using a pv value for the other column. So my input to the write records looks something like this: {recIdPk = 1, textCol: "newvalue"} Instead of updating the column (textCol) with the given value for the existing row I get the below error (screen-shot attached). So from my understanding this error should not be coming becoming as this not null column already has a value both in the db table and the record object and I'm not looking to update that field hence not specfying it in my above recordType constructor. I have a total of 15 columns in my table of which two columns have a not null constraint and are already populated from a separate location (using write records itself). I'm only looking to update one specifi
We have a requirement to call web API which uses Bearer Token authentication type and it requires client id and secret in the Header. Before calling this API we need to get the access token using oAuth endpoint, this endpoint has authentication type as Basic Auth and it requires same client id and secret in the Header. 1. For OAuth endpoint, we have created a connected system (A) with the Basic Authentication using username and password. - Works fine. 2. For the primary API, we have created another connected system (B) with the following information. a. Base URL: <Base URL>. b. Authentication: None 3. Created an Integration object which uses connected system B and has following parameters in the Headers. a. Authorization: <Token received in step #1, passed as rule input> b. X-IBM-Client-Id: <client id, passed as constant > c. X-IBM-Client-Secret: <client secret, passed as constant> The above setup works fine however as per our secur
Pls answer the below question 1.What is the difference between Entity Backed records and Process Backed records?
The page I am testing has a line chart with a download icon on it with the tooltip Download PNG Image, but I am unsure how to have my FitNesse script perform the download. I see support for downloading charts was added to FitNesse for Appian November 2023 - Release 23.4, but I don't see in the Cheat Sheet or documentation how to download charts.
Hi everyone After reading this sentence, I wanted to know more, so I would like to ask a question. [mention:a776b956d9da49b1bbfb78dfc99430ac:46448885d0e64133bbfbf0cd7b0fd6f7] How can i map a view with record type. As a result of investigation, I was unable to map View to RecordType. Thanks
Hello devs, I need your help. I have two records: 'account' and 'transaction', and the 'balance' field of 'account' varies based on the value of the 'Amount' field of 'Transaction'. I've added conditions to update the 'Balance' (in the saveInto function) when the user clicks 'Create transaction' and it works well in the interface the field in my ruleInput record has been updated, but the update isn't happening at the database level. How can I dynamically change the balance on my site based on the value of the 'Amount' field of the transaction record?
Configure node as mentioned in HERE for Execute Stored Procedure Smart Service but getting following error. I have created SP in SQL server and tested successfuly but couldn't call from processmodel. Error: No procedure found with name procUpdateDWAZipCodeParameter. TIA !
Scenario: The user started the process and before process completes user left the bank .The sub process got errored because assignment of nodes is 'run as whoever started the process'. In this scenario , do we need to change assignment of that node to 'run as designer of the process'. in the production and restart the instance , or any other Approach?
1.What Does Nullable = True or False means in XSD ? 2. i have installed an Appian from PlayStore in Mobile . What is the server address to community .
Hi Everyone, We have one functionality as we are validating the data in excel and load the data into db. I uploaded file with 1500 rows and 129 columns each row will have, I am getting below error when i try to upload 1500. The System Has encountered an error, An error occured while processing your request. but when i found in server log below is the one,Can anyone of you please mention what is the below error stating? which size it is mentioning as 200,000,00? APNX-1-4532-000,"Expression evaluation error: Max compression size exceeded. Max size=200,000,000, actual size=257,715,470",,0000e69f-7bc4-8000-9844-3d4d983d4d98,,,,SITES Thanks in Advance!!
I want to have a readonly paragraph field with a scroll bar, so when text is long it can be scrolled within a box rather than displayed all in the page. How can I do?
I have a process model using the Export data store entity to Excel smart service that works; however, the Boolean values in one of the columns are being displayed as 1s and 0s rather than true or false. How do I configure the Export data store entity to Excel smart service to display "true" or "false" using toBoolean or cast function?
I want to know what is the most effective strategy to handle old production processes that were designed with a methodology that involves extensive and long-lasting processes. In addition, we face numerous PRO issues that require quick solutions from the support team. Simultaneously, improvements are being made to extend or enhance the functionality of these processes. However, problems arise when we have to solve an issue that involves the modification of objects that are also being altered in the enhancements and are not yet stable. Another challenge is managing active instances with old versions of the flow; when trying to implement a new version of the process, conflicts can arise due to incompatibility between the old version of the instance and the new version of the process. Appian suggests a method in their documentation, but I find it has several limitations. I am interested to know how they handle these situations in other projects to learn from the best practices applied. do
What is the main difference between end node and terminate node from process/architect perspective like archive, data management/ engine? PS: we all know the implementation that if terminate node execute then it will close any in progress node in a process unlike end node.
I have 3 different Records and respective tables where SYNC is enabled. Now, i want to create a view on top of these 3 tables and export to excel or use it any other workflow. I am not planning to query view using queryentity or queryrecord etc but i use SQL Statement to get required data and populate on excel in PM. If not view, I am left with stored procedure which is the least option in the list. Question: Can i create view on top of synced records/tables in first place? All the resources says that i cant (if i query on it using queryentity or queryrecord) or in general etc.. If not what is the work around?
hi, My team wanted to build a common library/application i.e. Global_CaseManagement where the application will be exported to 2 instances for 2 regions to share (similar to a common library), i.e. UK_Bank and US_Bank.Let's name the rule as rule!Global_GetNextCase which used within a node by a common global process model namely ACTION - Get Next Case Given the rule Global_GetNextCase will have different logic for UK and US, what would be the recommended way to do the common rule override?The dependency graph as below :1. Global (application) -> ACTION - Get Next Case -> rule!Global_GetNextCase -> rule!Global_GetNextCase_UK2. Global (application) -> ACTION - Get Next Case -> rule!Global_GetNextCase -> rule!Global_GetNextCase_USThis way will create a problem where both UK and US rules will be imported into the instances respectively causing unwanted dependency issue, cause UK only needs&
hello , j'ai besoin d'aide s'il vous plait .Je voudrais traiter cette partie : lorsque l'utilisateur dépose des documents, au moment de la visualisation, les documents PDF doivent être compilés dans un seul visualiseur de PDF. J'ai utilisé la fusion de PDF dans le modèle de processus avec ce code dans l'interface qui s'appel : projet_docsInterface( fv!item) a!cardLayout( contents: a!documentViewerField( label: ri!record['recordType!**.{c36418cc-1402-4f64-801f-7a433c3ed250}type'], labelPosition: "ABOVE", document: ri!record['****0902-47a3-8490-7833fee28c37}docid'], height: "TALL" ), ) et j'ai fait l'appel de cette interface ici : a!cardLayout( contents: { a!forEach( items: local!docs, expression: { rule!Projet_docsInterface( fv!item) } ) }, height: "AUTO", style: "#cccccc", shape: "ROUNDED", padding: "STANDARD", marginAbove: "LESS", marginBelow: "S
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.