Records

Hi  I am using Import Excel to  Database Smart service and for Datasource I tried to make connection using Connected System .I called the CS in constant using  CS as its type .But in Import excel smart service , Datasource is defined Text type .Is it possible to give DB connection url string as Text and pass it in constant and then use it .If yes then what is correct connection url string?

this kind of output my SP giving me, and I have used print statement of SQL to print this output,  but when I call SP with the correct input Parameter then it's not returning the result.

Hi All, I'm getting the below errror from the recordtype Can you please help me to find the rootcause for this issue Expression evaluation error [evaluation ID = 4JPG0] at function a!recordList: An error occurred while retrieving the data for "NV_CaseData". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000) Thanks, Udhaya

Are there any limitations for record actions like how many record actions we can create .

I have asked two developers about the best approach for data management in Appian. One usually uses Datastore Entities and other uses Sync Recordtypes. But, I have seen that there is a third configuration where a RecordType is related to a Datastore Entity (this disable recordtypes relationship). Which best approach is my dilemma. I have heard recordtypes limitations related to database (some datatypes capacity limits) schema, 2 millions rows storage limitation and sync issues. I haven't found documentation about best practices for data management. What do you recommend? Some prefers CDT others Recordtypes.

I am looking for different options in Appian to connect with Mongo DB. Please share your suggestions / experience.

Hi all, I'm a beginner of Appian. I usually see a "export excel" button in a record type at the upper right corner, but I could not see it on a record type. In the record type, the following error is shown. "Expression evaluation error at function a!gridField_23r3 [line 51]: The field [b4975317-48bc-4a6d-9ade-949dece38b46] does not exist." In record type, I cannot see expression code, but the error show the code line... How do I see the code in a record type? What i want to do is to export a data into excel... any suggestion please... Best regards,

Our tenant is currently on Appian cloud version 24.2 and experiencing a real-time aggregation error on a custom record field. When editing the custom record field in the record type view, clicking the 'TEST' button displays the following error: ava.lang.RuntimeException: tvJavaBridge is null We have tried removing the relationship and re-adding to no avail. Also, testing the rule in an expression also yields the same result (see screenshots below). Any ideas of what we could try to alleviate the issue?

Hello, I have a doubt and I am unsure how to proceed.   I have an interface where the individual record rows are displayed in a read only grid where I am using the FK of another table to filter and display only those audits for a specific record. The requirement is to display a different background color in the read only grid of the values in the row based on previous entries. For example   FKID Name Temp Approved 1 Tim 20 No 1 Timmy 22 Pending 1 Timmy 22 Yes 1 Timmy 23 Retired Timmy, 22 and pending are highlighted in the second row because they differ from the first entry. Yes is highlighted in the third entry due to being different than pending. 23 and retired are highlighted because they differ from previous also. I have a record query as below and I feel I need to compare the fv!row[currentValue] against the indexed local data somehow but I am not sure how to proceed. a!localVariables( local!data: a!queryRecordType( recordType: 'ADtable',

Hi Champs, I have a grid where I have a column in which I am showing a recordaction component based on some conditions. So that column can show a button(recordAction) or it will be blank.  Now I have a requirement where I need to first show the row where I have the column having the button and then the rows where the column is blank. Secondly, I need to again sort the data based on the name . I am not sure whether we have a easy way to do the same? Regards, Ghanashyam

Can we add new columns to User Uploaded excel with columns and data already in it?  Note: The added column's data is not unique for all the records

Hello Team, can you help me with this here, please? I have a form (parent record), which relates to more or less 15 different tables (records). Most of these tables have a 1-1 relationship with the parent record and, in about 3 of them, the parent record has a 1-N relationship. Knowing that all these tables are filled in the same form, and everything occurs in the same process. What is the best approach in this case? Thanks

For the following table of records, I need to be able to calculate the total of the highlighted columns, (Bid Amount & Principle Balance) so that I can utilize that information to create a list of metrics listed below the Picture. Balance Underwritten Sum of Principle Balance Balance Bid Sum of Principal Balance (Where Bid Submitted? = Yes) Balance Won Sum of Principal Balance (where Bid Won? = Yes) Bid to Underwritten % Balance Bid divided by Balance Underwritten Win to Bid % Balance Won divided by Balance Bid Win to Underwritten % Balance Won divided by Balance Underwritten

We would like to be able to access many schemas in Appian when creating a record type from a sql server table. I have the table created on the server that is in or datasource in the admin console but when I got to select the table in the record type I only see tables that exist in the dbo schema

I have a table with a field "name" which is of text type. It follows a fixed pattern and all the entries are very similar. The entries contain text and numerical values, e.g. Practice 1, Practice 2, Practice 3, ..., Practice n where n can be any number. I need to sort it in the ascending order of the numerical suffix. If I sort it as text only I get something like Practice 1, Practice 10, Practice 2, ..., Practice 9 assuming there are only 10 Practices. However, it has to be sorted as Practice 1, ..., Practice 9, Practice 10 as per my requirement. How can I achieve this?I have attached a picture of my code in the query editor below. I tried casting name to integer using the tointeger() function like below but it gave me an error saying we can't cast on a field.sort: { a!sortInfo( field: tointeger(record.name), ascending: true ) }

Hi All, We are getting the following error as startindex cannot be greater than totalCount. Start index was 31 and totalcount was 0. We are using process report query for querying the data and for paginginfo, we are using fv!paginginfo. We are getting the above error only in prod and we are being notified via the error mail as part of the new appian release. No user has reported this issue. We are not able to understand why this error is occuring. One observation was when errors are triggered, startindex is having 11, 21,31,51 etc. Any suggestions will be helpful

Hello community, There is a scenerio where I just want to add a user filter to popup only with the options that are mapped to a record. e.g. there are 10 reference records used in filter and mapping is like:: Record A - 1,2,3,4 Record B - 4,5,6 Record C - 6,8,,4,3,9 Is there any way to just popup mapped referenced values to the filters for selected records.

Can anyone help me on this : - You need to remove an unused field from an existing record type Product, which has data sync enabled and is backed by a database table. What should you do? A. Delete the field from the record type and optionally delete the column from the database table. B. Delete the field from the product Custom Data Type (CDT) and perform a full resync of the record type. C. Delete the column from the database table and perform a full resync of the record type. 

Hi Folks, Can I hide the count in below grid. FYI. I am getting data from array of maps. Regards, Ghanashyam

Data in reference tables can differ across environments, which directly leads to have different primary key values of same reference data in the tables across environments. But, knowing this fact, still some Appian applications use primary keys of reference data as constant, for example primary keys of workflow statuses are referenced using constants rather than their text value. If while deploying or during data migration, primary key changes, then code written using those constant references may break. What is the best approach to code for above use case?

Helo......Just curiosity, what is the limit or best number for entities that can be added in one Data store, I searched in docs but can't able to find the answer. Thanks in advance 

Hi Champs, There is a requirement where we need to send a link to the user so that they can directly click the record action instead of record summary page. Is it possible? Regards, Ghanashyam

How exactly does a write to data store work in the background? - For a single row, it will surely run 1 insert query, what happens when the data is an array? for each row will it run a single query or multiple ones?

Hi All, I would need an help in understanding is there any way i can PIVOT the table data and export it to excel. Currently my table has data I would need the response in excel as  Basically "Questions" column as row header in excel and Answers as row response. Help is appreciated. Thanks in advance

Could you please help me to find out the correct answer for this question?