Discussion Categories

Hi,Can anyone tell the difference between Write to Data Store Entity Smart Service and a!writeToDataStoreEntity() function?? I am asking in the context of place of usage. As best practices, what are the specific places we can use the above mentioned? And is there a way to catch the error occuring while writing to DB using Write to Data store entity smart service???Thanks in advance

Hi, I have an excel file which looks like  that I am importing to my Appian DB through the smart service 'Import Excel to DB' and Ticket_Number is the primary key on my DB. It appears to me that the Smart service is sorting the primary key in ascending order (which I don't want).. I don't want to sort my data in either ascending or descending order. One solution is to create a separate primary key and prevent this from happening but is it possible to restrict the sorting in the smart service 'Import Excel to DB'. Is this a bug ?? or just that I am not aware of how to prevent my smart service to do any kind of sorting ? please help  thanks jaideep

WHEN I RUN THE PROCESS MODEL I GOT THIS ERROR , HOW CAN I RESOLVE THIS ERROR :.An error occurred while trying to write to the data store [K_EMPLOYEE_DETAILS_DSE].  No values have been written. Details: org.hibernate.exception.ConstraintViolationException: could not execute statement (APNX-1-4208-004) . CAN  ANY ONE PLEASE  TELL ME WHAT IS THE PROBLEM ?

Hi Everyone, I have the requirement to add multiple rows in editable grid and it should have a x icon for each row added before saving to remove that row. Can anyone please help me out. Many Thanks in advance!

Dear Team, I had a query, what steps need to be followed for deploying application from one cloud to whole new different cloud.

Hi Team, I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done. Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors. This is the code:- buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-94

Dear all, I'm finding a solution for a phone screen, when the user scrolls down then show an icon on the bottom right so when the user clicks on that icon the page scroll to the top .... ???

Hi all! For my application, I need to acquire the data type and length (and the number of decimals in case of a float) of all the fields from a single Record Type (and preferably the source fields as well). Now, as far as my knowledge goes there is no out-of-the-box solution for doing this. For acquiring the data types of a Record Type I have made the following solution:  /*Partly based on the solution provided in https://community.appian.com/discussions/f/general/23723/map-with-variable-key */ if( rule!isVoid(ri!record), /*use your void check expression here */ {}, a!localVariables( local!xml: toxml(ri!record), local!json: a!fromJson(a!toJson(ri!record)), local!keys: a!keys(local!json), local!types: extract( local!xml, cons!XML_FIND_TYPE_START_DELIMITER, cons!XML_FIND_TYPE_END_DELIMITER ), cast( typeof(a!map()), reduce( a!update, local!json, merge(local!keys, local!types) ) ) ) )

When converting docx to pdf using Arabic font, I want to prevent numbers to change to Hindi numbers.

Please forgive me if there is a way to do this already... I find cases where I have a fault in a process model during debugging. I track down the fault and fix it (either in the instance or in the process model itself) I then have to re-run the process  BUT Sometimes one wants to have a live run of an older version against a newer version rather than looking at the static comparison view in Versions SO I would like to be able to: go to my instances in Appian Designer Monitor view be able to right-click (or other method) to select a different version of the process model (i.e. either a previous or an updated version) run the same instance through  the newly selected process model 

Hi, We are creating performance test scripts in JMeter, after recording the flows and running them, the scripts run fine for 1 day however they fail after 1 day, on inspecting I came across several dynamic values like CacheKey, SaveInto and Context which change often.  Now the problem is there are several CacheKeys, SaveInto and Context in multiple responses before the requests where these values are used, how can I know which values to grab dynamically and use in the further requests.  Can anyone please help as this is a blocking issue! PS- I have already handled the appian csrf token and I am able to login successfully.

Hello, As I am new to Appian and try to evaluate the tool I would like to import some data from excel/ CSV to test drive a couple of ideas. I have found a plug-in that should be helpful in importing data: https://community.appian.com/b/appmarket/posts/excel-tools#. Though when clicking on download it says "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile" I assume the free account doesn't make you a customer, though how can I get a sample data set in the platform to test drive. Regards, Wolter

Hi All, Trying to refresh using a refresh variable in grid. Facing issue with refresh. Please find below code and let me know if any changes are required. a!localVariables( local!refreshCounter: 0, local!startIndex: a!refreshVariable( value: 1, refreshOnVarChange: local!refreshCounter ), local!pagingInfo: a!pagingInfo(local!startIndex, 5), local!data: a!refreshVariable( value: rule!S_getAPI(), refreshOnVarChange: local!refreshCounter ), { a!buttonArrayLayout( a!buttonWidget( label: "Refresh", size: "SMALL", style: "SECONDARY", saveInto: { a!save( local!refreshCounter, local!refreshCounter + 1 ), } ) ), a!gridField( label: "Data", labelPosition: "ABOVE", data: local!data, columns: { a!gridColumn( label: "First Name", sortField: "firstName", value: fv!row.firstName ),

Hi I am trying to do 'Maven Setting' with Appian RPA Configurator. However, an error message below is poped up. ・Authentication Error!: Check that the provided console repository URL and the maven API key are valid. This means that the provided console repository URL and the maven API key I input  is incorrect, isn't it? Please let me know if there is a possible cause other than incorrect input of the value.

I've got a dictionary of values and I would like to either loop through it for a grid, or convert it to something I can loop through. How might I do that?  For example, I've got this dictionary: {A: 3.1, B: 2.2, C: 1.3} I'd like to have a table that is something like Name for the first column containing A, B, C and Value for the second column with the various numbers in there. I'd like to also record a similar in thing in the database. How can I do that? 

Hello everybody Someone could help me please?? I don't understand about engine, what it it? how it is working  regards

Hello! I'm currently having an issue where I make the selections in the dropdown, but when it saves to my DB it saves the first selection 2 times or 3 depending how many selections I make. Currently I'm using a local variable to save the selection. Any suggestions to make sure it saves correctly to the rule input? thanks in advance

Dear all, I need to change the phone number to send the SMS for multifactor authentication. Do you know how I can do it? Thanks in advance. Best Regards Patricia

Hi, I have to make a call to SQL Server stored procedure with input parameters and get the return value. I have gone through the below URL for required documentation. docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html I am using 21.4 version of Appian, but still, I don't see Execute Stored Procedure smart service in my list of smart services. Can someone advise on this please. Thank you

Hi, I need to pull values from DB which does not starts with "ABC" for example. a!queryEntity(entity: cons!entity,query: a!query(filter: a!queryFilter(field:"office",operator: "not starts with", value:"ABC"),pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1))) But this is ignoring null values, I want null values also to be returned along with other values. So I just tried fetching only null values to see how it works.  a!queryEntity( entity: cons!entity, query: a!query( filter: a!queryFilter( field:"office", operator: "is null" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1) )) this is giving me 0 results. Nots sure what might be the issue. Can anyone please help? operator "not null" returns correct values, problem is with fetching null only.

Hey Appian Community Team, I am currently trying to map v22.3 relationship properly to an outer join that is SQL based query which is a view itself. Fundamentally im talking about inner and outer join to map for e.g. PID to REF PID. I was thinking of source filter but it will probably face limitations as well. An extract of the code is listed below (SELECT A.REF_PROPOSAL_ID, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CODE END, ', ') WITHIN GROUP (ORDER BY CATG.CODE) CATEGORY_CODE, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CATEGORY END, ', ') WITHIN GROUP (ORDER BY CATG.CATEGORY) CATEGORY FROM ABC_PROPOSAL_CATEGORIES A INNER JOIN ABC_PROPOSALS P ON A.PID = A.REF_PROPOSAL_ID INNER JOIN ABC_CATEGORIES CATG ON B.PID = A.REF_CATEGORY_ID GROUP BY A.REF_PROPOSAL_ID ) B,

He everyone! So, I've created a ER to fetch data from database, using a stored procedure. However, it seems being limited by 1000 record by search. Is it possible to change this config. If so, anyone can tell how should I procced ? One option it to dismember the search and do it little by little, until fetch all data requested, but I rather to try something more easy and smart.

Hi All, Can anyone please help me, How to refresh the columnlayout field inside section layout? Thanks in advance!

hii all, we have a requirement of  uploading a excel file and once user click preview the entire data in the excel should visible in grid for user , and once clicked on submit then the data should store in database  for achieve this we are plane to use a staging table(dummy db) for storing uploaded excel data and showing in grid , once user click submit the data in staging table should move to main database table and need to delete the staging table data , why because if the staging table not cleared the next user data also store and entire data in the staging table will appear in grid  please help with this , guide me  to achieve this. thankyou, Ramesh

Hii Experts, I am trying to create a expression rule to find out the difference in CDT (for Audit log) using CDT Comparison plugin. Could anyone help me out how to create ER for that  Thanks