Discussion Categories

Hi, Im new to using reject function.  Now im using the reject function in a process model in a script task  In the input : I am calculating a map which looks like this :  {    id : <>,    account : <account_cdt(id, name, hold_code)>  } Now in the output tab I want to use reject function to reject all those accounts who have hold codes null ... but then my requirement is that the ID should remain in the output I am using reject function like this :  reject( fn!isnull(_),     a!forEach(           items : ac!map,           expression : {                  id : fv!item.id,                  holdCodes : index(index(fv!item, "account"), "hold_code")           }    ) ) Now I know this wont work, but can anyone suggest me how to make it

Hi Techies, We have a requirement where we want to show a particular site page when a particular user logs in. We have provided the site page url directly to the users but the problem is they want to see different site page for different users on log in. Is there any way we can change the default page that opens after logging in for different set of users? Thanks

Hello Everyone, I am trying to append data into a nested cdt in the order i enter data in the tabs, but unable to do so. Currently i am saving the data like this saveInto:{local!info,a!save(ri!userData.UserInfo.field1,append(ri!userData.UserInfo.field1,local!info)) I have a big multi section form and each section has multiple tabs. The section (form) i am working has 4 tabs and each tab has almost same fields. I have a rule input called users data which is of the type usersData cdt. usersData cdt has nested cdt's. My use case is - users should be able to enter data in multiple tabs in the form and after entering the data it should be appended into one of the nested cdt's of the rule input. The nested cdt is an array. I want the data from tabs to be saved in the order user enters them. Ex - Tab 1 - Fields A, B, C                                              &nb

I have a read only grid with select boxes enabled creating something like thisAlmost everyone says that you should used delete from data store entities to handle record deleting. However, this page https://docs.appian.com/suite/help/23.1/Custom_Data_Types.html says that most of the time you should not use CDT but CDTs are required for DSE.Where can I find a step by step walk though that does not use CDTs or DSEs to delete multiple records from a read only grid?

Is there a way to get editable grid to page through the entire data set similar to 'read-only grid'?  I have 10K records and each record needs to be classified based on a list of categories.  Right now, the entire 10K records are being shown. Thanks.

Hi, I am creating an application in Spanish and when creating a User Filter for a Record Type of type Date Range I have the problem that the date selection calendars are in English and I want them in Spanish, is there any way to change it?

I have this querydelete from PLSM_note where noteId in (fn!substitute(fn!joinarray(ac!selectedRecordIds, ";"),";",","))as shown in the below image. This query should translate to: delete from PLSM_note where noteId in (1,2,4,50)A) This is all on a single rowB) This is a single queryWhat's the solution to this?

Dear Team, Could someone help me to understand the below issue please. I am trying to fetch the total count of the records from DB view. When I give fetchTotalCount=true it's throwing an error 'Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query'. If I change the fetchTotalCount=false, it's working fine. Sample  code is below: a!queryEntity( entity: cons!DB_VIEWS_DSE, query: a!query( selection: a!querySelection( columns: a!queryColumn( field: "id" ) ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: { a!sortInfo(field: "id", ascending: false()) } ) ), fetchtotalcount: true )

i need to get json data from appian server to component plugin   which plugin  is suitable for that ?? any idea  

We have MicroFocus 12.56 v of Load Runner / Performance Center for load testing. However, Web HTTP protocol is not at all recording any client - server communications when we try to test the Appian application. Any suggestions pls. Thanks

I'm making an interface form with Appian. I'm making the form interactive. A textbox should only appear when specific variables are true. Appian offers a wonderful feature for this where you can add an expression to a "only show when" function. It presently holds the following expression: edate(today(), -804) >= ri!GeboorteDatum The variable on the form is ri!geboortedatum. Another statement that says: only show when the date value is not null is required. I tried everything but nothing worked. Is there a solution? The programming language appears to be similar to Microsoft Excel. Perhaps something like edate(today(), -804) >= ri!GeboorteDatum & isnull(ri!Geboortedatum)

Hi all, Using the smart service PDF from XSL FO Transformation With Fonts from the Dynamic Document Generator, I am facing issues justifying text within a block when it is not containing spaces on it: On this example: <fo:table-row> <fo:table-cell> <fo:block-container > <fo:block margin-left="0mm" margin-top="3mm" margin-bottom="0mm" linefeed-treatment='preserve' white-space-treatment='preserve-space' white-space-collapse='true' > <xsl:value-of select="descripcion_txt" /> <!-- <xsl:call-template name="zero_width_space_1"> <xsl:with-param name="data" select="descripcion_txt"/> </xsl:call-template> --> </fo:block> </fo:block-container> </fo:table-cell> </fo:table-row> Looking for some help we tested using a template to split texts but is not wrapping words correctly: Templates: <xsl:template name="zero_

Hi, We have defined the list of file extensions which are to be allowed via admin console as shown below. When we try to load any file which has an extension(png) that is not present in the admin console, it prompts an error message to the user as shown below which is expected.Had anyone faced similar issue, or any inputs to overcome this?Code snippet:a!localVariables(  local!files,  a!fileUploadField(    label: "Upload Document",    value: local!files,    saveInto: local!files,    target: cons!TEST_UPLOAD_FOLDER  ))

Hi, I have a requirement to append the values of a particular computation to a local variable using append function  The rule goes like this :  a!localVariables( local!data : {"x", "y", "z", }, local!finalValues, a!forEach( items: local!data, expression: append( local!finalValues, performSomeComputation(fv!item) ) ) ) now the problem is, the local variable is not getting updated no matter what, I tried using update dictionary as well as insert(local!finalValues, length(local!finalValues) + 1, fv!item) .. but still it wont append .. is there any other method I can use to append values ?

Hi Experts, Below Block-A code line is working fine, whereas Block-B is not working even though "tointeger(index(rule!AB_getReviewKey(key: 100),"reviewkey",null()))" is returned 2. Any comments please. ----------------------- Block-A ------------------------- a!localVariables(local!reviewkey: 2,local!excludeKeys: if(local!reviewkey = 2,{ 1, 3, 4},if(local!reviewkey = 5, { 1,3,4,5,6 }, {1,2,3 })),local!excludeKeys) ----------------------- Block-B ------------------------- a!localVariables( local!reviewkey: tointeger(index(rule!AB_getReviewKey(key: 100),"reviewkey",null())), local!excludeKeys: if( local!reviewkey = 2, { 1, 3, 4}, if(local!reviewkey = 5, { 1,3,4,5,6 }, {1,2,3 }) ), local!excludeKeys)

How can I change the Delete Note recordActionField to look like the buttonArrayLayout?Or, how can I add the a recordAction to a buttonArray? In the end I want to have something like thisPlease notice the Delete Records button and the Add Record button.The Add Record button also needs to keep a reference to a parent record.

Hi,  I have CDT which is created from a View. The view takes around 8 sec. I have process model which uses Export DSE to Excel  smart service to export the content of view to an excel. The process model executes fine and generates the excel when run in debug mode (Start process for debugging).  When the process triggers on a timer ( timer event) it fails to execute Export DSE to Excel node and raises error " Error accessing data store entity: <<xxx_V_xxxxx>>. Please contact a system administrator for additional details. (APNX-1-4505-026)) I have checked the system error logs, following logs are logged. Error accessing data store entity: <<xxx_V_xxxx>>. Please contact a system administrator for additional details. An error occurred while retrieving the data. Details: Unexpected error executing query (type: [xxxxxx], query: [queryentity expression], order by: [[Sort[id asc]]] Caused by: org.hibernate.QueryTimeoutException: could not execute que

Hi, Actually I created a Process Model that export SQL to Excel with the plugin, but I don't know how I can put this PM in a!startProcessLink function and how I can filter inside my interface. Last time I used a!exportDataStoreEntityToExcel function but I don't know how replecate the same filters and conditions with this Process Model. Thanks for your help.

2023-04-13 10:01:02,564 [http-nio-8080-exec-3] ERROR com.atlassian.plugin.servlet.DefaultServletModuleManager - Unable to create new reference LazyLoadedServletReference{descriptor=com.component.plugins.JsonToHtml:taskList (An example servlet that responds to GET requests with a JSON array containing the authenticated user's task list), servletContext=org.apache.catalina.core.ApplicationContextFacade@39b1b977}io.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.IllegalStateException: Failed to introspect Class [com.component.plugins.JsonToHtml.TaskList] from ClassLoader [com.component.plugins.JsonToHtml [55]] at io.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:156) at io.atlassian.util.concurrent.LazyReference.get(LazyReference.java:116) at com.atlassian.plugin.servlet.DefaultServletModuleManager.getInstance(DefaultServletModuleManager.java:430) at com.atlassian.plugin.servlet.DefaultServletModuleManager.getServlet(DefaultServl

Hi All, Recently we have upgraded the Appian version  to 22.4.455.0  from 21.3  . after the upgrade process models are not opening and its keep on loading , But for some people its opeing in incognito mode , we have tried in both edge and chrome. I have attached the image below can somebody please help me on this Thanks in advance

why i cant add a button widget in a column component , it says that the column component cant take button widget 

I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB

Hi, In one of our applications, we are using SAML OAuth2.0. When there is only one connected system, we are getting proper response. But when there are multiple connected systems, first connected system is able to connect successfully, but when second connected system makes a call, we are getting error saying " assertion has already been consumed" . As a work around, we are trying to add multiple Identity Providers, one for each of the connected systems. But when we are trying to add the second Identity Provider. As soon as I upload the IDP Metadata file in the console, we are getting the error mentioning -- Another identity provider already exists with the same entity ID provided in this metadata file. Entity IDs must be unique. Could some one suggest the solution for this. Regards, Chetana

Hi, I am having a dropdown component that has choice labels which are sentences up to 25 words long. Is there any option in Appian to display it in a word-wrapped form? Currently it displays upto 20 words (in one choice label) and adds "..." beyond that.  Thanks in advance.

Hello: I need to retrieve data from an external API which requires a parameter (ProductID).  The values for ProductID reside in an application recordType table and has to be passed to the integration.  So, the expression called to populate another recordType to store data from the API has a query.  However, I keep getting this error.  Any suggestions on how to resolve this issue? Thank you. Ma