Records

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?

I am currently having an issue with one of my record types not appearing to sync correctly. We have a Process Model set up to schedule a set of tasks for users and write all of these details into a table to hold these scheduled task details. We also have two separate record types set up to display different task types. Both of the record types have source filters set for A) their task type number and B) anything scheduled for yesterday and today's date. The Process Model is set to run daily at a given time, and every time after, it appears as though one of the record types is out of sync. There will be extra items in the record type list, and one of the columns will contain a null value. However, if we go in and do a manual full sync, all of the data will display correctly immediately after that.My question is about whether or not the date value in the source filter is messing up with the syncing of the data. The way the source fields are displayed, it has the text "Define whi

I am using a grid to show record list where i have added pagination, when the list is loading first time and i am clicking on arrow button to go to next page in not working but when i am clicking the same button next time then it is working fine Here i am using the refresh variable and using the refreshAlways set to true, when i am changing it to false is working fine, below code i am using in list page. a!localVariables( local!jobId:null, local!localeDetails:rule!SDL_getLoggedInUserLocale(), local!labels: rule!JT_getTranslation( locale: local!localeDetails, labelId: { "jobId1", cons!JT_LABEL_JOB_NAME2, cons!JT_LABEL_EXTERNAL_JOB_ID, cons!JT_LABEL_CLIENT_DIVISION, cons!JT_LABEL_CLIENT_NAME, "createdOn1", "initiatingPm1", "status2", "phase2" } ),{ a!gridField( label: "Jobs", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{d495f140-8079-4d18-a9ff-667d19dacd59}Job', filters: a!queryLogicalEx

I am using a grid to show record list where i have added pagination, when the list is loading first time and i am clicking on arrow button to go to next page in not working but when i am clicking the same button next time then it is working fine Here i am using the refresh variable and using the refreshAlways set to true, when i am changing it to false is working fine, 

I have a grid where i added pagination, when the grid is loading for the first time and i am clicking first time on the arrow button to go to the next page is not working but if i click in the arrow button again is working fine. I used RefreshAlways set to true, if i set it as false and testing the interface is working fine, below code i am using. a!localVariables( local!jobId:null, local!localeDetails:rule!SDL_getLoggedInUserLocale(), local!labels: rule!JT_getTranslation( locale: local!localeDetails, labelId: { "jobId1", cons!JT_LABEL_JOB_NAME2, cons!JT_LABEL_EXTERNAL_JOB_ID, cons!JT_LABEL_CLIENT_DIVISION, cons!JT_LABEL_CLIENT_NAME, "createdOn1", "initiatingPm1", "status2", "phase2" } ),{ a!gridField( label: "Jobs", labelPosition: "ABOVE", data: a!recordData( recordType: 'recordType!{d495f140-8079-4d18-a9ff-667d19dacd59}Job', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFil

I am getting this error when performing an related action .can any one help me in this? 

Whenever If i click on the firstname it have to link to the interface already i have , which link tag i have to use and where to use here. Finally i want to use thoese in sites . In Cadidate first name The link should link to interface The expression  Need to display in that site