Records

Hi, I have below Record Type(s) structure. Now when I try to load the column(s) data in the summary page from the RecordType "D", it is not loading. But, when I ran the "Data Sync" for the recordType "D" manually then I was able to see the data in the summary page. FYI: RecordType "B" is having a foreignkey relation ship with column data which is there in the RecordType "B". Any tips please. Thanks in advanse.

Use Case : I will be uploading multiple documents for a single question - Document to questions (many to one relationship ) I have a CDT for Question and another CDT for documents.(Questions and documents are two different tables in database.) Since, I need to populate the document id in the document table based on the questionaries entry - For now, I am getting the primary key of question table first (after making an entry in the database)and then  trying to pass the value to document table for multiple rows. I am making an entry in the Question table via the process model using write to data store entity smart service, then using a script task I get the ID (Primary Key) of the newly inserted Questions and save it against a new process variable. Then, there is another write to data store entity smart service and in the input node I have mapped the newly created Questions ID against the particular column. When there are multiple attachments, only the first row gets

How can I get the list of active and inactive users without using any plugin?

I added a new Record Type that is associated with a table in my database.  Next, I added Record-Level Security.  Then, I attempted to use the Generate New Action assistant to add a Create Action for the new Record Type.  I make no changes to the default values defined by Appian.  When I click the Generate Action button, I get the following message: Your record action and supporting objects could not be created. Try generating the action again or manually configuring the action and supporting objects. There is nothing special about the Record Type.  It is associated with a database table that has a primary key defined.  I have been able to use the Generate New Action assistant for other new Record Types without receiving this error. This error first appeared AFTER the recent system updates to the Appian Community Edition were completed. I have not received it in the past. I have added 4 new Record Types after the recent sys

There is a function getraurlstubbyrecordtype() in 19/.4 to get the url link directly to edit the record but its not working for 21.4. Similar way can we generate the URL in 21.4. Can any one help me with the code how to generate .  Thank you .

Hi, I have a main recordType along with few relationship. Now when I try to show one of the field data from the sub relationship, it was showing like a continuous data even though those are multiple record columns. I would like to show some type of character like ";" at the end of each column data. Example x; y; z instead of xyz Can someone advise on this. Thanks.

Hi, I have written an userfiler insider a RecordType with an expresson. When I try to use the filter in the user interface and after selecting the item from the dropdown, I am getting an error below in the below attached 2nd screen shot. Any advises please. I am getting an error like below

Hi, I need to provide a filter with a date range to filter data in a read only grid. Is there any specific control which can give the behavior similar to the RecordType user filter of type  "data range" (Attaching the screen shot)

Hi, I am using a RecordType to load the data into a readonly grid. Also, I am using few user filters to filter the data in the grid. So far so good. Now when I try to export the data into an excel it is loading only the columns which are there inside the grid. But, my requirement is load all other columns including the columns which are not there in the grid. I know there is one server to export data using the service "Export Data Store Entity to Excel Smart Service". I would like to know is it possible to export the RecordType into an excel using this service. Thanks.

Hello, I've created a datasubset using a!foreach. Now want to filter the data on the datasubset depending on the value for one field. Can you please suggest on this? a high level snippet is below. Below rule returns a datasubset & on that datasubset I am trying add a filter.  todatasubset( a!forEach( items: rule!Irulename(), expression: 'type!{urn:com:appian:types:cdt}|cdt_name'(fields:, completed: rule!newRuleToupdateafield )) )

Hi, We are using Picker field to search client name based on id, using an expression rule to get result of data subset when user enter id or client name. Minimum four char should provided by user in picker field search so that query will search the matching data and displays first 10 ids. For some ids while searching in picker field, getting an below error: An error occurred while retrieving the data. Details: Unexpected error executing query (type:LKTableDataDT2865], query: [queryentity expression], order by: [[Sort[id asc]]], filters: [((id = TypedValue[it=3,v=9000152]) OR (clientname includes TypedValue[it=3,v=9000152]))]) Here, in LKTableData we have records around 19lakhs plus. Regards,Sandeep

Hi Team, We actually have an related action in our record but when we try to open it from android mobile app it is very hard for us to see the related action icon, Even i was not sure why record title is taking the color of site navigation bar color ,Due to this the icon is too hard to visible to users, Please let us know if you have any suggestions Thanks, Udayasai

Hi  I have a main RecordType  which is linked to another RecordType "recordattorneys" which is internally linked to another recordtype "attorneys". Now when I try to set up "user filter", I am unable to do. Getting an error message like "Please add at least one filter option". FYI: I have a one-to-many relation between main recordtype and "recordattorneys" and many-to-one relation between "recordattorneys" and "attorneys"

When I tried to get data using a query filter for a custom picker and when I tried using record picker, I could find a significant performance difference. Record Picker was very fast when compared to a custom picker. How does record picker work and can we do the same for a custom picker also? And I  would also like to know how record type actually holds the data, is it like a cached memory or it fetches every time? Can someone help me understand this?

Need to immediately sync record data after executing the query database node. any work around helps.

Hi, We have a Record Type based on a MySql view, and we just added 2 new fields in the concerned table and in the view. When we used the RecordType, all works fine, the 2 fields are well visibles from Interfaces, ER, or the RecordType itself. The only issue we have is when we try to deploy this component with the Visibility set with the code below (cf screenshot). Please see the error is below. When we leave the "Visiblity" section to true (default) all works fine. When we put back the code with new fields, the error still appears. Yesterday to get out of this situation, we set the Visibility with an ER to not evaluate anymore the new fields with the rv!record[] function, to deploy it. Today, we tried again to set the initial code, an now, it works !?? Would you have any explanation ? Deployment log : 2022-06-15 13:53:19.88 ERROR recordType 6dfe1b0b-91a9-46c0-8133-d6c88103606b The recordType [id= uuid=6dfe1b0b-91a9-46c0-8133-d6c88103606b] was not imported

Hello  I am trying to generate Record Actions for my DB but for 1/2 of my Record Types I am unable to do so. I have tried to generate these actions both with CDT's generated by Appian and also by me (inside Appian) but I always get the following error. I have read similar threads but no solution.  

Hello All, We observed one issue 1. Parent CDT -> one of the columns type is document 2. We updated the child CDT (added a new column) upon updating the child CDT, the parent CDT filed type changed from document to anytype. Did anyone face the same issue?

Hi All, I have requirement to get the data from an external systems and import into Appian. Firstly, I need to get data from the external source and later need to store in Appian Db . How can be this achieved?? Thanks & Regards, Sravani Manyala.

for my summary page i want to add a aprrove button action . how can i do that

I have created a from and created a process model so that data can be stored in DB .after submitting the form i want to show in a new interface that what details i have submitted. Can we able to see the check boxes also in the summary ?

How to update the existing view(created using joins and tables)  with new column and change the existing column i.e "ID" field (which is having foreign key constraint ) in the cloud database

Before  the update i was  able to  make a filter just for the loggedinuser but now i'm getting this  error  is there any way for filtering a record   that allow the logged in user to see just te  info  requested by himself.  

Hello, I would like to create a CDT with a primary key which must be an Auto-generated value but with a prefixed value.  Ex: "APP_01", Where the number 01 must be an auto incremented value. Is it possible to do so? If yes please suggest me a possible way to do it. I was unable to understand the following: Generating primary keys When using a sequence to generate ids (such as @GeneratedValue(strategy=GenerationType.SEQUENCE)), we recommend allowing the system to name the sequence instead of providing a name with the generator attribute. If you choose to define a sequence generator with the generator attribute in conjunction with the @SequenceGenerator annotation, then you must provide a name, and that name must be unique across all sequence generators in the system to avoid uniqueness constraint violations https://docs.appian.com/suite/help/22.2/Database_Schema_Best_Practices.html Please help me with the above.

Is it posible to configure the action button "Delete Item" so it just deletes that item from the Record, but not from de Database? Do I do that from the process model? Thank you!