Discussion Categories

Hello All, Facing an issue while deleting the data from the Data Store entity, we are using "Delete from Data Store Entities" smart service in the process model to delete the data. Error: An error occurred while trying to delete data. No data was deleted. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement Entity and pid of the entity is passed correctly. Appian Version: 23.4.265.0 Please advise if anyone faced this issue earlier and how to resolve. Thanks

Hi everyone, I am new to Appian, and this is my first question!  What is the difference between "Create Folder" type and "Knowledge Center" type under "New" -> "Create Folder" at Build tab of Appian Designer? How to decide which one fit better for an application?Thanks!

from appian application , i will send some emails addresses to  3rd party application , that 3rd party app needs to verify those email addresses and sends the email addresses ids back .  do i need use webapi or integration for this scenarios

All, i am struggling to read sites_usage.csv log files using readcsvlog() after 23.3,  is there any alternate way to read log files? 

I have created the ETP_SyncTreatmentNotes_Cloud9  Robotic Task on the dev environment and deployed this bot to the UAT Environment but I am getting an error.I have added a robot and updated the API key in the UAT Environment and permission tags.Error: Problems (1):roboticTaskDesignObject 53537fbd-9bfd-381e-808c-a345d855df37 "ETP_SyncTreatmentNotes_Cloud9": An error occurred while creating roboticTaskDesignObject [uuid=53537fbd-9bfd-381e-808c-a345d855df37]: java.lang.RuntimeException: com.appiancorp.rdo.client.invoker.ApiException: {"timestamp":1702553011435,"status":500,"error":"Internal Server Error","message":"com.appiancorp.object.remote.rtdo.rpa.CaughtException: The robotic task [uuid=656d7a2d28c21722eacbf58d] cannot be imported because the following required precedents are missing: content [uuid=656d7d3c28c21722eacbf590] cannot be found.","path":"/rtdo/DesignObjects/IX/ObjectImportSuppor

Hello,   Is it possible to set User Timezone with SAML assertion, For example we can set User manager, Office Phone or Custom Fields. Similarly, I need to setup Time Zone automatically without them to set it up manually from User Profile settings

We have an offline Form (primarily used in Appian mobile App) in which we need to provide an option to print the form (similar to browser print in mobile). In IOS device we are getting the browser print option but we don't have anything like that in Android devices.  Screenshot from IOS having print option highlighted in blue Screenshot from android where we don't have print option Could you please suggest how to incorporate this?

Hello All, Is there a feature like PEGA's Email Listener that accesses external email services and notifies them via Appian? What I would like to do is to have Appian notify or initiate a process when a value defined in Appian matches the sender of an email received by an external email service. Any clues you can give me on this would be appreciated.

v21.4 Cloud I am getting the below error when updating data of a synced record using a process that has Write to Data Store Entity nodes and Write to Multiple Data Store Entities nodes. [Appian Work Item - 773428 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.record.service.RecordReplicaUpdateService - Loading updates to synced record type(s) in ADS failed, invalidated record type(s): [(da0a35ad-c98f-40e7-975c-47ff016a2084,WMS Request)] com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. Issue identifier: [8d98eb66-d7a7-4786-b881-d48850c684cb] (APNX-1-4521-016) ...com.appian.data.client.AdsUserInputException: APNX-3-1000-030: Invalid transaction data. Cannot update the same entity multiple times in the same transaction. Invalid id(s): (100218067) This error is not covered in the docs so unable to find guidance on how to resolve it - docs.appian.com/suite/help/21.4/Records_Monitoring_Details.html#other-sync-er

In the above image i am trying to show the monthly trend of production time in minutes , but i need to show this in percentage , can any one help me with this?

Hi, I have a requirement to display the header and footer on every generated page of the PDF report through HTML I tried using header and footer tags, but that is not working

Hi All, I am facing this issue when trying to delete a row from a table in db. Is this error caused by foreign key ?

Good evening, First of all, the robotic task can access to the virtual machine and the agent turns blue which means that everything is working but...I'm struggling to find a proper solution to the error thrown by the robotic execution (as shown in the picture below). Does anyone know to fix it?

Hi What is the best way to convert it the time from 12hr AM/PM format to 24hr format as the users are getting confused and incorrectly inputting AM/PM leading to challenges. What is the best way then to represent this as a date and time picker in minute intervals for users. Thank you.

Hello Team, I have filter the date based on the function eomonth(today(),-1) i.e last day of previous month but the fitler has type of date & time where as this function will return only in date format.I have tried to add the time to the function but couldnt able to achieve the requirement as it throwing error of miss comparison types.please help.Thanks in Advance.Error : Expression evaluation error at function a!queryRecordType [line 3]: Cannot apply operator [LESS_EQUALS_THAN] to field [createdDate] when comparing to value [TypedValue[it=3,v=11/30/20236:08 AM]].    a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "createdDate" /* this is type of Date & Time */ operator: "

Hi everyone, I'm getting an error while querying data. Scenario here is logged in user will have multiple countries associated. so when user logs in we are fetching loggedin user counties and  passing the list of country id's to the view to get data. when user having upto 70 countries it is working fine but when exceeds it is throwing error. Can anyone please help me how to resolve the issue.  PFA image

How to Query a database values which exceeds the memory limit without any filters. Is there a way we can just type the first 3 characters and the respective values should be fetched?

Hello, I need to pass the yesterday's date and a specific time to a variable of dateTime type. Basically today I want to get all the data which is saved in database yesterday. How to achieve this? Thank you.

In an Appian paging grid, when clicking the "Preview" text in one of the columns, the goal is to display the data from the PDF document in another tab and provide an option for downloading. How can this be implemented in Appian?

Hi I have data type which have data with site id, site name, workingstartDate, workingendDate.  I want to create line chart which is for each day of month, nu of sites worked? how can i do that?

How can I show warning message in the top of the form I have two field one is region that is multiselected and another is geography that is single selection if I selected region like 3 value APAC,EMEA,NAM and after that I selected from geography NAM if both value are matched then warning message will be not shown if value are not match in both field then warning msg will be shown on the top of form

Hi All, I have a query that returns documents with a specific name, sometimes by mistake we will have 2 or 3 files/documents with the same name, I want to make sure that my query selects the latest one added instead of the first one that it finds, how can I accomplish this? Right now if I have 3 files with the same name it picks the first one added since its the first one the query finds. thanks in advance

We're developing an app that will be used on both Android and iOS via the browser. We have everything working for both mobile OS, but the Video Content Field is giving us some problems on iOS. We store some videos on Sharepoint and then play them on the app using the link of the Sharepoint file. This works on both PC and Android. But on iOS, no matter the video format (MP4 or MOV), it just gives us the video player in black with no option to play the video. The same video, on PC and Android, works fine. Be it an MP4 or MOV video Has anyone encountered this issue on iOS and has a way to fix it? PS. Tried using the Advanced Video Player plugin, and it gives us the same results. Also on Safari, Chrome and Firefox

I wanna practice on making process models. I want u people to give me Real Scenarios so that i can practice on it. 

Is there a way to customize the transient message, Action completed, after a form button (Cancel, Save, etc) is clicked?  For example, can we change the message to "Action canceled" after the Cancel button is clicked? Thanks.