Data Fabric

I have contact recordtype and experience record type with 1 contact to multiple experiences, linked through contact.id = experience.contactId. I have a form which saves contact details and a editable grid to capture multiple experiences. When I save I run a process model to first write to the contact DB and then I am writing in experience data entity. In the wirte to DSE for experience, I have mapped the input of data note in second process with contact.id generated automatically from DB in contact table.This works fine with 1 experience entry, but if I add 2 entries then the process error out as for 2nd experience entry the contatId is null and due to which unable to write the data in experience table. Can someone help?

Hi All, I have a case where Users will pass some Id parameter say batch Ids upto 4k or 40k and we need to query all the data for the inputs from one particular view. In older version like 17.1 we used this executesqlquery() function which is available in sqlexpressions plugin to fetch all data. Since this plugin is deprecated now we include a stored procedure that will query data dynamically. But for few data like upto 1000. It works fine. But it seems to have certain character limit to be passed as a input parameter. If we cross it, stored procedure is not accepting those values. We are getting null values.  If anyone knows any replacement or ideas on how to proceed with this it will be helpful. Thanks & Regards, Kavya

Hello All, I am calling the interface through summary view of record type and create a button in related action. I am having a button in interface as well and when this button is clicked on it should display the related action button. But in my case related action displays after refreshing the page.  Any suggestions would be helpful.

I want to display multiple default options in record filter, but it seems like filter doesn't work when multiple options are there for default filters. Is it an appian limitation? Is there any work around for this? I am using 20.4.

Has any one been getting 503 error trying to export a record type to excel? I am not applying any filters. This is happening for small dataset (5 items) as well as large dataset (3k records). I am seeing this issue in  my community Appian instance 22.4 and work Appian instances in 22.3.  For every failed export attemt, there is a Warning log in the tomcat-stdOut as folows 2022-12-08 16:09:46 WARNING [http-nio-8080-exec-3] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI https://yljk.appian.community/suite/rest/a/dataexport/latest/download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

I have a read only grid with a record type as its source called Survey Data and it displays data from another record related with a one-to-many relationship called Recommendations. I'd like to create a user filter in the Survey Data record type that would allow the user to either see all the rows that have information in the Recommendations record (aka the Survey Data id exists in the Recommendations table), or see all the rows that do not have Recommendation information (aka the Survey Data id does not exist in the Recommendations table).  Does anyone have an idea of how to do this? I've tried setting it up so that it finds where the Survey Data id in the Recommendations table is null() but that did not work. I also have the ability to change this to a one-to-one relationship if I need to. Any guidance is appreciated, thanks!

Hi, I am trying to create a record action and generate a record action, system is throwing an error. I have verified the column name in the database which is showing in the error and there is no such a column. Now, I got struck due to this issue. Can someone provide tips to overcome this. Thanks in advance.

Good morning I have a recordtype field that has values 1,2 and 3. I am trying to have the field value to be displayed as 1 = Draft, 2 = In Progress and 3 = Finalized. can any assist me with this?

How to update a record type field value using the Expression Language?

Hi Appian Guys, a!queryRecordType( recordType: recordType!SellerTeam, filters: a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes". value: "Alex" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) )I want to get teams of including "Alex" only, could anyone give me some good advises?

Hi All, I need to call record type summary interface(configured in views and headers in record) from button widget. How to achieve this? thanks!

Is there a way to sort a record dataset after it's been queried? I have a list of records I got from a queryRecordType stored in a local variable that I am using in multiple places on an interface. I only want the record dataset to be sorted in a particular way for only one instance on the interface, but I want to leave it alone in all other instances, so I don't want to sort the data set within the initial queryRecordType call in the local variable. The only solution I've thought of is query the record again but this time sort it the way I want and store it in a new local variable or write my own expression rule to be able to sort records. I am not allowed to install plug-ins on my environment by the way. Thanks!

Hi, I need to store multiple records in a single table of the database. Is this possible using "Write to Data Store Entity" or do I need to use "Write to Multiple Data Store Entity". Thanks

Dear All, In my earlier project I was using Appian On-premise and Oracle RBDMS, and in current project am using Appian cloud and Maria DB. Am not understanding one scenario, which worked in earlier project and not working in current project. Can some one help me understand this ? Scenario: > There is DB table "Employee" created in DEV & QA. > There is an existing Datastore "DS_TA BLE" in both DEV & QA. > Created a CDT "employee_test" in DEV (From existing Table) and the Data store Entity is mapped and verified automatically. > When I deploy this CDT to QA, Why the Datastore Entity mapping is not happening automatically ?

So I have an interface with a grid that allows the user to preview or download a document. I want to hide the preview button if the file extension of the document is pdf. Initially I was going to use showWhen but I wondered if a!foreach would also work? I tried to use the document() function to get the extension, but I realized it only displays it and doesn't retrieve it. This is what I have for the preview button so far. I haven't configured the download button yet. a!buttonWidget( label: "", icon: "eye", tooltip: "View", value: true(), saveInto: { local!preview, a!save(local!selectedDocument, fv!row) } )

I want to sync the User record that is already exists in appian eviroment.i got the error sync record smart service.

Inside Summary View of Record when clicked on Related Action to edit the record, dialog box is not displayed inspite of that task is getting assigned in tempo inside task tab.

I have a simple stored proc as following. DELIMITER $$CREATE DEFINER=`dbadmin`@`%` PROCEDURE `Test_TruncateTable`(IN `spTableName` TEXT) MODIFIES SQL DATA COMMENT 'Truncates staging table.'BEGIN TRUNCATE TABLE spTableName; END$$DELIMITER ; The procedure won't get executed, it throw's following error. #1. #2. I tried changing the IN parameter to VARCHAR etc. but no luck. In past I have wrote more complicated procedures having multiple parameters however never run into the above mentioned error. 

Hi, Is it possible to pass the entity name dynamically or using the table in query entity? May be have some rule which will take the table name and return the data store entity. Regards, Mukesh

Hi all, I want to replace each "trackerID" from local!test - local!test4 variables with a correct trackerId from local!Ids. Current values in dummyCDT are indexes of their corresponding IDs in local!Ids array.local!Ids values are {24912; 24913; 24914}  a!localVariables( local!test: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 1), local!test2: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test3: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test4: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 3), local!dummyCDT: union(union(local!test, local!test2), union(local!test3 ,local!test4)), local!Ids: index(ri!tracker, "trackerID", null), a!update( data: local!dummyCDT, index: "trackerID", value: index( local!Ids, local!dummyCDT.trackerID, null ) ), ) Is it possible to achievable this way?

I created a new Schema/Database in our cloud database. . However, when I try to connect to the database in my new application (Data Store), it does not show up.

I recently got an error that said this:"The list of records to be saved must not be null or empty: TypedValue[it=3145,v={}] Data: TypedValue[it=3145,v={}] "But how can I identify which field or type its referring to?I assume that "it=3145" is a particular type or field identifier but I don't know how to look it up. I wish it would should an actual name in the error message instead of an ID / "it".

We have a requirement where we display/hide the related actions for a particular record based on the approval or rejection of tasks. We are observing that the even though the record grid data is getting refreshed when we click on the refresh button, but the related actions are not getting refreshed. Please find a sample snippet of the code:- a!gridField( labelPosition: "ABOVE", data: a!recordData( recordType: recordType!SampleRecord, filters: rule!SampleFilterRule() ), columns: { a!gridColumn(), a!gridColumn( value: a!recordActionField( actions: { a!recordActionItem( action: recordType!SampleRecord.actions.SampleAction, identifier: fv!row[SampleMetric.identifier] ) } ) ) }, validations: {}, spacing: "DENSE", borderStyle: "LIGHT", shadeAlternateRows: false, rowHeader: 1, refreshOnVarChange: ri!refreshVariable, refreshAfter: "RECORD_ACTION", showSearchBox: true, showRefreshButton: true(), showExportButton: false,) What can I do to resolve this?

In SQL I would write something like this:SELECT * FROM parent WHERE parent_id NOT IN (SELECT parent_id_fk FROM child)or SELECT * FROM parent WHERE NOT EXISTS (SELECT 1 FROM child WHERE parent_id_fk = parent_id) In Appian expression language I can find children with no parents by finding records with null in the relationship as described here:https://docs.appian.com/suite/help/22.4/fnc_system_a_queryfilter.html#using-a-relationship-reference-in-the-field-parameter The example in the documentation is like so: a!queryRecordType( recordType: recordType!Employee, filters: a!queryFilter( field: recordType!Employee.relationships.teams, operator: "not null" ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data However this is not what I want, I want to find parents with no children.I think it might look something like this: a!queryRecordType( recordType: recordType!Parent, filters: a!queryFilter( field: recordType!Parent.fiel

Hi everyone,  I need to pass a list of INT into a parameter of a stored procedure which should look like this: UPDATE table01 SET updatedDate = now() WHERE ID in (list of ids that I will pass in); However the parameter type only accept INT, not list of INT, so not sure how can I achieve that.  Any suggestion will be much appreciated :)