Discussion Categories

Limitations of Query Entity and Query Process Analytics

I have modified the CDT by adding one columns in one environment by XSD .Now I am trying to deploy that CDT object to other environment.Can I directly deploy that CDT object to other environment.or do I need to do anything in the Target environment before deploying.CAn you please suggest me steps to deploy CDT

does it automatically update in all places where it has been used?

How to apply Aggregation (grouping) based on condition as like Group by on condition in Mysql? Example: SELECT * FROM `TABLE` GROUP BY ( CASE WHEN `NAME` = 'AA' THEN `COLUMN1` ELSE `COLUMN2` END );

Hi Team , We are getting intermittent connection issues while  using a expression rule, which retrieves data from DB source . Please find below logs for your reference .  Caused by: com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: The data store entity does not exist, has been deleted, or you do not have sufficient privileges to access its data. (APNX-1-4261-001) at com.appiancorp.expr.server.fn.query.QueryEntity.getDataStore(QueryEntity.java:253) at com.appiancorp.expr.server.fn.query.QueryEntity.queryentity_appian_internal(QueryEntity.java:155) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:115) at com.appiancorp.expr.server.fn.query.QueryEntity.executeQuery(QueryEntity.java:99) at com.appiancorp.expr.server.fn.query.AbstractQueryExecutor.op(AbstractQueryExecutor.java:66) at com.appiancorp.core.expr.fn.Signature.eval(Signature.java:182) at com.appiancorp.core.expr

We are using data-sync records and allowing Appian to automatically generate the tables. We ran into an issue where the maximum row length of 65535 bytes is being reached in MariaDB so we are unable to add any more columns. The issue here is that Appian defaults text fields to varchar 255 and "long text" to 4000. Therefore, if you have 16 long texts in a record type, you're already at the row limit. Further, there is no way to change the text length in the Record Type Designer. Changing a field length on the DB side require us to go back into the Record Type Designer and re-map the field since the data type has changed. Consequently, we need to also remap all references to the record field, which is a tedious task.  1. Will Appian enable an easier way to change text lengths in Record Type designer without needing to run a SQL script, remap the field, and repoint all field references?  2. Does Data Sync support the TEXT data type instead of VARCHAR? I believe TEX

Write a program to get a list, sorted in increasing order by the last element in each tuple from a given list of non-empty tuples. Input: [(1, 3), (3, 2), (2, 1)] Output: [(2, 1), (3, 2), (1, 3)]

When creating a service backed record having more around more than 10,000 records, there is a error. How to resolve that error? Should I go for disable sync options and then create.

Hi, Requirement is to create one expression rule in which I need to pass another expression rule as rule input, I do not know what type of rule input to define. Use Case - Have integration, need to call through expression rules, if integration is failed, I need to retry n number of time. and if it returns success, break the calling chain of integration Thanks, in advance. Shree Krishna  

I am using the export button in a record grid field. However, when the Excel file is downloaded, some of the fields have long URL links in parentheses next to them. I am not sure how to get rid of the URL links. I think this is because one of the links is a a!recordLink() component and another link is created through a personalized expression rule. Wanted to see if anyone else had insight about this on getting the link to show as normal rather than a super long URL. I have provided a screenshot of what the Excel file looks like below. 

write a program to check whether it is a Armstrong or not ? Input : 153Output : Yes 153 is an Armstrong number.1*1*1 + 5*5*5 + 3*3*3 = 153

How can we assign cases to the users in round robin method.Could anyone of you Please suggest the Logic/CodeThanks in Advance

ERROR:Work item cancelled (Data Outputs) Hello We have a problem in PRODUCTION. The service account that is used for deployments from PRE to PRO through the compare and deploy component, was deactivated, now after activating the service account again, the processes keep failing and it shouldn't since the service account is already active. Does anyone have a solution for this? The error that comes out is this: ERROR:Work item canceled (Data Outputs)

Hi, My current system date and time is 5/25/2023 9:03 PM and also, I am passing now() to one of the pv variables (Image#1).  Image#1 But, when I try to see the db saved value, it was showing as "5/26/2023 01:03:40".  Can someone advise me, where it was going wrong. Thanks in advance.

Hi Team, How do we check if the dictionary has one of the value as null. ERROR ---------- Expression evaluation error at function a!forEach [line 8]: Error in a!forEach() expression during iteration 2: Expression evaluation error in rule 'config_temp': Invalid index (1) for list: valid range is empty Eg: dict1:{ field1:"value1", field2:"value2", field3:"" } Now, in my logic I'm trying to get each field value and storing in a variable. index(local!data,"field3",null())

Hi all. I took the exam and failed. I scored really low on SDLC information, expressions rules and process models. Where should I go to further study those three concepts? Specifically, I had a hard time knowing which Appian function to use in an expression. Thank you. 

I am reading mail from gmail via intergration and i need to download  attachment from the that mail.how can we do it?

Hi  I am trying to refresh my Data stored in the expression. There is link which stores true, false in local!refreshBool and I want to refresh the data based on that. This expression rule pulls data from Integration. But the Data is not getting refreshed. When I TEST interface the data is refreshed but not when I click on link  local!data: rule!TA_getAndFormatRandomUser(), local!refreshBool, local!refreshData: a!refreshVariable( value: local!data, refreshOnReferencedVarChange: local!refreshBool ),

Hi experts, Need your support in one task. How to restore data of User Input Task if we write some data in a Form and instead of clicking Submit/Cancel button we close the form tab after inputting 2-3 fields. And from a Task Report we go to that exact User Input Task and we want to continue from the point we left in the form. I want my data in the form that I input at the first time back. Is there a way to continue from the point I left in the form. Thank you in advance!

I try to selec one radio button with a dinamik link but the value is null in every moment.

Hi Everyone, i had a requirement to display Number (Integer) value  inside donut (piechartfield)

Hi Team, How can I deploy a custom component to Appian Cloud? I don't want publish it to AppMarket, it should be a private component plugin.

Do we get course completion certificate for Appian Analyst course in Appian community

I'm currently trying to utilize google translation and google recaptcha inside portals. Translation works flawlessly within the interface and independently, but when used from the portal it throws an error below: I also get an error using google recaptcha embedded by default through portals: I have tested connection on both of the connected systems and they are working as expected without any issues. 

I want to create below boxes dynamically for example if I receive 5 values from DB then there should be 2 rows and 3 columns, 1st complete row and 2nd row with 2 items