Discussion Categories

Hi I am using The "Import From Excel to DB" smart service. The data so written into the DB is not synced with the record type for the same DSE. For using "Sync Records" smart service it is asking the identifiers of the newly added records, which i do not have. How do i force a sync after the data is extracted from Excel to DB?

Here I want to get the most visited top 3 destinations and the count of journeys on each location.(relationship between 2 tables) So make an expression rule for that. but I need to do with record type with the use of a custom record field, here i found the custom expression rule, anyone guide me on how to use this code with a custom expression rule in record type? code below here a!localVariables( local!data:a!queryRecordType( recordType: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey', fields: a!aggregationFields( groupings: { a!grouping( field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.relationships.{324614a4-84f3-45b4-bce2-95cbc8b65b6d}vsDestination.fields.{dbe0e7f1-b3d7-456b-9d82-e81a9042d256}name', alias: "name_grouping1" ) }, measures: { a!measure( function: "COUNT", field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.fields.{1209585a-f527-4ad9-b1fc-cc7ccc5dd973}de

Hi, I need to compare two Hebrew names if they are equal. Tried using exact function, regex but it doesn't work as expected. Thanks, Preethi

Hi all, what is the difference between Build Apps Faster with Sync vs Disable sync and related features. Thanks & Regards, Kiran Sajjan 

if anyone know let me know

Hi My application is currently running on Oracle, and we have more than 1000 entities created as CDT's in Appian for the database. Now we are migrating from Oracle to MySQL. Now Can I change the source of the existing CDTs from Oracle to MYSQL from their XSD files without creating new CDT's. Any suggestions please. Thanks, Srikanth

So, I need to use visibility/showWhen to display a dropdown if a certain choice of radio button is selected. The format is kind of like this, the two dropdowns are supposed to be hidden until 'Yes' is selected in the group of the second radio buttons. This is currently the code I have. I'm still fairly new to Appian and trying to figure things out! I have experience w/Python/C#/Vis Basic so explaining in those terms could be helpful as well if( a!radioButtonField(choiceLabels: "Yes"), showWhen:true()

Hi, I want to get the List of Reporting persons Usernames by giving Supervisor Username as rule input. Based on below screenshot the code is working fine but the function usersearch() is 3rd party plugins so need to replace that with Appian cloud function. Kindly suggest the which need to replace usersearch() function for fetching the same data like below

Hi everyone! I'm a product manager at Appian and our team is working on measuring which recent features have helped you the most in Appian, what's still slowing you down, etc. If you have 5 minutes to spare, we would greatly appreciate your participation in this survey--thank you! 

I have a process model and interface set up so when user clicks save and continue it exits the form to write to DB then a XOR gate that checks the user action, if it's save & continue it loops back to the interface. All of the nodes are activity chained. But for some reason it keeps exiting out of the interface instead of just loading it back up. Could it be because there are a lot of writes to database so it's delaying the loop back? I do have less than 50 nodes.

Hi All, I have two interfaces in which one is embedded to another. Is that possible to pass value from one to another without submitting the form or by just selecting the dropdown value in one interface? Thanks in advance.

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