-
Recently active
Hi In below query rule i am passing 2 and 3 product ids so it was returning both 2 and 3 product id's email id's but i want 2 product id email ids in one list and 3 product id email ids separately means like two list of usernames separately could you please suggest on this
Hi, I have a case in our application where we consume data from pulsar via Pulsar Message Consumer, but what I noticed is that record type for the table which we are storing the data is not synchronizing automatically and after researching I saw that not all smart services can sync the record automatically. So, my question is: can I add a Write Records node after Pulsar Message Consumer node so that the record will be synced, and if not what can be the best solution to this as scheduling a full sync is not an option because the process runs every 30 min each day, and we can schedule a full sync once a day. Thank you
when i pass the value to the code am getting below error if( null(ac!convertWord_txt), "zero", convertnumbertoword( trim(split(ac!convertWord_txt, ".").[1]), "" ) ) what might be the issue here
Hello everyone! Is there a way to get rid of empty lists? I attempted to use `reject(a!isNullorEmpty, RESULT)`, but I encountered the following error: (Image 2). Image 2
Hi Team,Can anyone explain detailly 1.why we should not use continuous gateways in process model and 2.why we should we need to add a dummy script task in case of looping or in between the continuous gateways with a example scenario for each one of the case?Thanks in advance!
Hi We have just upgraded the Appian version from 21.4 to 23.3 and we have an issue with the date format exported to excel coming from record types, in the prior version this issue was not happening, does anyone has experienced the same issue? 21.4 version-correct format 23.3 version - incorrect format by looking the format in the excel is taking it as if it was a text but this is the logic behind the date column: if( a!isNullOrEmpty(fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime']), todate(null), todate( text( fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime'],"mm/dd/yyyy hh:mm AM/PM" ) )) we are just converting the date and time to date and when we do that the format gets reflected as text in the excel which was not happening in version 21.4
.Base64 Document Database Integration Smart service - will help to achieve conversion of base 64 to image ? link: https://community.appian.com/b/appmarket/posts/base64-document-database-integration#:~:text=Provides%20the%20following%20two%20smart,agnostic%20and%20supports%20dynamic%20queries.&text=Get%20Base64%20Document%20from%20Database,document%2C%20returning%20the%20document%20id.
Hi All, Please help me out in understanding this error . Error message: Internal Error
i made sure the certificate matches the api, and is valuable error-result-guidance Failed to connect to hhtps▬▬▬▬▬▬▬ Certificate for <10.▬▬▬> doesn't match any of the subject alternative names: [MW▬▬.pem]
I am successfully using "Receive File Over SFTP" to retrieve a file from a folder. When I use "Get Remote Folder Contents" to see the contents in the aforementioned folder, I get the error "No such file". Any ideas?
Hi All, Facing "could not cast from list of Map to Dictionary" error while calling a!startprocess in interface, could you please help me in resolving the issue. Created a portal to capture the vehicle details in an apartment, after data entry and after clicking on "Save" facing this error and this is developed for hands-on purpose only. Pasted error and code for your reference. "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = WBZTQ] : An error occurred while executing a save: Expression evaluation error at function a!startProcess [line 438]: Could not cast from List of Map to Dictionary. Details: CastInvalid" a!localVariables( local!residingOwner: true, local!tempApartmentName: "Dollfine Durga County", local!successMessage: "", a!sectionLayout( label: if( ri!isUpdate, "Update Vehicle Details", "Create Vehicle Details" ), contents: {
Hi, For my requirement, I have multiple rows with radio button field in the grid. The selected radio button values are saved in local variable and that local variable value is stored in the rule input variable {CDT Type] on click of save button. The rule input contains 5 fields, where 4 fields are copied from the local variable and one field is not copied. Could anyone help me on this, Local Variable: Rule Input: a!localVariable( local!listQuestionAnswer: a!forEach( items: (Fetch Data from DB), expression: { id: null, question: fv!item, answer: "No" } ), local!questionResponse: { a!forEach( items: local!listQuestionAnswer, expression: { answerId: null, answer: fv!item.answer, questionCode: fv!item.question.questionCode, jobTYpe: ri!jobType, jobId: ri!jobId } ) }, { a!gridLayout( headerCells: { a!gridLayoutHea
Hi, We have to retrieve the third party credentials from an external repository but the client doesn't want developers (not even administrators) to have access to these credentials. We know that credentials in the connected systems are masked: And we also know that values can be masked in Third Party Credentials (but this has to be done manually by an administrator): Does anyone know if this can be done dynamically or if there is a way for developers to not have access to these credentials? Thanks!
Hi In Record related action context i have passed like this to get request id details from query rule!Cust_QE_getRequest( requestId:rf!requestId, returnCastedData: true) when i am trying to access related action getting error like below could you please suggest on this An error occurred while applying the context for the MHK Data Case related action [identifier=1,356]. Details: Could not cast from Check_testRequest?list to Dictionary. Details: CastInvalid
Need to implement the recurring for a task, so that it will be auto triggered. So, for that is there any way to implement the scheduling options as in the backend for input task from interface?
Hi All, I have noticed this behavior when we are passing list of nulls to a!isNullorEmpty it returns false. I know there are ways we can handle this but is this something fundamentally wrong with this function or not. (I know it is hundred times better than isnull() but still curious)
Hi all, I'm currently looking into using Appian records for the first time, and had a question (I've tried looking through the forums and documentation). When you configure a record list action to call a process model, is it possible to provide multiple parameters to the process model from the interface where the record action is being called? For example, I have a grid that's displaying record data. I'm trying to configure a record action, which calls a process model, which requires multiple process parameters to be passed in to it. When looking at recordActions, I see it takes in a list of a!recordActionItem(), but these only seem to consist of an action and an identifier. I know there's the option to provide static values to the process via the context field of the related actions in the record type, but if I have a local variable (for example) in my interface, can I pass it to the process model being called in the record action? I hope
a!documentViewerField( label: a!defaultValue(value: ri!label, default: "Document"), labelPosition: a!defaultValue( value: ri!labelPosition, default: "COLLAPSED" ), document: local!document ), Hello All, How can I open document in new window with the above code and the document names are in grid.
Hi, I'm trying to post a webhook on Autodesk which callbackurl is an Appian web API. The problem I have, I can't expose any Appian service without authentication, and on the post method I don't see any option where I can write an API-key or something similar, only the callbackurl. Is there any method where I can expose an Appian Web Api?
I just export data via Export to excel functionality of record type. Is it possible to add time zone stamp on "Exported On" field ??
Hi , Is there any course for Appian mobile development videos in community .
We are trying to compare to one intake value with data that is coming from another system. Both these values are present in pv and we are using contains function inside a script task to check the same. But even though the value is present in array, its giving false. Array value Single valueBoth are of same data types but still giving false. contains(arrayValue, singleValue) is the function being used inside a script task. Let us know if we are doing something wrong here.
I have a very basic question:What is difference between passing an input data vs output data in a script task? Or perhaps an example or a scenario where both can be used? Thanks in advance [emoticon:c4563cd7d5574777a71c318021cbbcc8]
Hi, I wanted to return the rows from cases table which are not in mail poller. But for somereason the following query is not giving me the expected result. Can someone help what mistake I am doing here. SELECT * FROM `Cases` WHERE `fk_caseTypeRef_id` = 53 and case_id not in (SELECT fk_case_id FROM `MAIL_POLLER`);
Hi everyone can anyone help me how to collapse a section by using FitNesse script Thank You
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.