-
Recently active
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
Hello all, I would like to use queryEntity to add a filter which uses LISTAGG function in the database view. I'm trying to add DECISION filter something like below: select * from DB_VIEW where RECEIVED_DATE > to_date('6/1/2021', 'mm/dd/yyyy') and (DECISION like ('%Disapproved%') or DECISION like ('%Approved%')); Now the issue is, we do not have 'like' value for 'operator' in a!queryFilter. How can I add 'like' operator to get the filtered result on a view in the Appian Report?
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]))])
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,
Hi All, I created an entity backed record on the main table which works as expected. However, as part of requirement we require to do search on the data in the child table which has one-to-many relationship (for each entry in main table, there can be multiple entries in child table). I tried using expression-backed record. But I'm only able to display the entries of child table, but cannot search on those fields. Is there anyway we can do the search on child table from record default search? Note: We are currently on 21.2 and explored the new feature of adding relationship for records. However,it does support only Many-to-One and one-to-one relationship which is of no use for our use case
Hello, yesterday we lowered our process report timeout limit from 5000 to the standard 2000 ms but now we see a lot of errors in our log. The errore are like the following. 2021-06-01 12:43:00,375 [Appian Work Item - 147135 - execution00 : ExpressionGroupRequest] ERROR com.appiancorp.expr.server.fn.query.QueryProcessAnalytics - La generazione del report è stata annullata dal sistema dopo 2748 ms. Il limite di tempo per generare un report è 2000 ms. (APNX-1-4275-008)com.appiancorp.suiteapi.common.exceptions.AppianException: The report generation was cancelled by the system after 2748 ms. The time limit for generating a report is 2000 ms. (APNX-1-4275-008) Is there a way to identify which is the report which is throwing this error in order to improve its performance? We have a lot of process reports in our environment and they all seem efficient. I think that the issue is caused by some filter in some queryProcessAnalytics rule, but how to identify which? This error d
I have a entity-backed record, with sorting applied on Transaction Id. While sortinfo is on date field. Sort is not working as expected. When i first land on the page, sorting on descending as expected. When i click on next button to get next 25 records, getting data starting from 26 - rest. Again if i click back icon, seeing records from 1-25 instead but not the data form screenshot-1. Any suggestions please?
Hello. Can you use a CDT as the rule input to create the Summary view of a record? Thank you
I have a use case where I need to use the data in Microsoft project file (MPP file). Tried converting it to an excel file and using it, but after converting because of merged rows, parsing data to cdt is not working. Any leads on how to resolve this?
I have a record with multiple related actions displayed as cards using the a!recordAction field on the record summary view. Currently, when the user clicks on a related action, all of the data for that related action is queried in local variables on page load. Many of these related actions use the same queries, so if the user clicks on two different related actions, they need to wait for that query to execute each time. The queries can be quite slow, so I am trying to figure out a way to query more data up front before the user goes into a related action so that a) the page load is faster, and b) the same query does not have to be run for each related action. I tried adding additional fields to the data type of my record, and querying for the additional data I need in the Single Record Source query to populate those fields. Here is an example of what I tried. This is a genericized version of the rule that I use on my record to query a single record (th
Hi Team, We are currently using the Microsoft SQL Server with 8 millions of records which we are thinking to migrate to appian internal db Mysql , Is this the good idea? Is Mysql db what appian provide will have the capacity to insert millions of data How the performance looks when I try to pull that data in Appian reports? As of now it is 8 million but it get increase day by day , What are the suggestions? Thanks, Udayasai
Hello, we are exporting DB data to excel where we have one column for Appian user id .we are using a!exportDataStoreEntityToExcel to export whioch igives all the columns as it is which are in DB but we want to convert Appian user id to first name and last name before dumping to excel. Is there any way I can do it using a!exportDataStoreEntityToExcel without saving first name and last name in DB. Any pointer will be helpful. Thanks in Advance.
Hi every one, we are trying to implement some reports regarding process behavior, task duration, average etc. but before going into a big definition I was wondering if appian contains "out of the box" this kind of reports, and if so, where can I find them or configure them ??? Ive found a related issue in the forum but fron 6 years ago, so maybe somethings have change? any help with this will be much appreciated ! Hope to hear form you soon! Regards, Diego
Hello, I have to create a report in which iam fetching the datas from Database using a function a!exportDataStoreEntityToExcel(). Is that possible to transpose the data from DB which is like Column to row or row to column using this service ?
Feature Request: Enable local variables where we can query or get some important data related to a record item so that it can be reused in all the of the related actions visibility because we usually do same set of queries/group checks most of the time.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
