General

Hey Techies, I have a Group 'User Group 1' with membership to include all the members of 'Subgroup 1'.  For testing purposes, I want to exclude selective members of 'Subgroup 1' from 'User Group 1' while maintaining the subgroup membership rule. Any pointers?

Hello,  I am saving the uploaded files to a local variable and wanted to push to a folder. used a!moveDocument service  a!moveDocument(document:local!uploadedDocs,destination:(constant pointing to folder),                               This does not do anything. Can you please help 

Appian says I have a List of Text with 2 items, but when I try to get its length it says it has only 1 item. I need to do a flatten here to achieve the right response with 2 items and its type is not even a List of List of Text. Code for reference:a!localVariables( local!test: index({ code: { "A", "B" } }, "code", null), length(local!test) ) Am I doing something wrong here ? I'm really not getting it :/ For me seems Appian is interpreting the type wrong here because of its dynamic typing and even if it says the list has 2 items on the local variables, the interpreter is doing something different. From time to time we are facing little consistence issues like those and defects are being opened by QA and they take a lot of time for us to find out what the problem really is. This is something so core to the platform that we assume that it's working, but here and there this kind of stuff keeps hapening. We are needing to defend ourselfs against the platform because o

Write a code to find the duplicate words in a string. input string = "Big black bug bit a big black dog on his big black nose" output:  Duplicate words in a given string : big black

Hi, I want to display the difference between today's date and created date in record type as an integer value. Further, I want to show the value in certain colors based on condition (like if the values is less than 3 then green color; if the values are in between 3 and 5 then yellow; and if the values are greater than 5 then red). This values will only come when the status is not completed. Can somebody guide me?. Many thank,

Hello all, I have an array of 3 items. local!array:{  { id: 1, deleted: true, activeStep: false },  { id: 2, deleted: false, activeStep: false },  { id: 3, deleted: false, activeStep: false },}, Now I want to concat text based on index. for index 2 concatenate "Active" and for index 3: " orderid" Eg: local!array:{  { id: 1, deleted: "Active true", activeStep: "orderid false" },  { id: 2, deleted:"Active false", activeStep: "orderid false" },  { id: 3, deleted: "Active false", activeStep: "orderid false" },}, How can I do this. Thank you in advance.

Hi All, I have a query regarding checkbox. There are three checkbox in interface as shown in snippet below, but only one of them should be selected at a time.  Can anyone please help me how to achieve this?

Hello everyone, Got an new error in an interface that existed for a while. It is a simple interface that takes several CDTs of data and displays it as well as taking some text input from users and passig it to a process, it does not have record headers or actions in it. This error refers to 'Headers' and 'body' that aren't used anywhere in code for that interface, so could anyone please help me make sense of it? Also, strangely enough it pops up only ocassionally and/or for different users, with same data.

Hi All, will appian integrate something like a reporting services?  A tool like SQL Server reporting services o Jasper , useful to easy design pdf or excel or any other file format, map data from database fields to these documents in order to download them dynamically via web API Thx

Did Appian remove sortintegerarray() ,sortdecimealarry() ,sorttextarray().       function 

The size of  a folder is showing 69 GB, while the sum of size of all document in it is less than 20 GB. Due to this, Disk Utilization is increasing . Is there any way to correct this and decrease the disk utilization?

Hi Everyone, I have a requirement where I need to generate a pdf from html.  To achieve this I am using Html to Pdf (Page Number and Custom Fonts) but it is Faling due to java.lang.NullPointerException. Can someone help me on this?

Hello,Is there a way to automate taking DB back up from Appian Cloud? We do take back up manually from Appian Cloud before PROD deployment every month.However, we now are looking for automating the process before every deployment.Please suggest if you know of any good way to take Appian Cloud DB backup without the intervention of Appian Support.(I know of "mysqldump" plugin but do not want to use it since it's not maintained for the latest versions of Appian - https://community.appian.com/b/appmarket/posts/mysqldump)

My requirement is as below: I have a set of Ids, and using an integration I am getting all details of the records of those Ids. After certain manipulation of the dataset, i am displaying the dataset on a grid. Now I want to download the same grid to an excel/csv document. Please note, I am not saving the data in any table so I can't use export to csv from DSE option. What I have tried is using an document WebApi where I pass my Ids and get the details and download the document.  The problem with this approach is: 1) I have to call the integration again and do those manipulations again 2) The Ids I am passing as query parameters. When there are more than 1000 ids, the url is becoming too long and the API is failing. Can anyone please suggest an alternative approach to resolve this issue TIA

Update class 8 to 9 { a!map(name: "X", class: 5, School: "ABC"), a!map(name: "Y", class: 6, School: "ADC"), a!map(name: "Z", class: 7, School: "AEC"), a!map(name: "K", class: 8, School: "AFC") }

Hi guys, Have question that we are having user login through SSO, also set-up the SAML. So when the user first time login, Appian will create this "New User" also add them to the group. So the issue is we also need update DB, just wondering is there anyway we can trigger a PM to update user DB once we have a new user or a group got update? Or it can be set-up via SAML? Any suggestions appreciated.  Thanks in Advance. 

is there any data flow from appian outlook add-in to appian cloud application. This is related to Task Viewer Add-in for Microsoft Outlook.

i have two tables TPS Interchange and TFM Trinary. Primary key of TFM Trinary is foreing key of TPS Interchange which is Trinary_id . TFM Trinary contains key Column which has some text data like TESTCALL, TESTEMAILalso created a record type TPS Interchange  and record type TFM Trinary . Now i want to create an custom field  like if   'recordType!TPS interchnage.Trinary_id = 15 then it showsTFM Trinary .key= TESTCALL if 'recordType!TPS interchnage.Trinary_id = 20 then it showsTFM Trinary .key= TESTEMAIL otherwise Default nullHow to do this ?

We are looking for a full time Appian Developer. At this time we are not interested in hiring a consultant or consultant group, in-house only. Please apply via the link below: phg.tbe.taleo.net/.../viewRequisition

Hello all, We are retrieving a row data from Database using query entity.  In query filter we have a condition to get a row data. Example  a!queryFilter(field: "name",operator: "includes",value: ri!status) Database having status value as "awaiting_info" I need to get the row data irrespective of case sensitive like (ri!status= "awaiting_info" or "AWAITING_INFO" or "AWAITING_info" or "awaiting_INFO") . On the "status" fields in the postgreSQL data base side applied the  case_insensitive COLLATION .But wherever we have applied the case_insensitive COLLATION, those colums are not supporting the  "include" operator from the query entity from Appian expression rule. Any suggestion on this !!! 

Hi team, i have requirement to implement a donut style of pie chart. everything is fine expect the data labels. it is not showing complete label name in the legend. a!pieChartField( label: "Employee Credential Status", labelPosition: "ABOVE", series: { a!chartSeries(label: "off boarding or termination of client", data: 1374, color: "BLUEGRAY"), a!chartSeries(label: "making account to non billabale", data: 343, color: "AMBER"), a!chartSeries(label: "updated accouts to check pay", data: 97, color: "RED") }, height: "SHORT", seriesLabelStyle: "LEGEND", colorScheme: "CLASSIC", style: "DONUT", showTooltips:true, showDataLabels: true, showAsPercentage: true ) The requirement is to show complete label in the legend. 

Hi All, I have two interface, A and B. When a button in interface A is clicked all the components in B should be refreshed. Is it possible to refresh all the components in interface B without passing parameters in all components in interface B?(I am passing the refresh variable from A to B, but not from B to components in B)

When I select CDT  in datastore. I got this type of error. Error: "An error was encountered while processing your request. Please try again." what should I do with this.

Hi All, Is there any way to control the size of text in dropdown values?

Hi , we are trying to access Appian by using mobile apps and we receive an error "An unknown error has occurred". By using a browser we don't have that problem. Any idea how to proceed will be much appreciated. BR,Natasa