-
Recently active
hi all, We have a view for bar cart field which recently bracked in prod due heavy volume of data approx (1,048,576) records in my sql db . so we plan to query data going with sp with (executestoredprocedure) function. my question is can we query data in a barcart field with SP ? while executing SP with mandatory parameters getting error as "Use the Execute Stored Procedure Smart Service to modify data. This function must only be used to query data, not modify." if i pass optional parameters also getting error as "The conversion from UNKNOWN to UNKNOWN is unsupported". Below is the code for SP, a!localVariables( local!sp: fn!executestoredprocedure( cons!DATA_SCOURCE_NAME, cons!TASK_GRAPHIC_SUMMARY, { { name:"assignedTo", value:ri!currentUserEmail }, { name:"categoryName", value:ri!categoryName }, { name:"lob", value:ri!lob }, { name:"assignedcategory", value:ri!assignedcategory },
Hi All,I am facing below issue while trying to passed formatted json (a!fromJson()) data as parameter and again converting same json date using a!toJson() format at that time of passing the parameter. Please find the below code sample and share me if any solution. step1- Finding enter json data local!jsonData: if(a!isNullOrEmpty(ri!jsonData), {}, a!fromJson(ri!jsonData) ), step2 - Binging with local variable local!exceptionResults:property(local!jsonData, "ScreeningSummary", null), step3- Passing the local variable with using a!toJson to child interface (rule!PM_ScreeningExceptionSummary) rule!PM_ScreeningExceptionSummary(a!toJson(local!exceptionResults)), Step 4- Binding Json preparties within the Appain ready only grida!localVariables( local!exceptionResultsFound: if( a!isNullOrEmpty(ri!exceptionResults), {}, a!fromJson(ri!exceptionResults) ), { a!sectionLayout( label: "Exceptions", labelSize: "SMALL", contents:
Hello everyone, I like using record filters and record view. Some of the fields in my Record Source are however decimal/integer and Appian offers only filters for Date and List of Values. Both is pretty much useless when it comes to Numbers. What would you suggest use to filter these? Ideally, there would be some number range selector similar to Data Range, with 0s filterted out as default option. Of course, I can set up my own field that would filter the record data based on filled in value, but that would greatly hinder the record filter functionalities, and I would need to use custom interfaces instead of Record Views. Thus, looking for a better solution.
I would like to be able to pass the ALL the data for a selected record (using the data type for the individual record) to a related action. However when I try, I get the attached message. Is there a way to do this? It is possible to pass rv!record to a record view, for example.
Hi, I have an interface with a read-only grid. I am loading the data into read-only grid using RECORD TYPE and also I have used selectable, selectionValue, selectionSaveInto properties. I would like to implement delete functionality, where I need to allow multiple rows to be selected and click on "DELETE" button so that those selected rows of data should be deleted from the database table.
Hi All, I need to pass a Safe URI to source parameter of webContentField component and that URI is generated using web API. Problem here is when I am using the URI generated from web API it throws below error: "Interface Definition: Expression evaluation error at function a!webContentField: A web content field [label=""] has an invalid value for "source". Source may not be an internal Appian source. Received: mydev.appiancloud.com/.../YoU0wA." How can we pass the URI that is Internal to webContentField? Thanks in advance Regards, Trunal Jain
My Appian Timezone is set to Pacific time Below functions are returning correct time now() - 2/20/2023 5:40 AM PST datetime(year(now()),month(now()),day(now()),hour(now()),minute(now())) - 2/20/2023 5:40 AM PST However, when I try to create datetime where I want to change the date and time acc to my preference, the timezone offset gets added. datetime(year(now()),month(now()),day(now()),0,0) – 2/19/2023 4:00 PM PST I want the output as - 2/20/2023 12:00 AM PST Requirement for which I want to create datetime in specific timezone. Now I want to create a datetime so that I can use it to filter the datetime column stored in DB I need to fetch all rows from DB where the createdDate is say 2/20/2023 so for that I thought of creating a query filter as Date between (2/20/2023 12:0AM PST and 2/20/2023 11:59 PM PST). However I am unable to create datetime in particular time zone
Hi all. I'd like to know if Appian can be integrated with a versioning software like CVS. The goal is to store each Appian component version with the ability of identify who modified a component, what changes are made and recover old version. Thanks in advance.
I am trying to Execute a SP from Query database Smart Service in Process model and getting a Timeout Error.I wish to Handle the Process flow and not let the Process stop immediately and continue the Exception path. Note : i cannot use Execute Store Procedure Smart Service as my SP is taking longer than 10 min.
Hi, I have 2 groups one is parent and child. Parent grp having test users and second grp having SSO users. How do i show users from both groups in user picker. I can’t merge or delete groups. Client having thier own way of handling these grps. Thanks
Out of curiosity - has anyone implemented Search capabilities in Appian for Homophones?E. g. searching for a user in a database field for names, typing in 'Fill', Appian will search also for 'Phil'. Thanks
Hi all, The title basically describes it. I'd like to be able to apply filters on a list of maps on their key values. For example in the code snippet below, to be able to set filter("name","=",bill) or filter("name", "not null"). Similar to a!queryEntity but for a collection of map instead of a Entity a!localVariables( local!mapCollection: { a!map(name: "bill"), a!map(name: "bob"), a!map(name: "Jim"), a!map(name: null) } ) Also be able to apply operands like and and or if there are multiple key values in the map collection
Hi, As per my requirement I had to make use of the plug-in called "Twilio" for sending SMS to the users to authenticate them. I also created an account in Console Twilio in order to get the tokens to establish the connection. And I managed to get the URLs of first 4 fields like the Account SID, Authentication Token, API Key SID, API Key Secret. But I am unable to get the path for the remaining 3 fields which are TwiML App SID, Workspace SID, Chat Service SID. Can anyone help me out how to configure the remaining and from where can I get the URLs of those particular fields. Thanks in advance, Gousi.
Dear community, within our project we have the requirement of full traceability from a work-item in azure devops to the actual code changes. Are there best practices to do that within the Appian environment or possibilies which would allow us for example to force the user to enter a description before he can save an object, automatically export the objects from Appian via a Rest-Api and then commit them in git ? Thanks, Patrick
Hi Champs, I have a use case where I don't need to show the related action in a record related action tab ; but I need to call that related action of a separate interface. the reason for doing this is I have to call an interface in a popup/dialog ; which can only possible in related action. Is it feasible to do so ?
Hi Everyone, I am calling the expression rule from the interface through button widget using startprocess and the process model calling the rule in the script task. But the rule is not executing. Can anyone please help me how to achieve this? Thanks in advance!
Hello All, We are using 1 PM in which we are using the smart service "Execute Stored Procedure", We are having 10K+ data in the staging table and we are using the batching logic to trigger the stored procedure for 1000 batch. Th stored procedure function is to get that batch start and end index as parameter and fetch that much data from the staging table and run different sql queries , insert data in the different table. The same sub process I am using multiple time but when 1 is ending I am triggering another one, not running all parallel. I am getting wired error in some batch running after 7000 or 8000 data. The error: "An error occurred in executing an Activity Class." Not getting anything in logs as well. Sharing the screenshot of the error aslo. Let me know how to resolve this issue. Thanks in advance.
Hi! I have a process model which creates a XLSX file, which I want to convert 1:1 to CSV. But I have 2 problems: 1. The columns don't get separated and are written to the same column, where attributes are separated by commas. 2. For some reason even having only one row in excel, it continues to read until row 95, so I get 95 rows full of commas. Screen:
Hello, I am trying to randomly sample x amount of rows from a CDT by generating x random numbers in the range 1:length(myCdt). The issue I am getting is that some of these random numbers are repeated. Is there a way to generate random numbers in a given interval and have them be unique? Here is what I have so far: local!randomNumbers:if( length(local!query)>15, 1+ tointeger(rand(15) * length(local!query)), local!query, ),
Dear Team, I am experiencing an issue with synced record types while deploying package from dev to Test environment. Issue: Error validating source for synced record type - APNX-2-4195-000 Possible Root Cause: Data source for record type is different in dev and Test. Alternate Solution: I can able to deploy the package, However i need to open the record type in target environment and change the datasoruce. Comment: Our deployment will not to do above mentioned alternate solution in each higher environment. Please provide any other possible solution. Tried options: I tired modifying the .xml file with target datasource, but when i select the package it says, package is invalid.
What is the best practice for naming a datasource in Appian? In DEV, UAT, PROD can what should be the name of datasource be provided?
How everyone, I have the requirement to merge two or more rown in a grid. An example is shown below: Col A Col B Col C 1 2 ab cd 7 9 yz If the value of col A and col B are same for two rows and Col C value is different then both rows for col A and Col B should be merged. Thank You
Hello everyone, I'm just starting learning to work with Appian, I'm currently doing the Developer's Path. Today I encountered a problem that seems very simple. I just can't add Rule Inputs while creating a connection to an API I tried clicking in edit as an expression, but I'm just getting this Thanls
If there is any expression evaluation error on interface, how can we display that error on UI if want to show to user. Reason for error need to display on UI.
Hello everyone, I need to setup the possibility for user to access through MFA, like username + password and code received on the phone or on an app like google auth. Is there anyway to do that on Appian?I know about SAML but, for me, it isn't clear if it works only with identity provider or with other methods. I work with Appian Cloud Version. Thanks for your attention. I'm looking forward to your reply. Daniele
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.