Discussion Categories

Hello, Does anyone know how can I populate the node input "Custom Cell Values" on the smart service "Export Data Store Entity to Excel" with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?  The same can be accomplished with plug-in "Export CDT To Excel", considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Hi All, Is there a possibility of Highlighting a field , when it is updated. we have a scenario, where a user updates some fields of a record  and send it for approval. The manager should be able to see the fields updated as Highlighted, based on which he can take decisions. Warm Regards Vineeth

I am unable to invoke the chrome browser version 111 using chrome driver version 111, following exception is faced. Kindly let me know the solution __EXCEPTION__:org.openqa.selenium.remote.http.ConnectionFailedException: Unable to establish websocket connection to localhost:59631/.../f4eb2165-b462-46cb-9627-a5bdb48c2252 Build info: version: '4.1.2', revision: '9a5a329c5a' System info: host: 'VURAM-2021-0203', ip: '192.168.1.8', os.name: 'Windows 10', os.arch: 'x86', os.version: '10.0', java.version: '1.8.0_311' Driver info: driver.version: ChromeDriver at org.openqa.selenium.remote.http.netty.NettyWebSocket.<init>(NettyWebSocket.java:104) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyWebSocket.lambda$create$3(NettyWebSocket.java:137) [selenium-remote-driver-4.1.2.jar] at org.openqa.selenium.remote.http.netty.NettyClient.openSocket(NettyClient.java:118) [selenium-remote-driver-4.1.2.

Hi, I'm getting below error with the below code. Please help me in resolving this a!localVariables( local!selection, local!selectedProduct, local!rowSelectionIndex, local!docCodes, local!removedPropertiesList, local!finalNotificationProperty:a!refreshVariable( value:ri!finalNotificationProperty ), local!removedPropertyIdList:a!refreshVariable( value:ri!removedPropertyIdList ), local!documentCodes, /*local!tempDate,*/ a!sectionLayout( label: "Product Details", contents: { a!gridField( label: "Read-only Grid", labelPosition: "COLLAPSED", data: ri!finalNotificationProductDetails, columns: { a!gridColumn( label: "MK/V", value: fv!row.mkv_txt ), a!gridColumn( label: "Generic Name", value: fv!row.genericName_txt ), a!gridColumn( label: "Trade Name", value: fv!row.tradeName_txt

Hello, Does anyone know how can I populate the node input "Custom Cell Values" on the smart service "Export Data Store Entity to Excel" with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?  The same can be accomplished with plug-in "Export CDT To Excel", considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Hi, I have an expression rule which is returning data from the database table. Now, I would like to get a latest db record using that expression rule. How can I achieve this. Any advises please. Thanks.

Hi, I have the below scenario. I have a master table to which I have to save the data initially. Later if any of the child tables have data then I need to store into respective tables. Also, I have to save the master table autogenerated key column into the child tables. Can someone advise, if I have to use any specific smart services to achieve this. Thanks in advance.

Input: "MAHESH, Output: {"M","A","H","E","S","H"} how to approach this?

Hi, form is not getting opened and displays the below error: Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = 74a54:998fd] in rule 'fpl_frm_etmf_upload_doc_readonly' at function a!forEach [line 427]: Error in a!forEach() expression during iteration 3: Expression evaluation error at function rule!DMD_UT_FormatDate [line 443]: Could not cast from Time to Date. Details: CastInvalidCould not cast from Time to Date. Details: CastInvalid The  rule!DMD_UT_FormatDate is having the formation as  if(isnull(ri!dtDate),ri!dtDate,text(ri!dtDate,"dd-mmm-yyyy")) The parameter dtDate is a date field. Could someone tell me why user is getting this error. Thanks Faisal

I am new to this concepts, please explain?

Currently building out a Usage Metrics dashboard which uses a plugin to read the Records Usage log. In the "Filters" field returned from said log, it records searches which are typed into picker fields but NOT searches typed into the search box on the grid.  For example, when I'm searching a gridField populated by a!recordData sourcing from a synced Record Type, using the OOTB gridField search box, nothing is recorded in the Records Usage log. Nor does it record any application of user filters.  When I am using a pickerFieldRecords sourcing from the same synced Record Type, only then are my search or filter values recorded in the log.  Effectively, nothing is recorded in Filters when applied to the Record Type-backed grid; this seems like an error -- that only searches/filters applied via picker field would be saved. Everything I read in Appian documentation led me to believe that the above data points would be saved under Action = "Reco

Hi Community , I had started to do a project where the use case is without using the rule input I have to get the data and write it in the database. As a start I created all the basic steps of creating the record type and generating the record actions where as an result automatically process model and interface are created.  I tried to map the record type fields via local variable in the interface such that when I moved over to the process model I can't able to write up the data in the database . In general I wanted to publish a portal such that when I tried to add pages ( Interface ) , a error occurs like rule inputs variable can't be used , So I started to prepare the above use case and to solve it. So kindly guys help me out with proper steps to handle over interface and process model. Thanks in advance..!

Im trying to set specific format for Start Time Column at the process report and data does not show when i set the format.

So we have a portal where the entire interface is in a!formLayout. Within the formLayout is a section that contains a billboard. We want the header to span the entire width of the page, but billboards don't do that, they have a margin on the right and left side. I know a!headerContentLayout allows the billboard to stretch the entire width of the page - so I figured I'd change the interface to a!headerContentLayout, put the billboard in the 'header' parameter, and the a!formLayout in the contents array. But a!headerContentLayout does not support a!formLayout as shown in this error I receive: The contents contain a component that is not supported in the header content layout. Received: FormLayout  Is there a way to make the billboard/header stretch the full width of the screen in this situation? Thanks for any help!

We are trying to get an excel document from a SQL Query and we are getting the following error:  Export SQL To Excel An error occurred in executing an Activity Class. We tried to rewrite the SQL sentences using quotes but it keeps failing the same way. SQL Sentence: SELECT `ORDER_BY` AS `EMPLEADO`, `PLATO`, `IS_PAN` AS `PAN`FROM `SL_ORDERS` INNER JOIN `SL_LUNCH` ON `SL_ORDERS`.`LUNCH_ID`=`SL_LUNCH`.`ID`WHERE `SL_ORDERS`.`ID` IN ('1', '2') AND `SL_ORDERS`.`DIA_SEMANA`='1'We know the problem is from the SQL sentence because if we put a typical Select * table without anything else works, so everything else is fine in the input section.

Hi, my problem is that I can export correctly the entity and download as Excel file but when I open the file only appear the data of father CDT but not the rest of the nested CDT. This is the code of my grid: a!localVariables( local!autoridad:null, /*local!selectedAudiencia: ri!audiencia,*/ local!startIndex: a!refreshVariable( value: 1, refreshOnVarChange: {ri!selection,ri!autoridad, ri!motivo, ri!empleo, ri!ejercito, ri!situacion, ri!audiencia} ), local!pageSize: 10, local!sort: { a!sortInfo( field: "id", ascending: false() ) }, local!pagingInfo: a!pagingInfo( startIndex: local!startIndex, batchSize: local!pageSize, sort: local!sort ), local!selection: ri!selection, local!data: a!refreshVariable( value: rule!AU_ER_getAudienciasByFilter( autoridad: ri!autoridad, motivo: ri!motivo, empleo: ri!empleo, ejercito: ri!ejercito, situacion: ri!situacion, nombre: ri!nombre, pagingInfo:

Import excel to Database smart service not including any rows where row is less than batch size.i am uploading an excel with 121965 rows in it with batch size 1000.now the problem is Appian is only considering 121000 rows and excluding last 965 rows. can anybody help?

Hi All, I made a new channel in IDP, submitted training documents for specific type. But even after many hours, IDP did not got trained to auto classify my documents. Neither I got any error email. I did this multiple times with different training documents, but every time IDP just shows a message that docs are submitted for training, and I will get an email once they are trained. But I never get any email about that. I just want to ask, is the feature to train documents for auto-classification even available for Appian community edition users? Note: This question was asked about a year ago and did not get any answer yet.

Hi All, I am facing an error when opening a summary view of a record. I am attaching a screenshot please help me out. Thanks in advanced.

Hi Techie, Record is getting updating/inserting in the external database however when coming to Record Type, it is failing to sync.Can anyone please look on it. Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = f7383:f3bde] at function a!recordList: An error occurred while retrieving the data for "PEG_CMP Request". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000)

I have to local variables as input 1. List of dictionary : [ [ id:1,value:"abc" ] , [ id:2,value:"bbb" ] , [ id:4,value:"ccc" ] ] 2. List of integers: [1,4]  I want to create 3rd local variable (List of values) by selection value from dictionary where id is present in the List of integers  example :  result ->    List of values : [ "abc","ccc" ]

Hi I need to display multiple input integer fields within one integer field based on multiple dropdown selection means i have a multiple dropdown which has 11 options if i select one option from dropdown the input integer field related to that need to display likewise if i select three options from dropdown three input integer input field has to display. I have defined 11 integer field individually like below but need to know the best approach to define in one integer field please suggest on this contents: { a!integerField( label: "Organization Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, showWhen:contains(tointeger(ri!impactedHierarchyList),1) ), a!integerField( label: "Location Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, showWhen:contains(tointeger(ri!impactedHierarchyList),2) ), a!integerField( label: "Account Hierarchy", value: ri!selectedHierarchies, saveInto: ri!selectedHierarchies, sho

How can I populate the database with a single form on multiple dates field?Let's say I am creating a Vacation form and when an employee wants to apply for leave from 1st Jan till 5th Jan, they open the form select FROM and TO date, fill other form fields such as reason of leave, informed manager etc. Now when the employee hit submit I should see 5 entries on Database with 5 dates but the rest form details should be same.

I am getting error as below on calling Oracle's stored procedure using a!executeStoredProcedureForQuery.  Stored procedure and expression are attached below. Help is much appreciated.

Hi Everyone, I am returning a cursor from Oracle SP, When using new executeStoredProcedureForQuery, i am getting "Invalid Column Type:2012" error.  can see in "Appian Community", Updating ojdbc8.jar solved error, Please advise whether we can follow this solution for our Project.