Discussion Categories

Hi All, I have a requirement where I need to query with 40k input and output will be 2x or 3x of that. I have passed the batchSize as 20 and fetchTotalCount as true. I need to display the data in grid and need to export all in a excel also. But I am getting a time out error. Is there any way I can query these number of data in UI. Please help us with your suggestions. Regards, Kavya

i want to select 5 dates in One Date Calender field. is there any Method or field are there ?

Hi, There is a CDT which is calling a Sequence in Oracle as a primary key. Below is the extract from CDT. <xsd:element name="recordId" nillable="true" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa">@Column(name="RECORD_ID") @Id @GeneratedValue @SequenceGenerator(name="sequence", sequenceName="A_RECORD_ID", allocationSize=1)</xsd:appinfo> </xsd:annotation> </xsd:element> For some reason, when we are trying to insert data in the table some other sequence is being called and we are getting "Unique key Violation". We are able to identify that sequence but not able to figure how this is happening. We could not find any trigger in the table. Any pointers would be highly appreciated.

We have a requirement in which Excel File is having more than 350 columns and more than 15k rows. We want to split this file into 2 files for further processing based on rowcount. Have anyone implemented this kind of functionality in Appian?

Hello world, I am currently representing Infosistema, a portuguese IT company and we are on a hunt for Appian Developers! We need someone with :  1 + years of experience in Appian Spanish/Portuguese and English language skills We offer both remote or relocation options. If you are interested or know anyone who might be, please contact me either through here or through my linkedin. Thank you very much.

Hi, We have a requirement to write data in one of the sheets where the base template is excel with macro. We are able to write data in the adjacent sheet in the excel macro but the file is getting converted to xlsx. Could you please advise if its possible to retain the excel as xlms or Is there any workaround/ plugin to achieve this. Thanks in advance, Anju

Hi, I have a interface from where i want to invoke process model having user input interface. I have used start process it invoked the process model but showing stuck in node having interface configured and noting is displayed in parent interface also. However same process model is configured in Record action of record type design objects , it's working fine.

Hi, How can we integrate Google calendar events with Appian and also join google meet events from Appian. Thanks in advance.

Expression evaluation error : com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.ServiceConfigurationError: io.grpc.ManagedChannelProvider: Provider io.grpc.netty.shaded.io.grpc.netty.UdsNettyChannelProvider not found

Hi I am trying to emulate the 'Corporate Raffle' tutorial in Appian with some changes in the requirements.  I have to show a 'details' section within the 'summary' section.  If user selects an item, product id and product description information has to be shown in the 'selection' column. Right now, when I click on the 'checkbox', it selects all options and I can't display the selected item(s) in the "Selection" column.  Is there a way to include collapsible section within a grid?  I am using card layout since I couldn't get the collapsible section with selectable grid layout. Any suggestions or idea would be really appreciated. Thank you. a!localVariables( /*--- start of localVariables */ local!pageHeaderTextColor: "#44546A", local!sectionDividerColor: "#333F50", local!isSelected: { false() }, local!dataSummary: { { productId: "123", productDesc: "item Apple" }, { prod

I am planning to give a certification exam and have to use my company account, but I'm leaving the company in a few days. Would it be possible to move my certification later, to the account with my personal email?

In my application, the DB contains the fields (id,name,unit,type,isActive). The name and unit values are retrieved based on the type and shown in the UI dropdown and that is the List. One Particular type contains 13000+ active records and gives Memory Threshold issue when it tries to load the data. In the expression rule, the batch size as set as -1 to retrieve all the data's from DB.  To avoid this exception, I added the batch size as 100 in a!pagingInfo(). But the problem is now able to see only the 100 records in dropdown field and not all the 13000+records.  Is there any other option is available to resolve this problem. Regards Martina

Hi , I am not able to login to community site from 4 days getting error message as below. Appreciate your help! Regards Nishtha Bhatnagar

I have the following:a!localVariables( local!countries: rule!PT_GetAvailableCountries(), local!selectedCountry: rule!PT_GetAvailableCountries()[1], local!states: rule!PT_GetStateByCountry(local!selectedCountry), a!formLayout( label: "Create Customer", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "First Name", labelPosition: "ABOVE", value: ri!record['recordType!{cf9a6a37-c43d-422f-b4f7-bef6f0e8d9a3}PT Customer.fields.{421eacda-bfa9-4e18-8a6f-4428e01b5e23}firstName'], saveInto: ri!record['recordType!{cf9a6a37-c43d-422f-b4f7-bef6f0e8d9a3}PT Customer.fields.{421eacda-bfa9-4e18-8a6f-4428e01b5e23}firstName'], characterLimit: 30, required: false ), a!textField( label: "Last Name", labelPosition: "ABOVE", value: ri!r

Hi, I need to call a danish web service (KMD Workzone). It uses the OData protocol, which is a protocol for REST APIs. The authentification protocol is NTLM. Problem is, I can't find a way in Appian to combine REST and NTLM: If I use an integration object, then it must use a connected system, and NTLM is not among the 7 supported authentification protocols. If I use the smart service "Call web service", then it seemingly supports NTLM, but only in combination with the SOAP protocol (it requires a WSDL). It seems that at one time the plugin WebAndXMLExtensions could do this, but it is not in the App Market anymore.  Regards, Søren Juul

How important is using a deployment account?

 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.