Data Fabric

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.

I am using process report. Recently I encounter the below error in the log. Can you pls advise on what would be the best option I should follow to remediate this issue without changing the default time limit? The report generation was cancelled by the system after 2224 ms.The time limit for generating a report is 2000 ms. (APNX-1-4275-008)

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?

Hi All, I have a requirement in which i am opening summary page in new tab, and from previous tab i have deleted that record through record action. Now, when I am going on summary page tab of same record, and reloading the UI, It is showing error like  "An Error has occurred. Record does not exist, either deleted or don't have permission " Please help me if there is any way i can replace this message with custom appian UI showing This URL does not exist and 404 - not found  Thanks in Advance, Shree Krishna Tiwari 

Hi Experts, I am using a grid layout and I have rule input of array type, I want to select data present at specific index in rule input, Please help  me how can I get index of array type rule input? Thanks in advance.

Hi there, I need to export data to an excel file shown below. I know it's easy to use "Export Data Store Entity to Excel" smart service to export the material list at the bottom, but could anyone know how to combine the upper and bottom parts together to export to an excel file? regards, L

Yeloow, I am currently working in a use case, I have an array of Entity data where entites from different datastores will be inside this array, I want to segregate or group the entities by their datastore so I noticed one thing while trying this out, [Data Store Entity:"xxxxxxxxx-xxxxxxxxf-9143-xxxxx8c102b00@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxx-xxxxx-43a9-a20d-3xxxx744b9aae@4872"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxx-4adc-b46f-axxxxa5990bd@6308"](Data Store Entity) [Data Store Entity:"xxxxxxxxxx-xxxxxxx-4c81-9ddc-axxxx0d18e9@6308"](Data Store Entity) after the @ every entities belong to same Datastore have the same 4 digit number so I assume entites belong to same Data store have these 4 digit number common, is my assumption right ? can any Appian legend confirm this [emoticon:4191f5ee34e248a29fa0dbe8d975f74a].  

How to query table count from oracle DB and display the result in appian screen? I have used the below "Query Database" smart service to fetch the number of table count from DB. But I receive the below error: "You should enter only a single query in a row." My query - SELECT COUNT(1) AS NO_OF_TABLE_CNT FROM USER_TABLES;   Please help me to get the table count. Is there any other option available apart from using this Query Database smart service?

Hi there, I am trying to convert a CDT to excel,  but notice the smart service "Export CDT To Excel" is "Deprecated". I dont want to save the data into database, then use "Export Data Store Entity to Excel". could you please let me know what I can do here? Regards, Lin

Hello Everyone, The parent process model unable to trigger the child process calling through the Start Process node. The same child process model trigger fine when trigger through the "sub process" node as synchronous/Asynchronous . Verified the parameters thrice and every thing looks good.Also Observed below error in the logs. 2022-03-04 19:02:01,035 [ajp-nio-0.0.0.0-8009-exec-358] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536873219, classname=com.appiancorp.process.runtime.activities.StartProcessSmartService2 com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.invalidProcessModelParameters.userMsg=Unable to start specified process. Either values were not provided for required parameters or the specified process model is invalid. Process Model ID: 1552.] alertMsg[error.invalidProcessModelParameters.alertMsg=Unable to start specified process. Either values were not provid

Hello Everyone, We have a use case where in we need to nightly refresh our look up tables( truncate existing data and update if integgration is success)on daily basis. As our application is record centric I am planning to use service backed record to external system.However I have below questions to clarify before I proceed. Do we need to hit the API twice? once to check if it’s success and second to populate the record? To truncate the existing data I am thinking to use delete records. Also, Unsure how serviceback record handles if integration fails. Please let me if this approach is suggestable for the above use case. Thanks in advance.

How can we find difference between 2 cdts and capture the changes in Audit table . what could be the best way to do it . TIA

Hi folks! Good day!! I am facing one issue while configuring the record directly in read-only grid and configure the recordActions But while clicking the Add new role button and clicking the Create or cancel button, I am facing the below issue. Note: This will work properly in the Record under the Tempo site. Could you please help me with this?

Hi I have below code: when i am clicking on add row link value is getting save in CDT structure but not displaying added row in design preview what is wrong in that?

Hi all,We are using record type PVs in our process model and passing the same to user input task. In the task, we are updating the values and after submit is clicked, we are updating the variables to database using write to records smart service. But when we are doing the same, the values are getting updated in pv level, but not getting updated in database. All configurations are correct inside the process model. Not sure what is the gap in this? Please provide your insights.

Hi All, We are using "write to data store entity" smart service for storing the data into the database and getting the below error and there are no unique constraints declared in the XSD and Table. Below are the two requests which occurred while executing the smart service Error 1: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=VT_TASK_MASTER (id=3112)] (data store: VT Tables). Details: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00001: unique constraint (APPIANBUSINESS_PROD.SYS_C0059560507) violatedData: TypedValue[it=3113,v={{<null>,43,Initiation,initiation,1,Employee,User(s),7,1,ltideploymentAccount,2024-08-05 14:47:12.64,,<null>,1,[Group:1261],0}}] Error 2: An error occurred while trying to write to the entity "VT_TASK_MASTER" [id=99aa89ed-622b-477f-9671-2c22df01831b@1429, type=

On 24.2 - I have a Product Record Type with a 1:n relationship to a Assignment Record Type. I need a custom record field on Product to show the "current assignee", which is one of the many Assignments, based on the product's current status and assignmentType. Since custom record fields do not support 1:n relationships, I thought to create a composite key following this recipe https://docs.appian.com/suite/help/24.2/custom-record-fields.html#create-a-composite-key.  The problem is I cannot find where to mark the new custom record field as unique. What am I missing? 

How can we display more than 5000 records in interface and search by custom picker? Anyone having Idea?