Discussion Categories

Hi, how can I print duration in Appian? Is there any function?

Hi, I'm working on aprocess model to update data form a record type. If after 5 min the user has not submitted the form an exception end the task. The problem with this option is that after the exception there is no way to close the dialog box. Is there any possible solution for that?

Hi, PFB my code snippet. when i click on button my data in the readonly grid is not refreshing. The source is a expression rule which calls an integration to get the data to display in grid. Kindly provide suggestions. a!localVariables( local!currentUser: rule!CORE_GetLoggedInUserName(), local!refreshCounter: 0, local!employees: a!refreshVariable( value: rule!PM_GetCurrentAddresses( tenantId: "77b50320-5f06-5740-84f4-18d4a8cda51d", identifierId: local!currentUser, serviceLocationId: "cac14c53-a058-4824-86dc-f24cea29b948" ), refreshOnVarChange: local!refreshCounter ), { a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Refresh", size: "SMALL", style: "SECONDARY", saveInto: a!save(local!refreshCounter, local!refreshCounter + 1) ) } ), a!gridField( labelPosition: "COLLAPSED", data: local!employees, refreshOnVarChange: local!refreshCounter, columns: { a!gridColumn( label: "Address Type", value: fv!row.addressType

Is it possible to perform multiple inserts or updates in the Query Database? I understand that the method using recordTyoe and relation is recommended by Appian, but I am asking this question to achieve exclusive control of updates to multiple tables. I know that this can be accomplished by a procedure, but I would like to know if QueryDatabase can be used as another technique.

What is the difference between functions todatasubset() and a!dataSubset()  ?

Hi All, I had the set of data in table like "startDate" as 2023-01-01,2023-03-01,.... and "endDate" as 2023-02-28,2023-04-30.... now I need to check today is available in between of which set.Please suggest if anyone have an idea. Thanks in advance.

When attempting to save a process model, an error message “An unknown error has occurred while saving the process model” appears and the changes to the process model are not saved: Appreciate for the suggestions/solution..

I need simple solution for document to binary conversion within appian. As request body I should be able to pass a document into a binary format while calling a REST API POST method. I've followed below links and those are not helpful for me. https://community.appian.com/discussions/f/general/20675/convert-any-document-to-binary https://community.appian.com/discussions/f/integrations/14913/web-api---send-binary-string-of-document https://community.appian.com/discussions/f/integrations/18923/convert-appian-document-to-base64/75414#75414 https://community.appian.com/discussions/f/general/19821/problems-with-a-binary-document

Can Delete Records and Write Records be performed in the same transaction? I would like to do a rollback if either Delete or Register/Update fails.

Hi,Is there a way we can disable few items inside a dropdown? I need to show few litem inside a dropdown and should not allow to select those values. Is this possible in Appian dropdown control? TIA

Hi all, I'm trying to create a generic save process which will take a map list as a parameter that will be converted to different types of record types for a write records MNI node (since I can't do 1 write records for different record types). I want to know if there's a way to iterate through the map and convert it to it's appropriate record type. Better approaches are welcome if you believe this is an anti-pattern. I want to centralise a few a!process saves through this process cause it seems like creating a save process for each screen is overkill.   

Hi, My team is trying to create a chart that warns users when an app is used the most. As soon as the user execute a process, we insert in Database some information (timestamp, typology, current user, etc). To generate the chart we use the following code: a!lineChartField( data: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales', config: a!lineChartConfig( showIntervalsWithNoData: true, primaryGrouping: a!grouping( field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{88cbc07e-c205-4ccc-8c3f-9245ea2bfbf1}timeStamp', alias: "timeStamp_hour_primaryGrouping", interval: "HOUR_OF_DAY" ), measures: a!measure( function: "COUNT", field: 'recordType!{2e39f6f7-a6b0-43c0-a1f2-39a16ddf112a}PGM interaccionesMotivosYCanales.fields.{dbcf9179-1efb-4c26-aac4-bc7c25fbded7}id', alias: "id_count_measures", ) ) ) The problem is when we use "HOUR_OF_D

Hello everyone! I need to display 5000 rows of editable rows in the grid - it’s about 2mb of data. First thing I have thought of is to fetch data from database with batches - to set a start index and a batch size and pass it to query entity expression, and then provide that result data subset to editable grid with implemented paging option (clicking back and next will trigger an update to a start index as well as a new batch to be fetched from database) And I’m facing a problem finding an approach to update that data in the database after editing on the form when switching pages. Most probable storing 5k items in a local variable along with other data will cause memory issues while manipulating it for example Is there any approach to achieve a desired goal?

Hi all, i want to select a speficic color for this pie chart, for example if the status is "DA RIASSEGNARE" the related colour is orange and so on.  Here is the code, and in attachment the pie chart. Thank in advance.a!localVariables( local!save, local!save2: a!refreshVariable(value: local!save,refreshInterval: 0.5), local!array, local!record2: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task', a!sectionLayout( label: "", contents: { a!pieChartField( data: a!recordData( recordType: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task' ), config: a!pieChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2def5f7f-c651-48be-9fce-fe502682f30f}GEC_Dettaglio_Task.fields.{6d87248b-9f66-495a-b736-3e539bcad481}STATO', alias: "vehicleMake_primaryGrouping" ), measures: {

Hi, In Appian how to restrict Confidential/Restricted data from being cached on user's local disk.  Anyone know what kind of values will be passed for the below HTTP headers when we use Appian sites/pages Cache-Control: Pragma:  Expires:

Hi, my table is having let's say fields - name, age, gender and  meta Data - isActive, createdOn, createdBy. How to add data for these fields

Hi Appian folks, We have a use case in Appian RPA where I am taking a small part from an image. I am using "Locate Image" module, changed the Search parameter to "Screen Region". But I am getting the error that says "Unable to find image within the given timeout interval". I have added the image in Support files as well. Does anyone know how to resolve this? Config:

Hi, I actually wanted to know if is there a way to track the no of users logging into the project in real-time in Appian? 

Hi Guys, I am facing dead lock issue while executing Stored procedure Parallelly through Multiple Instances. Error Message : Transaction(Process Id : 1234) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the Transaction. Please post if you have anything related to this issue.

Hi, Can You please suggest, How to install appian common object application for appian cloud users. 

In related action , after submitting a form ,the form must gets closed and it must enter details in db  but after submitting the form it is not updating the details in db and the form is not getting closed can someone please with this

I want to access sql result data in Custom Output of Query Database Smart Service, but I get an error. I would like to access the ResultSets, like in the Execute Stored Procedure Smart Service if possible, can I achieve the same operation in the Query Database?

Hi actually there is a process in our project in which one process completes in the SQL server after that the status code changes and then the Appian process model starts at the click of a button once the status is changed. So is there a way to trigger that process model without clicking on that button on the change of the status? We tried triggering the process model through webApi from SQL server but failed. Is there any other way out?

I have a string something like "***-***" I just want to check if the string contains "-"?What is the best way to achieve that?

Hi Team, Can we provide an export option for the read-only grid that we have generated using a rule? If not, what would be the workaround for this?