-
Recently active
Hello, I have a local variable that contains an array of text retrieved from an API Call as seen below: a!save(local!transactionList, { id: local!Transjsondata.GetTransInfo.TransInfo.Id, time: local!Transjsondata.GetTransInfo.TransInfo.Time, amount: local!Transjsondata.GetTransInfo.TransInfo.Amount, }) so let's assume for example that i have 5 items in my transactionlist, each with their own id, time and amount, how can I represent each item accordingly in a gridview in its own row? I tried the below implementation: a!gridField( label: "List of Transactions", labelPosition: "ABOVE", data: local!transactionList, columns: { a!gridColumn( label: "Id", value: fv!row.id ), a!gridColumn(
Hi Team, I want to display the single row of array data into multiple rows in read only grid. pls find the below screenshot. one invoice reference number multiple order items in database, but i want to display one invc numer and one order item 1 row. Again, same invc number second value vale of order item number 2 different row. pls refers first row data. Thanks, Nagesh
Hi Community team, I have an requirement to fetch all the Schema Names and their associated 'Table Names with their Sizes' to display them in the appian interface. In order to achieve this, From the cloud database I have executed the following SQL statement which gives me the output: SELECT table_schema as `DB`, table_name AS `Table`, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS `Size` FROM information_schema.TABLES WHERE TABLE_SCHEMA IN ("Appian", "SchemaA", "SchemaB") ORDER BY `Size` DESC; On executing the result: EX DB Table Size Appian data 30.56 Appian example 28.52 ScheamA customer 3.52 Appian document 3.52 SchemA CaptureDetails 2.64 SchemaB Controls Library 2.52 Similarly, I'm trying to implement the same functionality in Appian using Query Database Smart Service in Process Model, on the set-up tab I'm able see only one schema(Selecting Pre-defined schema ) details: Instead of that I need to retrieve a
Want To fetch the data more than 5000 . let me know how to fetchrule!PPO_qrtName( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 7000) ).data,
Hi Team, I want to export read-only grid data to excel with headers, pls find below snap. Thanks, Nagesh.
Hi Team, In Excel sheet, as per rows I want separate BoxLayout with the separate entries into it. For Example, I have a 3 rows with column firstname, lastname and city as per first row of data I want to put in 1st BoxLayout, 2nd row of data in 2nd BoxLayout, 3rd row of data in 3rd BoxLayout without hardcoded. I am getting 3 seperate BoxLayout with column name firstname, lastname and city that I am satisfied I am getting in UI but result for all the rows of records in excel sheet is showing in all the three BoxLayout not showing in 3 different entries in 3 BoxLayout. So if you can suggest it how to do it per records will having seperate BoxLayout with rows of records in excel sheet? I am sharing a screenshots for reference In 1st BoxLayout data would come firstname - rakesh, lastname - sharma, city - mumbai In 2nd BoxLayput would come firstname - rahul, lastname - dongre, city - gondia In 3rd BoxLayput would come firstname - priti, lastname
What could be the possible fix to the below issue. 8 calls, 1199 ms peak average, 0.0% of total
How to insert tiff file into Word Document using ADT?
Hi I am querying a record type to get usernames. I am getting all the records except one record. There is no such filter too. I also checkd whether recordtype is syncing or not. It is also syncing properly. The usernane is also in the record type and database table. What can be the reason? Please suggest a solution.
Hello Team, I received a health report indicating a risk related to the extensive use of SAIL contexts in record views, related actions, and reports during the period from December 1, 2019, to January 15, 2020. This issue is present in an interface that originates from a process model. Within this interface, all code appears to be handled by a load function. I'm uncertain about what changes need to be made to address this issue. Additionally, could you please clarify the significance of the mentioned date range (2019-12-01 - 2020-01-15)?
Hello, I have used the smart service "Import Excel to Database" to import a huge Excel Data(200 rows and 150 columns) into a table. Issue 1. When we add more than 10 columns to import excel to DB we are getting an Error (conn=935099) You need to set exactly 15 parameters on the prepared statement. Issue 2. we tried Importing 10 columns from excel to DB, even though we have 100 rows in excel, it was importing 20,000 null rows in DB. Could any one help me with these issues, Thanks Gopala Krishna Raju
I am trying to make a simple app for IOS and am running into an issue with the provisioner tool not working due to not having the paid Apple Developer subscription. Are there any work arounds for this that could be recommended?
Hello, We are trying to integrate with a client's external system to send notifications and, when we send documents attached to the notification, they arrive corrupted. As I mentioned, to send the notifications we need to call an external system and the request body has 3 parameters. One of them must be in base64, which originally is an XML that contains the notification information (body, recipients, attachments, etc.). The XML code is the follow one: concat( "", "", "", /*(Opcional) Indicar si se debe realizar la comunicación solamente por una vÃ%ADa de envÃ%ADo: SMS, EMAIL, PUSH sin contingencias*/ "EMAIL", "", "", ri!codigoPeticion, "", /*Destinatarios*/ joinarray( a!forEach( items: ri!arrayDestinatarios, expression: char(10) & "" & fv!item & "" ), "" ), "", ri!asunto, "", toHtml(ri!cuerpo), "", if( a!isNull
I've got this 'Expense' record type, and I've set up two event tables for it — 'Expense Event History' and 'Expense Event Type'. Now, I'm looking to make a user filter within the 'Expense' record type. I want the filter options to be based on the 'Expense Event Type', so when I pick one, only expenses with that event type as their latest event will be shown. The issue arises when selecting event type 'Pending'. Due to the 1-N relationship, the a!queryFilter exhibits an 'At least one' filter behavior. https://docs.appian.com/suite/help/24.1/fnc_system_a_queryfilter.html#%22at-least-one%22-filter-behavior Consequently, the list displays expenses with their latest event being event type 'Pending' (first row on the image), but it also includes expenses that have ever had events with event type 'Pending' (second row on the image). Could you suggest a workaround or alternative approac
We have a request to keep a task open for longer period of time say 6month - 1 year , what are the best practices we need to follow for this case , suppose subprocess run with MNI and creates 100+ task and each should be alive for more than 6 months to one year , please advise what are the best practices we can follow ?
I created a Web api and tried to use it in Appian Integration of same environment but I am getting time out error, how can I resolve the issue. The web api is of POST method with startprocess. The process model is triggering but I am getting below error in Integration
I have a record type that has been deprecated. I'd like to drop the table from the database and rename the record type to start with DEPRECATED; then disable data sync and disconnect the table. However this record will become invalid and fail to deploy. What's the best practice?
Hi, The below line of is working in "Expression Mode" and when I click on "TEST" button during development. But, when I saved and test using browser, I am getting an error like {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}.Any suggessions please. a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "download doc", link: a!documentDownloadLink(document: fv!item.document) ) } )
Hi All I am calling one web service through Appian Integeration and getting the below error. <soap:Envelope xmlns:soap="">schemas.xmlsoap.org/.../faultcode><faultstring>Error transforming the soap request to be processed</faultstring></soap:Fault></soap:Body></soap:Envelope>"(Text) While calling through postman it is working completely fine. The reuqest that I am sending is the same as in Postman. Please refer the below screenshots. Many Thanks in advance. POSTMAN REQUEST
We are trying to convert a docx file to html, I my initial thought after failing to use the DOCX to HTML plugin was to try and use the HTML Doc from template smart service. We would upload the docx file and save it, use the smart service by reading the docx file using an expression, then finally using the smart service to save it as an html file. We ended up getting something odd instead in the file. Any help will be appreciated.
May I know how to enable the second option in the assignment tab telling this node will run as an unattended activity.thanks
Hi Everyone, I have Timestamp field(TS_LOAD) like you can see that below which is coming from a cdt in one of the process model and that Timestamp filed is Text in that cdt i written an expression to convert that Timestamp field to user's timezone as you can see below and i passed below expression rule to one of the sub process which having above column to convert as below But i am getting the data as below highlighted like it is converting to GMT Note: System time not in GMT as 2nd picture is coming in PST/PDT based on input and default time also in PST in Admin console. And I don't have any in between nodes and not manipulating data any where in the process only taking the timestamp filed and used in that expression rule and getting the out put data. Can anyone help me on this?
KalaKrut Platform needs to build a full-fledged web2/web3 community based marketplace app using Appian (site and portal). We are an artist-centric, community-based social hybrid platform for the music and events industry involves a blend of social networking, content creation, collaboration, and promotional features including common industry specific workflows. In addition, the platform has its own workflows for creating, managing, scaling the community and making policy, guidelines and rules along with many business workflows for rendering it's gamut of services. Presently our community strength is 90+ members plus few associate members. Our extended non-member community is very large. Due to disparate data sources involved in this business domain we need to integrate processes into a single or a few apps. I would be grateful if someone from support or community could share insights into how we could qualify for long-term full-featured free-tier access to app developmen
I am using the Encrypted Text field to store a user's Social Security or National ID Number. When I enter data into the field, I get the following error message. Expression evaluation error [evaluation ID = 82d04:b4023] in rule 'pmso_createorupdatespeakerpersonalinfo' at function a!encryptedTextField [line 82]: An error occurred while executing a save: Could not cast from Encrypted Text to Text. Details: CastInvalid. The SSN is stored as a text field in the Record Type PMSO Speaker. The record is stored as a Local Variable until committed to save by the user. Here is the code for the field a!sideBySideItem( item: a!encryptedTextField( label: if( local!isUnitedStates, "Social Security Number", "National Id Number" ), labelPosition: "ABOVE", placeholder:if( local!isUnitedStates, "-- Please enter your Social Se
Hello All, I have a requirement where we need to delete rows based on array's of arrays(nested arrays) when i tried to implement the logic and try to delete the rows i'm getting the below error message as shown. Can you please let me know what could be the best solution or approach to achieve this requirement. CDT structure: Delete code: Error screenshot:
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.