Data Fabric

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!

Anyone send me links for performance of record type and how many types? and how to do it?

I am looking for suggestions on the best and fastest way to query data that has about 50,000 rows of data.  My use case is data collection for inventory purposes where an operator will use a handheld device and scan and item_id barcode, the application retrieve a description and then they can scan a qty.  The reason for the retrieval is to verify a good part number, also to occasionally verify the barcode to the product.  The data currently resides in a SQL database.  We are on Appian 22.3 Cloud.

Hi everyone, How to check all of the document if exist. I query all of the data have Document Id and I want to check all of that using in the single query

So basically in site I'm getting all the data from db whre as i have only one field where use input task is req. And that is a date field I need to input the date from site can anyone help me with this?

When I'm trying to create a datatype from dB I'm getting the following error, "Your data type could not be created.please consult the logs for more information" Can anyone please help me with this??

I am  facing problem  in developing project. I made relation in two table in appian cloud database. But when i insert data foreign key id is not inserted in second table. see the below screenshot when document data inserted , request_id (2nd column) will be null. 

Hi, I have a grid in an interface (a list of records from a RecordType), and each row linked to a "Modify" related action. When I click on "modify", a process is launched, and a start form is displayed, then the user can update a field value and submit the form. When the process ends, the list of records appears back, but the old value is still displayed in the grid. How would you do to update this grid ? - I've set the [refreshAfter: "RECORD_ACTION"] attribute, but the grid is not updated. - We do not use a RecordSync, so we can not use the new Smart Service "Sync Records". - When I refresh manually the grid, the data are ok.

Hi, Any one knows from where the Schema value will be pulled when we select Data Source value. No where I have given the Schema value during Data Store setup.

Here is my code  I understand that error i how can i use the same nested if without error?