Data Fabric

Hi everyone, I wanted to do validation based comparing the data already existing in database, but problem is that I have around 40000 records, so while fetching data from database to appian it is throwing the error. How to handle this scenario.. Thank you all in advance! Regards, Kiran Sajjan

Hi, Recently I have deployed a new application to Production environment. But facing DB connectivity issue.Please find the screenshot for reference: After creating the Data Source at Admin Console it shows Test Successful.Please find the screenshot for reference: and when I verified the Data Store, it is successfully connected to DB.Please find the screenshot for reference: Now the application starts working finePlease find the screenshot for reference: After some time I tried to login it is showing same error.Please find the screenshot for reference: I'm repeating the same steps to avoid the error. Please help me in clearing the error. Thank you.

Expression evaluation error : Invalid index: Cannot index property 'fields' of type Text into type RecordType (APNX-1-4291-001) How to resolve this?

Hi All, We've a process which is started via webAPI and has a node which uses QueryProcessAnalytics to query the process report to get a few details. This node where it fetches the data from Process Report is  not working/not returning results when running the node as the same user as process initiator(in this case , service account used by webAPI), however, it works fine when changing to execute as user (process designer). We checked the security of the process reports and the parent folder and it has the service account group with Viewer permission.  The only difference we see is the service account is basic user and the process designer user is system administrator. Any pointers to why query process analytics is not working when called via webAPI with a service account?

Hi Community,I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.= a!queryProcessAnalytics( report: cons!I_MY_OPEN_TASKS, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "c0", operator: "includes", value: ri!taskName ), a!queryFilter( field: "c3", operator: "between", value: { ri!assignedOnFrom, a!defaultValue(ri!assignedOnTo, today()) } ), a!queryFilter( field: "c4", operator: "in", value: ri!assignedTo /*issue at this filter*/ ) }, ignorefilterswithemptyvalues: true() ), pagingInfo: a!defaultValue( ri!pagingInfo, a!pagingInfo( startIndex: 1, batchSize: -

how to create end user to enter the insurance number and get a report. 

Hello everyone I am new to Appian and I wanted add data from a recordtype to the dropdown but I can't seem to figure it out. I tried different ways but I've got nothing. Can anyone asisst?

Hi Team, I am trying to get the month, day and year from the date time. I was able to filter the records using a query, but the result is in a list type variant.  I am unable to apply month/day functions to the fv!item. If i write month[fv!item] i am getting the following error. "Expression evaluation error at function a!forEach [line 47]: Error in a!forEach() expression during iteration 16: Expression evaluation error at function 'month' [line 56]: A null parameter has been passed." I believe it is because each individual item is itself a list. I don't know how to drilldown the list.  fv!item[1] give me another error.  "Expression evaluation error at function a!forEach [line 47]: Error in a!forEach() expression during iteration 1: Expression evaluation error : Invalid index: Cannot index type Number (Integer) into type Date and Time". Any help is appreciated. thanks

Hi, I am working on a end-user interface that allows users to add "properties" to different "content type" objects from the front-end, without requiring a developer to go into the back end, create a new table & corresponding joins, update the CDT & relevant objects, & then finally push an update to production. As part of this, I am wondering if it's possible for users to connect to existing tables & record types. The ideal interface would allow users to directly select which record type they want to connect to from the front end. Is there a way to access or store the UUID or name for all record types in an environment?

Hi all, Here are my needs: I have a grid of records with checkboxes and a button. I woud like to delete selected records and refresh the grid. Deletion works good. Refresh does not work. I read alreqy these 3 posts with problems similas to mine,  without finding a solution: https://community.appian.com/discussions/f/data/25926/how-to-refresh-a-recordtype-after-the-end-of-a-process https://community.appian.com/discussions/f/data/25694/record-refresh-after-record-action https://community.appian.com/discussions/f/new-to-appian/25654/page-refresh-or-redirect-on-after-button-press/100298#100298 What i did so far is to create a read only grid. Data are retriven from a recordType, relying directly from the DS.  Clicking on checkboxes stores record ids on a local variable. The button invokes a PM who does other operations before deleting checked records from DS. All branches in PM are chained up to the delete step. here the button: a!buttonWidget( label: "Del

I am using modern records/Sync records to create related actions. I have around 20+ related actions i need to define for an Interface. I have to pass the most common parameter for all 20 of them. Example: I need to pass Case information into each related action, i am using a!queryRecordType to pass this info. I am passing this 20 times for each 20 RA as mentioned, i am not happy with using it multiple times. I can create an expression rule for it alone and pass it; still it being called 20 times. Is there a better approach to achieve it in single call and passing along to the remaining RAs???? case:a!queryRecordType( recordType: 'recordType!{092e25cb-d859-498e-810c-ede1a27152dd}FAS Manage Case', fields: 'recordType!{092e25cb-d859-498e-810c-ede1a27152dd}FAS Manage Case.fields.{c59a2f56-2d82-405b-8012-f24f371ae9ab}id', filters: a!queryFilter( field: 'recordType!{092e25cb-d859-498e-810c-ede1a27152dd}FAS Manage Case.fields.{c59a2f56-2d82-405b-8012-f24f371ae9ab}id',

when i click on Record link i got this error  in the interface it show the summary view this is my configuration how to fix this issue

Hey folks, Been running into an odd situation. Although I am in the groups Database Administrators and Database Editors, I am unable to view or edit (most) Stored Procedures & Functions on the MariaDB. The Appian version the customer runs is 22.2 and I should have all the necessary privileges, but nope.. tried to search for a fix for this but alas, no answer could be found. Has anyone else have had this issue or know how to fix this? Thanks in advance, Matthias 

Hi,I am using record data ( a!recordData() ) in "data" parameter of the read only grid and I am not able to make the paging dynamic ( should fetch the data/rows from the Record according to the batch size not the whole data), because of this the grid taking too much time to change the paging from one batch to another ( here in the below code pageSize: 10 ). Expected Outcome: Data should be fetched according to the batch size from the record not the whole data and User Filters must also work with the dynamic paging.Thank You.

Currently we have option to add a!recordActionField in the paging grid column to display record action. But is there a way to display more than 1 record action in one column? Please suggest.

i have to store some values for short period of time , i don't want  to store in database...is there any way

Hi Everyone I want to create a Search box to search for Issue IDs in my Record Type. I found all the Info's on how to do it here: Search and Filter the Record List - Appian 22.3But my problem is, that I just can create User Filters, but don't have the option to create search boxes. When I'm on my Record Type, I just see User Filters. Which is not ideal to filter for Issue IDs, because there are a lot. And, if you believe the manual (Search and Filter the Record List - Appian 22.3) , Search Boxes would be better, because they don't load the data directly, but you can search for it after loading the site.  Does this relate to maybe an old Appian Version that I am note able to see Search and User Filter but just User Filters? Or do I have to "activate" the Search option on Record Types somewhere else?  Thanks in advance for your help and kind regards,  Pascale 

Pls suggest me a way to go back to the record list view from a summary view.

Hi, With our client, we could reproduce a curious problem with mobile phones (Android and iOS) : In an Interface we have a parent dropdown (category) that is used to filter a children dropdown.Initially the children list contains all the items because the selection of the category is on -Select- (null). 1.1/ Nominal case: - The first time we select a specific category (let's say -1-), we meet an issue : the children list contains all the items (filter does not work)- Then we select another category (-2-) : all works fine, the children list is well filtered- Then we select again the previous category  -1- : all works fine, the children list is well filtered (18 items with scrollbars) After this, the children is always well filtered (whatever the category selected). If we close the Interface then re-open it, we can reproduce the issue. 1.2/ Alternative case: If we make a test with a category filter that retreives few children items (less than 10, ie : withou

Hi Team, we got one requirement where the objects have multiple parent child relationship so we created one table and added one column called parentId and it is used to map all the child objects assigned to it. Now we created one record and the requirement is to add a column called child objects and will provide a rich Text Icon with link in that column and on the click of that click we have to filter the data mapped to that parent and we need to capture the sequence of user clicks (Since the parent has Childs and sub Childs). Can someone help me on how to implement this requirement. Thanks in Advance

Hi, I'm trying to add this grid column sort where my data is being pulled from a record,  a!gridColumn( label: "Modified", width: "2X", sortField: 'recordType!Record.fields.updatedDt', value: fv!row['recordType!Record.fields.updatedDt'] ), Now when i try to manually sort on the column getting the error: Interface Definition: Expression evaluation error [evaluation ID = 779f6:4b583] : An error occurred while executing a save: Expression evaluation error at function fn!error [line 114]: Invalid field identifier: "#"urn:appian:record-field:v1:adaa93fd-a839-446b-9a78-c0ea56a7b0d9/a20944d4-cb3d-4847-877e-ce0bf6144e3b"".

We have a business need to create folders to house documents.We plan to do this via a Process Model. In the future, we would need access these folders in order to save documents to them, and to retrieve documents from them. One way to do folder access we saw was to store the Folder ID when generating the folder, and storing that for future folder access. Is there another way to do this? Such as accessing folders via folder names?

Hello Community, Do you know how can I get the value from a record user filter? Basically I have several user filters for my record and when displaying them in a interface, I want to have some logic based on the user selection. From the image above, my question is how to get the selected value for Team filter ? Thank you 

Please let me know how do I pass apostrophe in Inputs parameter  for executestoredprocedure function ocal!sp: fn!executestoredprocedure( dataSourceName: "jdbc/DRO", procedureName: "procCSS_Search", inputs: { { name: "ssn", value: ri!ssn }, { name: "lastname", value: ri!lastName }, { name: "firstname", value: ri!firstName }, { name: "caseid", value: ri!caseId }, { name: "primaryCauseTF", value: ri!primaryCauseTF }, { name: "causenum", value: ri!causeNum }, { name: "oagnumber", value: ri!oagNumber }, { name: "personid", value: ri!personId }, { name: "phone", value: ri!phone }, { name: "casestatus", value: ri!caseStatusCode }, }, timeout: 300 ),

Hi everyone,  I think the Appian build-in Manage Filters feature is quite handy for saving and setting default features, however I've got some questions that need to be clarified (attach below the photo to not confuse you) 1. Is there anyway that I can check the DB that save these filters? 2. I'm going to add a new user filter into the list of existing user filters, will this action affect the saved filters record, I mean will it delete all saved filters in the DB and empty the My Filters tab (red highlighted ones)? And Is there anyway for me to I test this case when I have no saved filters exist? Thanks for your helps!