Foundation

 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:

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.

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.

I have configured a start node that with a receive message trigger that essentially captured information from an email. I have configured all the proper fields but I the "Attachments" field does not seem to work. Documentation has not been particularly helpful in this case.  I have a PV of type Integer that can also handle multiples and the following is mapped to that PV: property(msg!properties, "Attachments", null) When I send an email to the process using its UUID, it captures all the fields correctly except for the attachments. Is my configuration incorrect?

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

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, ),

Hi Champs, I have a requirement where I have to show the record related action in a link format along with the helptooltip/description (whichever is fine). I am using a!recordActionField to achive the same as I have to open the interface in a pop-up. but in the same component there is no helptooltip available. What is the alternative approach for the same. I need something like this I can see in Appian related action it shows in this format. Not sure how they have  done this.

Hi Team, just got this Requirement So when i click the Collaspe all button The box layout which is below should get Collapsed. Any one can help me with this I made like after clicking this button a local variable is changed to true and after that i wrote that in iscollapsible condition but not working

created web api with below code but getting below error local!entities: a!queryEntity( entity: cons!TI_FINALEXCELTODATABASESTORE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 50 ) ), fetchTotalCount: true ).data, An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TIFinalExcelToDatabaseDT7969], query: [queryentity expression], order by: [[Sort[null asc]]], filters:[null])

Hi Team, By mistake few tasks are cancelled and i want to generate a report on tasks cancelled per user. Can you please help me on how to generate this report Thanks in Advance

Hi there, One question here I have a URL need to be insert into email body. This URL will be different between DEV site and PROD site. I am trying to define a constant for this URL. but dont know how to insert it into email body, as "insert web link" does not accept constant. tried use using safelink in "Insert an expression". not good. Could anyone let me know how to do it? regards, Lin 

How to Start a process model with out start form or how write expressions for for button to start process model in interface

"java.lang.ArrayIndexOutOfBoundsException" error thrown while running parse Excel to CDT process

Hi Team, Is there anyway I can get rid of the DEBUG statements, it takes lot of digging to find the actual issue. Any help of this will be appreciated. 15:06:22.699 [AsyncHttpClient-1-6] DEBUG org.asynchttpclient.netty.channel.ChannelManager - Closing Channel [id: 0x352261bf, L:/127.0.0.1:65045 - R:localhost/127.0.0.1:55909]15:06:22.699 [AsyncHttpClient-1-6] DEBUG org.asynchttpclient.netty.handler.HttpHandler - Channel Closed: [id: 0x352261bf, L:/127.0.0.1:65045 ! R:localhost/127.0.0.1:55909] with attribute DISCARD15:06:22.704 [AsyncHttpClient-1-7] DEBUG org.asynchttpclient.netty.channel.NettyConnectListener - Using new Channel '[id: 0xb5d60450, L:/127.0.0.1:65046 - R:localhost/127.0.0.1:55909]' for 'POST' to '/session/38b062eefaf139bb0d755dcb873de4f4/element'15:06:23.097 [AsyncHttpClient-1-7] DEBUG org.asynchttpclient.netty.handler.HttpHandler - Thanks, Chandrakant Raju C

My rule input is of type document of CDT to upload excel file into the database.

In a interface I need to generate a certificate by clicking a button and in that same interface I need to show the document download link. can anyone suggest some ideas? Note: Clicking on that button will trigger a process model that will generate the certificate

I want to create an editable grid for each raw of read only grid and save. is there any way we can do that simply?

Hey Guys, I am using the a!recordactionfield in a separate interface to add the data. It contains card layout for each of the data we added. Is there anyway to refresh the page while submitting the data using dialog box option. All process model nodes are chained and when I used the "open in same tab" option it refreshes the data but from the dialog box it does not refresh. I also used the a!refreshvariable in the local variable in interface but it doesnot work.

Hello: I am trying to create an interface - similar to the Maintenance Request example in Appian but I would like to add a "Select" checkbox that is (vertically) aligned in the center with the text (in this case, 2019 Lexus E350).  Also, is there a way to include a check box without providing an option name since I would like the "Select Product" to be the column header.  I am creating a set of card layouts using a 'forEach() function. Is there a way to implement Flexbox layout - I went through the SAIL document but the search yielded no results. Thank you for your help. Ma

Getting above error how to resolve .. as value is null ..

Is there a way to use search filter in UI, where I'm fetching data from task Report

How can the email/name attached certificate that I earned when I pass the Appian exam?At some point in time I'll be changing my employer and I'll want to take my certificate with me by transferring the certificate/achievement to my personal email address/account. Does it change things if my employer has an Appian partner agreement?