Discussion Categories

How much data we can retrieve from database in expression rule?

Hello guys, i am trying to combine my list of contract numbers with contract line attributes, where a contract line can have multiple lines. So for example my list of contracts (local!contracts) contains attribute like name, id, etc... The contract line items (local!contractlines) contains different attributes of a contract like chargetype,currency,lineId, amount, etc... If there will be only 1 line of contract i can easily achieve the required output using a!forEach like this: local!finaloutput: a!foreach(                            items: local!contracts,                            expression: {                           {                            contractName: fv!item.contractName,,        

when having the nested cdts a foreign key relationship is established what will be default cascade behaviour is? 

Hi Team, This is a on-premise system. When we try to access the All Application View Page (http://<appian-url>/suite/design). All objects page and others are working for us.  Please find the log entry in Application Server Log: 2022-10-17 14:04:31,103 [http-nio-8080-exec-1] ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation.com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = 02c9d:b38a4] : (APNX-1-4198-000) at com.appiancorp.exceptions.LocalizedAppianRuntimeException.<init>(LocalizedAppianRuntimeException.java:16) at com.appiancorp.sail.server.ServerExceptionTransformer.createLocalizedObfuscatedException(ServerExceptionTransformer.java:46) at com.appiancorp.sail.AbstractUiService.localizeException(AbstractUiService.java:113) at com.appiancorp.sail.AbstractUiService.reevaluateUi(AbstractUiService.java:79) at com.appiancorp.sail.AbstractUiServ

Appian version 21.3 When I create new membership rule to add users whose Address 2 starts with [ it return error: HTTP Code: 500 I found below error message in tomcat-stdOut.log ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation. com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = 0D1P8RZE] : [valid:false,syntaxError:false,value:Expression evaluation error: An error occurred while executing a save: com.appian.komodo.api.exceptions.ConnectionClosedException: The connection to the engine was closed] (APNX-1-4198-000)

I have this checkbox when checked sets the priority on the case. Currently the value is defaulted to 0. When its set the value updates from 0 to 100 and I should be able to check the value and if its 100 when the end user returns they will see the box is checked and can uncheck it to reset the case value back to 0. Currently I have the functionality of setting/saving the value updating the case all working with a process model. Even when they return they can check the box again and it will set the value back to 0. But I cannot figure out how to keep the box checked like the screenshot when the end user returns. It’s always unchecked. local!choices: if(local!case.priorityRank > 0, 0, 100), local!updatePriorityRank: null, a!sectionLayout( label: "", contents: { a!sectionLayout( label: "Case Priority", contents: { a!checkboxField( label: "", choiceLabels: {"Priority"}, choiceValues: {local!choices},

Hi All, Has anyone tried this feature of  subprocess to select Allow more than 1000 instances of this node in other tab. How does this work, can anyone specify any use case? example- I have a Use case to Delete more than 1000 documents .

Hi, I am trying to make an interface wherein I have a read only grid that displays data from a table stored in the database. Now I wrote an expression rule to fetch the data and passed it in the data parameter of the read only grid. I want to implement pagination so that only 10 records initially are shown, clicking on the side arrow button '>' will load the next 10 records i.e. I will be running the query again and again for every 10 records changing my startIndex and batchSize. this will ensure that the query will not fail if the data is huge. I wanted help in implementing the pagination as I tried implementing a few things and it didn't work. I'll attach what I have implemented. PS : The pageSize parameter will not work, as the requirement is to "not use" pageSize.    This is the expression rule where increment tells the batchSize, and times lets me tell the startIndex This is the interface code

a!richTextItem( text: "You must authorize your account before using this functionality." & char(10), style: "STRONG" ), a!richTextItem( text: "CONNECT", link: a!authorizationLink( connectedSystem: cons!ITS_CONS_INNERVUE_CONNECTED_SYSTEM, label: "Confirm connection" ) ), a!richTextItem( text: " " & "to your account to access your calculations first, then click" & " " ), a!richTextItem( text: upper("HERE"), link: a!safeLink(uri: "", openLinkIn: "SAME_TAB") ), a!richTextItem(text: " " & "to proceed.") } Below this code I will be having a UI in read only mode and once the user got authorized the above error message will disappear and the UI will come in editable mode. sometimes it is working fine but sometimes it is not navigating to the editable UI and going back to the initial pa

Hi, I am doing like saving excel sheet to data base and retrieving same data from the user from same excel sheet after editing by the user, where he can upload through file upload component. I am getting the data as well as saving the data through export datastore entity to excel But i want like in excel one of the field is highlighted i send to the user and he need to edit the excel and same highlighted field need to come. Highlighted field in the sense like any color to the field or row of particular data.  How to get the highlighted field after, where we send the excel sheet...that particular row he will edit and send back? i am not getting highlighted field while i am getting the data with out errors.

Hi, I'm trying to update the DB and all the fields are getting updated except Employee Id. Value for EmployeeId is getting updated in Process model Variables as below but not getting updated in DB.

Hi, I have an array like this wherecontains(2,{1,25,32,4}) I want to get 25 and 32 out from this. I will just pass 2 to this array as search parameter.

Hi, I'm new to Appian technology, but I arrive from a different BPM. In Appian for more processes, I need to have an organization chart where there are offices and people that respond from request made by different people, In my example, people from office 1 respond to requests by office A, but for a specific human task activity is assigned to the first level manager, in our example is the CFO, but if the request is open from Office B the request must go to Office 3 and CTO. the hierarchy of the company is very large, is there a smart way to create logic or do I need to create groups and subgroups for each office?

Hi, I have a requirement to upload the documents from knowledge center to external system using webAPI.  For this requirement should I be using get web API or put Web API? Also do we need to use integration object to use webAPI for this requirement? Thanks

I would like my AppianRPAagent to connect to resource.  So, I refered to URL Below. docs.appian.com/.../agents.html After I created a new resource "TestResource", I downloaded AppianRPAagent.exe and run it.However, "TestResource" didn't get online. ■Resource detail Could you tell me what makes this error arise?

Dear I am setting up an environment to evaluate Appian RPA, referring to the URL below.https://docs.appian.com/suite/help/22.4/rpa-8.3/custom_code/configurator.html I have a question. I clicked the button "download" to install Maven,but an error message popped up. Could you tell me what prevented me from installing Maven? Thank you.

 I want to upload the file and save it into the database in integer form. How can I do it?

I need to create a pie chart from the output of multiple expression rule. How can this be done?

Is it possible to customize excel name generated from Record type(Default export to excel functionality of Record type)

Hi all We have a requirement to generate barcodes (EAN and ITF) images - we have the barcode numbers and all other related data. Does anyone have a useable API or plugin (the barcode utilities plugin has not been updated in over 5 years so a bit fearful of using it)

Dear Experts, I have a requirement where I have to Search the Request where certain comments have been made. There can be multiple comments for a Given request number hence I'm using two table "Request" and "Comments" with flat relation where comment table contains requestNumber field to create the relation between the two. Is there any way possible that I can search in the "Request" record with the comments which have made under it.  Thanks, Gaurav Singh

I am trying to  follow the course and under configure the record list. I have created my Interface and when U drag over the read only grid I keep getting the system has encountered an error & the code is HTTP Code 503. Anyone know a work around for this.

Hi, we recently update our version of Appian to 22.2 and I realized that in the Appian process modeler we can not see the Data Tab and Data Function anymore. That was very useful to see which variables we have in the process or to quickly look for functions without memorizing that. Thus, I ask, do they disable this feature in this new version, or do we have to activate that in some way? In the Documentation I've seen that they actually provide this feature: But this is what I have in my environment: Thank you for helping, regards.

Is there a way to get base64 for a given document? I have a Expression rule where one of the rule inputs is a document. I'm using this Expression rule to prepare the body to be sent in one Integration object (we need to execute some logic, and that's the reason why we are doing it in one ER). How can I get the base64? We know that we can manage it by adding a rule input in that integration object, and passing there the document which will be automatically converted to base64, but the approach mentioned above is possible? Thanks in advance

Hi all, Is there any way to convert an appian document to its base64 format?