-
Recently active
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?
I want batching for looping process suppose i have 1000 id's and i want to execute loop with 200 batchsize. a!forEach( items: local!id, expression:fvi!item )
Hi Members,I am trying to calculate the working hours between two different time using calworkhours function.It is giving perfect result for all the days except on Fridays. I have check my calendar setting as well . Friday's setting is same as other working days.I have pasted the Screenshot of Calendar and Expression along with it's result. EscalationCalendar Image : I am expecting 6 hours but it's giving 2 hours and it is same for every Friday.Please help on this ASAP.
Hi. How to create different pipelines using appian and provide constraints and conditions on the same?
Hi everyone i have an error that i dont understand , why it is throwing this error when i am debbuging the process ? it s even not showing errors in the console . so how can i know what is the reason of this problem ? everything worked before , i dont know what happen ? anyone know what i need to do ??
Hi Team, I am in the learning phase of Appian RPS, I wanted to know how we revert the changes done to my Robotic tasks, Can we revert RPA robotic tasks to the previous version or date if so then how? Many thanks, Mohammed Khaiserulla
Hello All, I need your guidance and assistance regarding the creation of a cascading dropdown interface that supports an unlimited or variable number of levels. The purpose of the interface is to display data retrieved from a reference database table, where the values of the child level dropdowns are determined by the parentId field in the table. The cascading dropdown interface will be used to present hierarchical data from the reference database table. Each dropdown level represents a different level in the hierarchy, with the child level options being dynamically populated based on the selected value of the parent level. The goal is to enable users to navigate through the hierarchy seamlessly, regardless of the number of levels it comprises. The database table looks like this . ParentId is FK refer to Id field. Id, level parentId 1 l1v1 null 2 l1v2 null 3 l1v3 null 4
Hi Experts, I want to insert Emojis and special characters with text . Is there any way to insert in Database? Thanks
When I write a code "month(fv!item.asDate) = local!month", why it's showing a result A null parameter has been passed. How to resolve that part? Also I put that part if( a!isnullOrEmpty(index(fv!item, "asDate", null)), false, contains( tointeger(local!month), month(index(fv!item, "asDate", null)) ) ), but same error as it is
I have a local variable which is receiving BacthPayloadInput Response from process model local!updatedPurchasers_at: index( ri!EF_GeneralUpdatePayload_cdt.RequestJson, wherecontains( tostring("PowerPurchasers"), cast(103, index(ri!EF_GeneralUpdatePayload_cdt,"RequestEndpoint",{})) ), null ), when i output the values it contains in expression rule it gives me output like this: I want to extract the only "KeyPowerPurchasers" out of it which i am not able to do so. I have been trying to get it in following these two methods but both are having problem: first one: local!purchaserKeys_int:reject( fn!isnull, { if( a!isNullOrEmpty(local!updatedPurchasers_at), null, cast(101, index(local!updatedPurchasers_at, "KeyPowerPurchasers", {})) ) } ), it gives empty array {} 2nd one: local!purchaserKeys_int:reject( fn!isnull, { if( a!isNullOrEmpty(local!updatedPurchasers_at), null, cast(101,a!fromJson(local!updatedPurchasers_at).KeyPowerPurchasers) ) } ),
i,I have a grid inside a form with "Submit" and "Cancel" button, where I am loading one row with required entry fields.Also there is an delete icon basides to that row to delete. Now, when I try to submit the form in the browser url by clicking "Submit" button, system is not locaing validation message which is there at grid/form level.Whereas validation message is firing during interface level testing. Any inputs on this please.TIA
Hi Team, We are developing a component plugin to which a json file to be passed from Appian SAIL Interface to Javascript in plugin. Is there any way to pass the document from Appian to JavaScript in the component plugin? when we try to pass the document from document url to component plugin it asks authentication.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.