-
Recently active
Is there a way to get group type Id by group name?
can someone suggest how to implement like this table in the interface. displaying headers only not getting.
Hi Experts, I need your help! I trained an AI skill to extract data from PDFs and the model is trained with 91%recall. In the process model I am getting an error: This operation is not supported in Extract from Document node. Need your help in this regard. Unable to identify the cause of the error.
Hi, I am using a query to fetch data based on date selection from the table in the SQL server. since the data volume will increase, I have already broken the date selected into 15 days period and then fetched the data to optimize the query. Also to optimize it more only the required fieldlist has been passed in the parameter but it was working fine till some time and now when the data volume has increased, it throws an error. Is there any other way of Optimising? The query used is: rule!NGS_queryEntityRefresh( dataStoreEntity: cons!NGS_DSE_FACT_ENGAGE_ACTUALS_QC, returnType: ri!returnType, fieldList: { "scoreTotal", "operationsCodeId", "jobRoleId", "supervisorId", "managerId", "evaluatorId", "evaluationDate", "internalEmpId", "callDate", "customerServiceQcScore", "contentQcScore", "evaluationForm", "opsRole", "evalSuperviso
Hi, I'm trying to import a CSV file into a PostgreSQL DB. Customer requires all data from appian must rely on that DB which is connected as datasource. I'm using the plug in Excel tool and the Smart Service Import CSV to Database. I got the following error from stdOut log: ERROR ImportCsvToDatabase8 Error executing SQL org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 17 From database, i turned statements log on and i found out the following statement: 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:ERROR: syntax error at or near "," at character 17 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:STATEMENT: select `field1`, `field2` from `table` where 1=0 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:LOG: execute S_1: ROLLBACK I'm running the same statement on my client in Postgres and i got the same error of course. What I found out is that backtick is cau
I have a form where I have signature field like below and when I am clicking the draw signature button the dialouge box opens like below here it is hiding the below 2 fields I want like the dialouge box will open in between the sign field and the two fields . can anybody help me in this please ?
I am using the LDAP tools application and reieveing the following error [Appian Work Item - 323 - WorkID 69 - execution02 - process 2098658 - model 65 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugins.directory.syncwithusernames.service.SynchronizationService - Error while conducting name search: javax.naming.PartialResultException [Root exception is javax.naming.CommunicationException: DomainDnsZones.eg.Albaraka.local:389 [Root exception is java.net.SocketTimeoutException: connect timed out]]
I have created a "CRD column" in process report which is required to take the data from "CRD column" in User database table. I tried querying the data and indexed it but it's not populating the column with data in the process report. The column is populating null. Please suggest me alternate solution so that I can achieve this data populating. index(rule!CP_QRY_User( username:pv!username, returnCdt:true, pagingInfo:a!pagingInfo( startIndex:1, batchSize:1 ) ),"crd",null) i was using this expression to get data for respective column in CRD defintion in the process report.
Hi Everyone, We have Reassign, Reject , Accept buttons provided by default in Appian. It is inside a User input task. Since it is a default button we couldn't able to run any rules or write any code to store the value for the buttons. Eg: If we click on "Accept" button tp!owner is changed but we can't store the value in a table. Similarly if we click on "Reassign" and "Reject" the values are captured in task level but we can't store the value in a separate table. Is there a way to capture the actions in the backend or generate any report for admins or others to know the actions performed by the user? Thanks
Hi Everyone, We have a requirement where we use OAUTH2.0: Authorization code grant and once we click on Authorize, A new browser tab opens and an after logging into the external system, an URL comes in the search bar of the newly opened browser tab. Is there an way in appian to read the URL and fetch it into any variables,once authorization is successful. Thanks Rupa
Hello, Need an input if there is way to connect Appian and AWS cloud search. Thanks in Advance
thank you always.I'm getting an error when duplicating a process model.I tried 2 patterns.① If you create a new object (duplicate an existing one) from the object list, the action will fail. (A message will appear stating that the requested status is invalid)② Open the process model to be copied and select "Save As". At that time, the draft will be displayed as a process model, but an error will occur when trying to publish it. Also, some rule inputs were deleted at this time. Even if you save from the process model screen, it will not be displayed in the object list. Does anyone know what is the cause when process model replication fails?Thank you. いつもお世話になっております。プロセスモデルを複製するとき、エラーが発生しています。2パターン試しました。①オブジェクト一覧から新規作成(既存を複製)を行うとアクションが失敗します。(要求されたステータスが無効、というメッセージが表示されます)②複製元のプロセスモデルを開き、「名前を付けて保存」を選択します。そのさい、プロセスモデルとしてドラフトが表示されますが、公開しようとするとエラーが発生します。また、この時一部のルール入力が削除されました。プロセスモデルの画面から保存した場合も、オブジェクト一覧には表示されません。 プロセスモデルの複製に失敗するとき、どこに原因があるかご存じの方は居られますか?よろしくお願いいたします。
We have many objects and Applications, sometimes I know the object name, but can't locate to which Application it belongs to. Is there anyway I can find the belonging Application easily?
I want to get the diff text between expression rule to integration some automation flow. Do Appian exposed any API to support such? Or is there any API could get object source by version?
Hi Everyone, I am querying the db table through query record type. This query gives the list of db records. When I am using this in interface and using index to get the particular field, it gives this list of particular field. In case of null or single it also gives list. Can anyone please help me when it is null or single value should not give list.
id 1 group Mailing Task Storage Assignee refId Name 1 John Doe 2 Jane Doe 2 group Mailing Task Reminder Assignee refId Name 1 John Doe 2 Jane Doe Hi I have 1 to many relationship between Group (level1) and Assignee (level 2).. I want to update update and save the the name in Assignee.Name. I have been using these one below and it did not work a!forEach( items: {"John Doe 1" , "Jane Doe 1", "Sam Doe 1"}, expression: { a!save(ri!group [recordtype!group.relationship.Assignee.Name][fv!index],fv!item), } ) but it was not saved or overridden the Name Field. i'm looking to save the output like this. id 1 group Mailing Task Storage Assignee refId Name 1 John Doe 1 2 Jane Doe 1 Sam Doe 2 group Mailing Task Reminder Assignee refId Name 1 John Doe 1 2 Jane Doe 1 Sam Doe could you please help?
Hi All, I have an in integration object which its currently returning successfully a file.gz , can anyone guide me if possible on a way into actually downloading this document?any suggestion helps thanks in advance
I need an Expression Rule that has an or condition for a filed. I have a list of clergy assignments and I need to pull all current assignments and those that terminated over the last year. The record type, CPMA Clergy Position has a termination date for the assignment, clergyPositionTermEnd which is a date formatted field. If the assignment is for a fixed term, then there is a future date in the field. If the assignment is a permanent assignment, then the field date is null. The or function would look like this. or( RecordType!CPMA Clergy Position.field.clergypositiontermend >= today()-365, isNullOrEmpty(RecordType!CPMA Clergy Position.field.clergypositiontermend) ) However, I do not understand how to use this inside an Expression Rule. My Expression Rule using the queryRecordType function looks like this. if( a!isNotNullOrEmpty(ri!clergyId), a!queryRecordType( recordType: 'recordType!CPMA Clergy Position', pagingInfo: a!pagin
What’s new in Appian 24.2? See how the latest Appian Platform features can help you: Improve any process and inform any decision with Appian Process HQ. Easily add generative AI to your processes with eleven new AI Skills using an embedded Large Language Model (LLM) powered by a collaboration between Appian and AWS. Streamline tedious development tasks with AI Copilot. Register to join live or get the recording: May 16 at 12:00 p.m. EDT (Americas) May 16 at 12:00 p.m. BST (EMEA) May 17 at 12:00 p.m. AEST (APJ)
Hi Experts,We have a requirement to get files from SFTP server and put in Appian Doc repository.The input we have received from client is that these files size can vary from 1MB to 1GB as there are multimedia files as well.What will be the recommended approach for meeting this requirement. Is it going to cause any impact on the performance of the server or not.What if total size of the files being moved to Appian doc repository exceeds 100 GB.In my assumption we will have to consider our existing cloud storage and request for extra if required. Is there any other server level configuration needs to be done and how can we manage memory in this case? Thanks.
Hello, guys. I am wondering how can I craete a component that has a button to copy its text content to the user's clipboard. I would like to be able to copy the rich text's content only. a!columnLayout( contents: { a!richTextDisplayField( label: "Lorem Ipsum", labelPosition: "ABOVE", value: { "Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt." }, marginBelow: "NONE" ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Copy to clipboard", submit: false, width: "MINIMIZE", style: "LINK" ) }, align: "CEN
Hello Team,I'm using a MNI startprocess with the Run one instance for each item in pv!array (spawn all) along Run all instances at the same time(move when All instances are done), in process parameters I'm sending pv!array[tp!instanceindex] to another process.In one scenario I have only one element in pv!array, but it triggered 2 instances for the same data. Could anyone explain me why this happening?[mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]
I have a list of integers from 1 to 100 and i want 30 random numbers from that list how can we do this?
Hey developers, I would like to send an email to a client if their balance reaches a limit. How can I do that? Is it possible to set a condition on the balance in the interface definition and then trigger a process model that sends the email?a!localVariables( local!emailSent, local!button :false(), a!sectionLayout( label: "", labelColor: "#000", contents: { if( ri!account['recordType!{b37748b2-8103-41ea-8028-2b358e4f229c}PBY account.fields.{4a9de4b2-f127-44f1-86d2-21c2a6b2ee2d}Solde'] > 20000000, {}, { a!buttonLayout( a!buttonWidget( label: "Voir détails", value: true, saveInto: { local!button, a!startProcess( processModel: cons!PBY_sendEmail, processParameters: { account: ri!account, }, onSuccess: a!save(local!emailSent, true),
If it's CDT rule input, we can give "{}" simply to provide test values. For recordType! rule input, how to provide value?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.