Discussion Categories

Hello everyone, We are currently facing challenges when it comes to identifying users who are part of Constants of Type "User" or "User or Group". This poses a problem when we need to deactivate someone's account and remove or replace them from all associated groups and constants. We have successfully obtained the list of group names that a user (e.g., the logged-in user) belongs to using the following code snippet: a!richTextDisplayField( value: { a!richTextBulletedList( items: { a!forEach( items: getgroupsformemberuser(loggedInUser()), expression: group(fv!item, "groupName") ) } ) } ) However, we still encounter difficulties in identifying users who are part of Constants of Type "User" or "User or Group". We are considering the use of constant descriptions to improve the search process for these constants. If you have any

HI Team I have a scenario , where I have to read User login logs daily and save into database. Solution: > I have created a process model to run in a scheduled manner i.e, daily once , In that I have used readcsvlog( "login-audit.csv." ) It is working fine when i debug process model. Issue: when the process model triggers in scheduled manner, it is unable to read csv file. Getting empty data Please feel free to advice any solutions

Hi All, I moved an object from Application A to Application B. When I deploy the object from Application B to higher environment it adds the object successfully to Application B. But I notice that the object is not removed from Application A in the higher environment. What do I need to do for the object removal? Do I deploy the whole Application A? Does anybody have an insight on this? Appreciate your help on this! Regards, Sakshee

Hi All,I have used Plug in "PDF from HTML" to generate PDF from the html doc.HTML has the expected data with 34 rows but PDF generated has only 28 rows. can anyone guide as to how the last 8 lines are getting truncated in the PDF. Please let me know how to have all rows in PDF generated from HTML doc.red  highlighted part in HTML is not getting generated in PDF.

What is the difference between a!queryRecordType()  and a!queryRecord(). In which scenario  I will use these  two...

Hi all, Is it possible to add cusomField1 to 10 into record type user ? My first approach was adding a custom record field but user function cannot be used inside. Any idea ? Regards  Jean-Alain

Hi, I have a google drive connected system, I use it in an integration to create folders in google drive. It works fine, but after a few minutes of inactivity or sign out my account, the authorization is canceled or expires and I have to re-authorize in my concept connected system for my integration to work again. How can I always leave it active, without the need to authorize it every moment?

I have a csv template which is expecting few fields(could be 100 columns). First i created a dummy template to see if this even works and i am facing some challenges here, need some help in understanding what i did wrong. Below CSV has the data returned however not in expected format. These are supposed to print in 3 different rows but not in same row. Did a!foreach for each column to return its value and saved in respective variables... my actual template: a!localVariables( local!data: a!queryEntity( entity: cons!TST_DSE_TEST, query: a!query( filter: { a!queryFilter( field: "createdOn", operator: ">=", value: fn!datetime(2023, 7, 1, 7, 2, 5, 0) ), a!queryFilter( field: "createdOn", operator: "

Hi everyone, We initially installed a development agent on an AWS server to enable the execution of a Robotic Process Automation (RPA) process. When the AWS server is connected, the RPA process runs smoothly. However, when the AWS server gets disconnected, the agent goes offline, causing interruptions in the RPA process. To address this issue, we attempted to use a task scheduler, which previously allowed us to activate the agent at scheduled times or manually. Unfortunately, the task scheduler has recently been unreliable, failing to activate the agent as expected. This problem has been occurring only in the development and testing AWS servers for the past month, while the production environment continues to function properly. I discovered a beneficial feature called "Auto Sign-In" in Appian RPA, which offers the ability to automatically restart a bot without requiring manual login to AWS. This feature aims to provide a convenient and uninterrupted execution of the RPA bot.

Hi All, I wanted to understand how document is stored in Appian . Does Appian store it internally as a stream ? or there is some other sort of mechanism for same ? Please let me know if you have any sort of Appian forum links or you have some sort of understanding for this . This is just for my knowledge . Regards, Sparsh Shangloo

Is there a way to find out what appian object is being pointed at from a Opaque url? URI: /suite/design/(opaque ID) One way is just going to the URL to get the object name. But for some reason, when I go to that URL, my environment is crashing. I am suspecting the UI is doing large number of calls that is causing the heap space to run out.

here i have data like right side.... once i select the data from dropdown the value but i have to show the in the below remaining data.. how can i achieve this ?

Hi! I have a summary view with a read-only grid (from Record 1). When I run my process model, I make a query (type "UPDATE" and "SET") to change the status of one of the fields, and I need the read-only grid to update After I run the process model, the value of the variable in my Record Type (Data Preview) changes succesfully... But it does not change in my read-only grid (based on this record I have shown in the last image). To make it "update", I have to go to "Sync Options" --> Start Full Sync manually. After doing this, the read only grid updates. Y tried to use the refresh button of the read only grid but doesn´t work, only full sync What can be happening? Thanks a lot!

Hi! I´m trying to use the smart service "Query Database" to change the value of a concrete field. I have managed to use the an "Update" and "Set" SQL statement to update a database used in the process model which works correctly The fact is that now I would like to do a similar query, but to update a record which is NOT BEING USED in this process model ("CPF Lineas Pedido") Even though I created the query and the process model runs OK, the value of the field "facturada" does not change properly. Also, I brought the new Record as a process variable, but its value does not change (I´m not using it in the process model because I only need to update one value, the one with the query) What can I do?

Hi ,mails are not getting polled in the UI , getting the below error."Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID"Can someone please let me know what can be the cause and what is the latest version of poller.

Hello everyone, I have one question : I need to generate 7-8 different types of reports and when the user clicks on the particular report it show get downloaded in Excel.  So, how to implement it and what to use? Thanks.

Hi, I am trying to upload an email attachment (size: 1.5MB) via the a!fileUploadField component on an interface, but it throws an error indicating that the file "could not be uploaded. Please try uploading it again." On trying with different files (email attachments), this seems to be working fine. I could not find any specific issues with the file which results in the error, but I'm interested to know what is causing this. Can you help me out with what may cause this error? I am also interested to know where I can find the logs for this - I did check the system logs (Appian Cloud), but I am unable to find a file that will contain the log for this issue.

I'm trying to populate conditional dynamic data in my docX. I have regular data populating fine, but I can't seem to find the correct syntax for conditional statements. Here's what I have so far that keeps evaluating to false:{if "<<${doc.center.subjectType}>>" = "Individual" "Is Individual" "Not Individual"} Anyone know what's going wrong here? or where I can find documentation on this? Thank you

Hi Team, I'm using a single process model for creating employee and updating employee(related action). While creating employee simply i create a new folder and move employee documents there. But incase of updating i need to add documents to the same folder. I don't know how to achieve this. I tried with tofolder("emp 1") function with a or gate to check whether it's updation or creation but getting error. Then i removed or gate and checked with the create folder then move documents methods again for updation process it creating a new folder with same name. Need support on this.. Thanks in advance 

Brief Summary: I have a CDT with near to 500 fields that holds some values and just to mentioned I am not using any nested CDTs. I'm using that CDT inside an interface to hold values. I am worried if the application could face any issues in the future if it grows larger. I would like to know even if I have more than 500 fields, is it safe to use that CDT in the application or is it causes any issues in the future. Note: I don't wish to proceed for partial CDTs by breaking the entire CDT into sub-CDTs. Please list down what kind of issues my application may face, if any, down in the comments. Please help me clearing this and I would be gratefully for your help, Thank you.

I am a new bie into APPIAN.would like to know how  we can create CDT and access the COlumn from DB

when I used a!pickerFieldUsersAndGroups() in filter .It gives error during selecting Group  Error:-- cannot apply [EQUALS] to field [assignee] when comparing to value [TypedValue[it =5,v=414]. what operator should I used for it

HI All, I am posting this question out of curiosity. As we know Appian is coded in Java.  I am just thinking is there a way to fetch the Appian Reports in my Java Application ? Like if there is any Java Class/package that appian provides or something ? I have found something here: https://docs.appian.com/suite/help/22.4/api/com/appiancorp/suiteapi/process/analytics2/ReportData.html But just want to check is this something feasible ? Thanks

I know we can check the resolution of the tablet if 'TABLET_PORTRAIT' or 'TABLET_LANDSCAPE' by using `a!isPageWidth({ "TABLET_LANDSCAPE" })`. But You know there is no 'PHONE_LANDSCAPE' in Appian, how to do the same thing with the Phone?  Or can we get page width and determine what it is? Is there a way to do this? Thanks in advance!

Hello, I have a Web API in Appian which returns ~4K records of custom data type (each data type has 14 fields). I am calling it using integration object and then using it as a webservice source in record type.  Issue - - The Web API returns ~4K records successfully whereas the integration object response shows only ~500 records.  - Is there a size limitation for integration object response? - What is the workaround? Regards, Abhay