Discussion Categories

Hi  I am using a!recordData to show data in my gridField  Now I have a requirement of implementing a button wherein If I click that button all the data should be selected ( i.e. the ids of all the records should be saved into a local variable ) But now I am not finding a way to index the recordData at once  Can anyone help me in this ?

Hi, I've been trying to access process mining from my community dashboard but whenever I click on "Request my account" button on the Explore Process Mining section and select the region (in my case, India) and click on check Status, it resets itself and I'm back to "Request my account" again. I haven't received any emails regarding process mining and I'm aware that it might be a server issue but just wanted to make sure I wasn't the only one stuck in this loop.

Hi all,I have defined a process variable in a process model with CDT type. It is working fine in all environments. Now I am adding some new fields into the CDT and published the datastore. Its working fine in dev. When I moved these changes to higher environment( just moving the CDT and scripts and not the process model where the pv is defined as CDT type), its not working as expected. The newly added fields are not present in the CDT type process variable in the process history while debugging and the pv datatype shows with ^ symbol. Can anyone help with this?

Hello Everyone, I would like to apply filter for the process report using queryprocessanalytics.Configured the queryfilters as below but none of the approach helped me.The result is null.  1. a!queryFilter( field: index(index("c7","employeeDetails",{}),"employeeId",{}), operator: "=", value: "7" ), 2. a!queryFilter(field: "c7[recordTye!EmployeeDetails.fields.employeeId]"operator: "=",value: "7"), I have tried to index the same way on the process report data fields > Definition but not able to get the indexed value.Is there any way to filter the values of particular field in record type.

What is the major difference between creating a table from CDT and  creating CDT from a table? On looking from the front end, both look similar. But the XSD file for both of them tell a different story. I have attached both the XSD files here. The one created from table is having columns defined while the other is not having such columns. Will this cause any issues?  @Table(name="tableCDT") @Id @GeneratedValue @Column(name="id", nullable=false, unique=true, columnDefinition="INT") @Column(name="name", columnDefinition="VARCHAR(255)") @Column(name="amount", columnDefinition="DOUBLE") @Column(name="isTrue", columnDefinition="BIT") @Id @GeneratedValue @Column(length=255)

Hi, I'd like to create a form where a super admin creates groups and within those groups there are admins of each group and normal users. I'd like those admins in each group to be able to choose users from an appian list, but I don't know how to extract appian user information and display it in a table. Thanks for the help

Hi There,I'm trying to convert a HTML template to PDF via two smart services, i.e., 1. HTML from template 2. HTML to PDF,But while converting the orientation is changed, attaching screenshot for reference. please help with the issue.

Hi All I want to add a comma after each digits    local!Var: 1223, I want the output like  1,2,2,3 Any help will be greatly appreciated! 

How do I implement address autocomplete or get address suggestion while giving the input in interface? Please help me out.

how we can fetch the document extension name and document type in when we upload something on UI

Hi! Does anybody knows how can I capture the time when  a user accepts a task? and who accept it? when a user input task is assigned to a group of people... thanks!

Hi Community members, I have requirement where i need to send the status to process model, if My integrations fails. Can someone help me. I have configured it this way,  Have created a PV of Error and its of type IntegrationError, but still if integration fails am getting blank value in Error (PV).

I am trying to get the data from Integration , there is multiple field which is more than 4K characters , is appian having restrictions to receive the no of characters and show the data in GUI ? when i test the integrations  , I am seeing the data truncated  , any Input is greatly appreciated ,? if 4K is max limit , whether we need to sub divide them into multiple fields and show them , Please advise

HI Team,I have a nested cdt. for example {id:1, employee:nested_cdt, contact:1234567890, age:21, year:1}, based on age field I'm updating the employee, contact, year using 3 different foreach. So can I do this in a single foreach using update(), I tried but it resulting in 3 different cdt's instead of one. Can anyone help or provide a better solution with a sample code?Thanks in advance [mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] 

We what to catch errors in a running process model, save the error in DB. We also want to know when the PM halts, save something to DB, too.

We have DEV, QC and Production Cloud based Appian environments. When developing on the DEV environment, and creating a new Record Type which then creates a new SQL table on our cloud database schema, it generates a SQL script for you to create the table. There is also a checkbox option to apply that SQL script immediately for you to your source schema.  The same happens if you update the Record Type fields. A SQL script is generated to alter your source table for you. I'm interested to hear how everyone handles their database changes across environments when using Record Types that generate the source tables for you? Do you download and store every single SQL script as you make changes to a Record Type? If so, where do you store them? Do you manually run those scripts on your databases for each environment? Do you deploy them as part of a package which only has the SQL scripts? Or do you deploy them as part of a package which includes both the SQL scripts and your ap

Hello there! I have some date as a data subset form and I need to create a pie chart which show which contract are overdue and which not .This pie chart need to be drilldown to a grid  which list only the contract on the selected category. The data are these: local!contrat: todatasubset({ a!map(id: 1,name: "Contract A",,deadline: today()-6,status: "Decline"), a!map(id: 2,name: "Contract B",,deadline: today()-20,status: "Open"), a!map(id: 3,name: "Contract C",,deadline: today()-2,status: "Draft"), a!map(id: 4,name: "Contract D",,deadline: today()+28,status: "Open"), a!map(id: 5,name: "Contract E",,deadline: today()-30,status: "Complete"), }, How can I do the grouping with this format of data? Thank you in advance

We are trying to fetch access token in order to integrte with gmail. To get the access token, we need JWT, which comprises of header, claim set and signature. The header and claim set part are clear. Can anyone help to understand how to compute this signature in appian? Is there any plugin available in the market?

For using GUID/UUIDs as primary keys, Appian supports varchar datatypes; however this is not very performant for indexing. The UUID datatype was introduced in MariaDB 10.7 and supports index-friendly storage. Will Appian support this datatype for data synced records?  Our use case involves supporting data transfer and merge from distributed systems, so using GUIDs as primary keys prevents any conflicts upon merge. Otherwise, we'd need to clear out all the keys and generate new ones upon inserts (pks and fks). Also we'd need to maintain a mapping of origin keys to destination keys. This is a tedious process. 

I have a requirement to generate and view PDF on single click , how can i do ? now i am generating then viewing pdf using start process, is there any way to do in one click thanks,

Hi,I am trying to get all the values from a table using Appian RPA Get table values action. But I am getting an error. This is the table I am trying to get. Transaction Date #Ref Description Contact Deposit Charges Payment Balance Action This is the table action configuration. This is the error I am getting.[STAT] 2023-11-03 04:37:36 01m 06s (0h) - - Start action 'browser->get-table-values' - 'Get table values' // dur: - - avg: - etc: [INFO] 2023-11-03 04:37:36 01m 06s (0h) - Target table has no footer section [WARN] 2023-11-03 04:37:37 01m 06s (0h) - Method manageException invoked [ERROR] 2023-11-03 04:37:37 01m 07s (0h) - java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at j

I want a column in an editable grid where I have checkboxes for every cell in that column. User can select yes or no option

Greetings, Could anyone suggest to me a basic POC get a good grasp in Appian RPA? I am good in Basic RPA but still, I wanna work in a POC to get a good Knowledge. so, I am kindly requesting you to suggest me a POC to work on Appian RPA. Thanks and Regards

Hello!I'm having a doubt about the use of the function index(), as a best practice in Appian development.In the Appian documentation appears as: index( data, index, default ), but I know that we can use the function as: index( data, index, index, index... (as many as needed), default ), to navigate between an object and it returns the value needed. The question is: Should I use nested index() functions? or Is better to use just one index function with many indexes inside? Example: {CountriesES, CountriesUS, CountriesNL} -> Cities -> Town 1 - Index(CountriesES, "Cities", "Town", null) 2 - Index(lIndex(CountriesES, "Cities", null), "Town", null).

Hi I am Learning Appian development, i have doubt how to combine two text local variables please hep me on this a!localVariables ( localVar1: Text := "Hello,", localVar2: Text := " World!" ) local!combinedText := local!localVar1 & local!localVar2