Records

In my Appian cloud database, I need to figure out what type to list for my resume upload field. In my database I have a blob so what do I use in Appian? I cant use a text....

Hello All, I have added readable grid into an interface and linked the record to this interface which will provide me all the fields of the record. In the record user filter option available part of the a!gridfield. In the record I have enabled set showSearchBox to true which provides us with a global search option. But I have a requirement to add filter for text field for example, Iike CustomerName The version I'm using is 21.2, any alternative way to achieve this? Thanks & Regards Girish

How can I remove accent (replace special character) from the text  Input: "Cámara" Desired Output: "Camara"

Hi all, I have created a entity-based record type which is based on a view.  I have created a user filter in the record based on a!recordfilterlist function. The user filter does not give correct result.  The field on which I am using the filter has null values in the view.  Can someone help me to fix this ussue? Thanks in advance.

While creating record type, why we create additional views except summary view in record views?

Hello Everyone, I am using below pagingInfo , gridcolumn , and pagingSaveInto in my interface where Approval Date is of datetime type local!pagingInfo: a!pagingInfo( startIndex:1, batchSize: -1, sort: a!sortInfo(field: "APPORVAL_DATE") gridColumn( label: "Approved On", sortField: "APPORVAL_DATE", value: fv!row.APPORVAL_DATE ) pagingSaveInto: local!pagingInfo  If approval date is between 7/1/2021 and 7/12/2021 then  Expected result to be sorted by Date ie. 7/12, 7/11, 7/10, 7/9, 7/8, 7/7 and so on but sorting is not applied to the grid and resulting data is random sequence like 7/11 7/12 7/1 7/2 and so on. Thank you for suggestions in advance.

 Hi all,I want to sync data from my database view to record type but it is not visible. Other object from database that is table is visible. Can someone confirm that this is Appian limitation so that I can ask my DWH to create table with data from that view?Thank you.

I have a record for cases I have been creating in my app.On record grid when I click on caseIds a process model is invoked and flow is taken further.I want to create for url for different records based on user need. For general records with summary view I am aware of the steps.How do I create for this scenario where I dont have summary view/related actions;just record grid with each id invoking new process. Early response is appreciated thanks!

The following "Generate Summary" is missing from my record view. Is this something that isn't included in version 21.1? 

Hi All, Does anyone knows how to add custom record field in new record 21.2 with below scenario? Custom field need to add on single DueDate record field.  1. Groups based on Date difference does not work here since it required to two date fields.(Start and End date) 2. Own expression having limited functions to use(Why there is limitation on using functions while creating custom record field? Will it be changed in next upgrade?) My scenario would be like this.(Below is SQL statement) IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) > 0, 'Before Due Date', IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) = 0, 'Due Today', IF( TO_DAYS(`CASE`.`DUE_DATE`) - TO_DAYS(CURDATE()) < 0, 'Missed Due Date', 'N/A') ))

Can the query data size could be more than 1 MB, if yes, how to find out exact size in appian ? 

Hello, The data in my database is of form yyyy-mm-dd. While filtering data, I want to ignore the year. How can I do it? Thanks.

Requirement : Team we have an admin application which performs some write to DB , currently cdt is hardcoded as scope is limited to some apps. Now we want to make it dynamic like after selecting datastore it should populate all the CDT associated with it or a custom picker to just search from all the CDT of system. Any idea?

Hello !  I am fetching records from an external RDBS (Oracle), making some calculations in an expression rule in Appian, running those records to compare if already present in the local Appian tables, if yes, updates the local record with any changes else inserts a new record altogether. Pretty straightforward. This works as expected.  I am noticing on monitoring the data fetched that there are records retrieved but not inserted into the database. There could be say 2 out of 15 that are missed.  The comparison logic I have is a simple for loop that looks something like below: if( rule!WS_isNullOrEmpty( ri!rece_cdts ), {}, with( local!parIds_texts: index( ri!rece_cdts, "parId_text", null ), local!existingRece_cdts: if( rule!WS_isNullOrEmpty( local!pars_texts ), {}, rule!WS_getActiveReceByPartyIds( partyIds_texts: local!parIds_texts ) ), a!forEach( items: ri!rece_cdts

Hello, I need to update the data of multiple rows. For example, there are multiple records with requested status and I want to change them into submitted. There is an editable grid from where the status is changed which is used by Admin. The record view is used by the user. What I think:  To make something when admin clicks on submit the status value update the record with the updated status automatically. Note: Value of status is already submitted, but it hasn't changed the record from requested to submitted in the record. I do not have access to Database. I am new to Appian. If you find anything missing kindly reply. Thanks

I have a List of Data of type CDT, i wanted to convert that into List of varient to use that data in A!forEach() ??? 

Hi. Can i add a link to another record/view in a summary view? Thank you.

Hi, Could someone let me know ? 1. what are scenarios where we can use ? a!recordActionItem() 2. Why do we need to define the default value while adding a row using Add Row link?     is it mandatory?      addRowlink: a!dynamicLink( label: "Add Employee", value: { startDate: today() + 1 }, saveInto: { a!save(local!employees, append(local!employees, save!value)) } ) ) }3. In what scenario/s we will go for Editable GridThanksFaisal

Hi, I have a question: When you have some multiple dropdowns (with items stored in reference table), do you always store your data in 2 different tables ? a first table for the data source, and another table to save the multiple values and make the link with the first table. I have already seen, multiple values stored in a single table with concatened values to store the keys in a text field, but unfortunately, this seems not a good way because of the DB foreign key constraints missing. Regards

I am attempting to create a site to view the data from a web API on Appian. I set up the integration, which seems to return the results just fine: However, in the record data source, it only shows the first part of the results: I would also like to note that I am attempting to adapt from the tutorial on the SpaceX tracker on Appian Academy. Thanks.

Query Entity fails when using operator "include" for the column having NULL value in database. I am using view to retrieve the data. This is working fine when I remove the query filter having "include" operator. Seems "include" is having problem with columns having null values specially in case of view. Anyone, please suggest some solution around this. Exception details: Expression evaluation error at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TWMVwDocumentMappingDT4091], query: [queryentity expression], order by: [[Sort[isDeleted asc]]], filters:[((isDeleted = TypedValue[it=26,v=0]) AND (siteId includes TypedValue[it=3,v=AB41855]))])

Query Entity fails when using operator "include" for the column having NULL value in database. I am using view to retrieve the data. This is working fine when I remove the query filter having "include" operator. Seems "include" is having problem with columns having null values specially in case of view. Anyone, please suggest some solution around this. Exception details: Expression evaluation error at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [TWMVwDocumentMappingDT4091], query: [queryentity expression], order by: [[Sort[isDeleted asc]]], filters:[((isDeleted = TypedValue[it=26,v=0]) AND (siteId includes TypedValue[it=3,v=AB41855]))])

Hi, I have a requirement where I have to query the data from database for a particular column of type CLOB which has data more than 1 MB and display it in a text file . While fetching the data from queryEntity it is reaching to memory threshold or it is reading the column data as null while trying to fetch the output directly from store procedure to flat file. Please recommend me some way of how we can handle large files in Appian. Thanks in Advance!

I see this tilde every-time the value of my floating point reaches 9999999999999. Does anybody know why?

Team, Scenario, We have a UI where Admin team selected the table from dropdown where they want to make changes . Now i have to send that CDT as an input to write to datastore from interface. Can this is something we can do , entity remains same but input changes based on user selection . What to select in type usually we select CDT for which we want change , but in my case it will come from UI. Any thoughts how to do it ? or any other solution basically based on table selection we need to update a value in one column,