Data Fabric

I have a column in the record type of DATE type.How do I create "no of records per month" column chart?

Hi there, is there please any function which will return the last letter from a text string. For example if: local!invoice='FY20221227" then the function will return 7. Thanks

Hi Team, I am working on the history table of my Appian application. I created a new table in the database having a similar column of my application in addition of 3 new columns modifyby, modifyat, and operation(create/update/delete). I created a corresponding record type/data type as well. The entity mapping on the Datastore is also successfully done. Now while I am updating my code on create/update/delete interface to fetch the action history of my app, I am getting errors. This is the code:- buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", saveInto: { a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{b5d840ba-2408-425d-b829-510414356ac2}serialnumber']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-942c-a8fd3d0dfa62}NH_Handover_History.fields.{d7f705b2-c020-47c9-95c4-cbe0e6df18a2}addedby']), a!save(ri!record['recordType!{031f0b84-9549-4b3a-94

Hi,   I want to filter a record by its data types. Which type of filter I need to add on my records Type?.

Hi Everyone We're trying to write multiple records using write to record smart service on interface. But we're receiving below error -- The input "Records" must only include records from a single record type. can anyone please let me know what is wrong with the below code? a!writeRecords( records: { ri!taskDetails, ri!caseDetails }, onSuccess: a!save(ri!teadOnly, false()), onError: a!save(local!error, fv!error) )

Can we pass data of CDT type into a database table using Execute stored procedure smart service just like how it is done using Write to datastore entity smart service? Or else do we have to pass each and every data of cdt as a separate parameter using Execute stored procedure smart service? Thanks in advance.

Hi,Can anyone tell the difference between Write to Data Store Entity Smart Service and a!writeToDataStoreEntity() function?? I am asking in the context of place of usage. As best practices, what are the specific places we can use the above mentioned? And is there a way to catch the error occuring while writing to DB using Write to Data store entity smart service???Thanks in advance

Hi all! For my application, I need to acquire the data type and length (and the number of decimals in case of a float) of all the fields from a single Record Type (and preferably the source fields as well). Now, as far as my knowledge goes there is no out-of-the-box solution for doing this. For acquiring the data types of a Record Type I have made the following solution:  /*Partly based on the solution provided in https://community.appian.com/discussions/f/general/23723/map-with-variable-key */ if( rule!isVoid(ri!record), /*use your void check expression here */ {}, a!localVariables( local!xml: toxml(ri!record), local!json: a!fromJson(a!toJson(ri!record)), local!keys: a!keys(local!json), local!types: extract( local!xml, cons!XML_FIND_TYPE_START_DELIMITER, cons!XML_FIND_TYPE_END_DELIMITER ), cast( typeof(a!map()), reduce( a!update, local!json, merge(local!keys, local!types) ) ) ) )

I've got a dictionary of values and I would like to either loop through it for a grid, or convert it to something I can loop through. How might I do that?  For example, I've got this dictionary: {A: 3.1, B: 2.2, C: 1.3} I'd like to have a table that is something like Name for the first column containing A, B, C and Value for the second column with the various numbers in there. I'd like to also record a similar in thing in the database. How can I do that? 

Hey Appian Community Team, I am currently trying to map v22.3 relationship properly to an outer join that is SQL based query which is a view itself. Fundamentally im talking about inner and outer join to map for e.g. PID to REF PID. I was thinking of source filter but it will probably face limitations as well. An extract of the code is listed below (SELECT A.REF_PROPOSAL_ID, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CODE END, ', ') WITHIN GROUP (ORDER BY CATG.CODE) CATEGORY_CODE, LISTAGG(CASE WHEN CATG.IS_SUBCATEGORY = 0 THEN CATG.CATEGORY END, ', ') WITHIN GROUP (ORDER BY CATG.CATEGORY) CATEGORY FROM ABC_PROPOSAL_CATEGORIES A INNER JOIN ABC_PROPOSALS P ON A.PID = A.REF_PROPOSAL_ID INNER JOIN ABC_CATEGORIES CATG ON B.PID = A.REF_CATEGORY_ID GROUP BY A.REF_PROPOSAL_ID ) B,

He everyone! So, I've created a ER to fetch data from database, using a stored procedure. However, it seems being limited by 1000 record by search. Is it possible to change this config. If so, anyone can tell how should I procced ? One option it to dismember the search and do it little by little, until fetch all data requested, but I rather to try something more easy and smart.

Hi, I have a situation where there is a need to identify the duplicate entries in a database table and delete the duplicate rows. How can I do this?

Hi , when I sort on a record backed read only grid , sort field that is stored is in the format #"urn:appian:record-field:v1:ff132d24-cf88-4234-88ae-9fe224dd3dfd/b05761f7-3e63-4e76-bb2b-10c4886815d8. I need to store this sorting preference for each user level. This is not being stored in record field type. its type is string. Even if i want to cast it to record field I am getting error that cast invalid. Only way i could find to covert this into a record field is by using eval() function. But eval() function is a hidden one. Can some one give me an idea on how to handle this? Thank you

Hi there, Our business is having a problem when using a queryEntity in Appian for a certain field. It converts that field to an NVARCHAR(4000) (I'm assuming because it's a text field) even though our Database and Data Type have it listed as VARCHAR(50). In SQL Server, when comparing an NVARCHAR to a VARCHAR, it causes an implicit conversion of all data in the VARCHAR column which is a big performance hit for us. Is there any way to make sure that the parameter uses VARCHAR(50) instead of NVARCHAR(4000)?Thank you

Hi All, I am working on a use case, where I have configured record with integartion(service backed recordrd type) using a dynamic link in a grid to redirect to summary page, I am getting "The record data does not exist, has been deleted, or you do not have sufficient privileges to access it. (APNX-1-4205-006)" this error while clicking the link to see summary . Can any one please help me what configuration needs to be established to see summary page. .a!localVariables( /* 1. First, configure the integration object to return successfully */ local!integrationResponse: rule!GI_INT_GetClaim(adjustername: "ABC"), todatasubset( a!forEach( local!integrationResponse.result.body.claimsList, cast( typeof( 'type!{urn:com:appian:types:GI}GI_RESP_GetClaimSummaryClaimList'() ), fv!item ) ) ) ) I am getting this output. Am able to see the data in the grid but not able to view summary. Help me to resolve the issue.Tha

I have a application , where customers can see their invoices . For ever customer we provide a user id . we store all the invoices across the customers in a recordtype  INVOICES. Now when a specific customer logs in this is the start page. I want to show only the records (invoices) speciifc to customer I am using SITE and Invoices as Records/List

Hi Team, After creating a CDT properly, I am unable to verify  Entity mappings in the data store. It is giving me the below error. Note:- Record type is generated and synced with the table already available in the DB. I want to keep my table name in uppercase [NT_NH_Handover_History] but during entity mapping i downloaded DDL, it is asking me to create a table with the name in lowercase ntnhhandoverhistory. I have to keep the table name in upper case. Could you please suggest?

Using the a!syncRecords function is there any way to see that the record has synced? I looked at the actual Record and the sync history was not updated.  I looked at the tomcat log but can't tell what would indicate the synced record?

Hi all, We are switching to a full record centric approach for our new projects. In our old projects we used to have an expression rule "XXX_setCdtDefault()" this would set the fields createdBy, createdOn, lastmodifiedBy and lastModifiedOn for each CDT right before saving. if( a!isNullOrEmpty(ri!cdt), ri!cdt, a!update( ri!cdt, { "createdOn", "createdBy", "modifiedBy", "modifiedOn" }, { a!defaultValue(ri!cdt.createdOn, now()), a!defaultValue(ri!cdt.createdBy, loggedInUser()), loggedInUser(), now() } ) ) Since we will now use the Write Records smart service, we are no longer working with CDT's. Is there a way to do the same thing as before in a generic way for record types. If we want to update a record type, we need to pass the references to the record fields, so we cannot use the generic "createdOn" etc..I have come up with a workaround as shown below, but I would prefer it if we could j

Hi I am using The "Import From Excel to DB" smart service. The data so written into the DB is not synced with the record type for the same DSE. For using "Sync Records" smart service it is asking the identifiers of the newly added records, which i do not have. How do i force a sync after the data is extracted from Excel to DB?

Here I want to get the most visited top 3 destinations and the count of journeys on each location.(relationship between 2 tables) So make an expression rule for that. but I need to do with record type with the use of a custom record field, here i found the custom expression rule, anyone guide me on how to use this code with a custom expression rule in record type? code below here a!localVariables( local!data:a!queryRecordType( recordType: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey', fields: a!aggregationFields( groupings: { a!grouping( field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.relationships.{324614a4-84f3-45b4-bce2-95cbc8b65b6d}vsDestination.fields.{dbe0e7f1-b3d7-456b-9d82-e81a9042d256}name', alias: "name_grouping1" ) }, measures: { a!measure( function: "COUNT", field: 'recordType!{64a0e01d-65e7-493d-8373-98dd241cb809}VS Journey.fields.{1209585a-f527-4ad9-b1fc-cc7ccc5dd973}de

Hi My application is currently running on Oracle, and we have more than 1000 entities created as CDT's in Appian for the database. Now we are migrating from Oracle to MySQL. Now Can I change the source of the existing CDTs from Oracle to MYSQL from their XSD files without creating new CDT's. Any suggestions please. Thanks, Srikanth

Hello guys, i am trying to combine my list of contract numbers with contract line attributes, where a contract line can have multiple lines. So for example my list of contracts (local!contracts) contains attribute like name, id, etc... The contract line items (local!contractlines) contains different attributes of a contract like chargetype,currency,lineId, amount, etc... If there will be only 1 line of contract i can easily achieve the required output using a!forEach like this: local!finaloutput: a!foreach(                            items: local!contracts,                            expression: {                           {                            contractName: fv!item.contractName,,        

Hi, I am trying to make an interface wherein I have a read only grid that displays data from a table stored in the database. Now I wrote an expression rule to fetch the data and passed it in the data parameter of the read only grid. I want to implement pagination so that only 10 records initially are shown, clicking on the side arrow button '>' will load the next 10 records i.e. I will be running the query again and again for every 10 records changing my startIndex and batchSize. this will ensure that the query will not fail if the data is huge. I wanted help in implementing the pagination as I tried implementing a few things and it didn't work. I'll attach what I have implemented. PS : The pageSize parameter will not work, as the requirement is to "not use" pageSize.    This is the expression rule where increment tells the batchSize, and times lets me tell the startIndex This is the interface code

I need to create a pie chart from the output of multiple expression rule. How can this be done?