-
Recently active
Need help to design & create records for below requirement, Each day 1 parent file and 8 child files will be loaded into DB table. Each child file will be having separate columns except foreign keys. Consider fileReferenceId and dataId are foreign keys. I have to display parent file data on landing page and provide link on dataId. Once user clicked on any of the data Id, user will be redirected to new page where records from child table needs to be fetched & displayed using dataId and fileReferenceId. My Approach: Create entity backed record using parent table. Whenever user click on dataId , using 'fileReferenceId ' decide which child table needs to be called from 8 tables. Using 'fileReferenceId and DataId' display returned data on interface. Could you please suggest another approach to avoid so many DB calls. Is it possible to create separate record for each child table and link in the parent record. Thanks, Hemant.
Hi there, We have a requirement where we are calling an API on tab out of field. If we have 20 fields 20 API calls will happen and in the payload we are every sending field. I know calling a integration in saveInto is asynchronous ,but loading will complete when all saveintos are executed.Is there any way to optimize it, because latency is very high (It is taking around 1 min to complete the loading). can we make it truly async like React or js based applications?
Dear Team, Am getting the following error message while calling a Endpoint from browser, only in one environment we are facing this issue and rest all working fine. Any advise would be helpful. {"resource":"\/suite\/webapi\/invalidWMUrl","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"} Thanks, Sunil
Hi team, Is there any way by which I can authorize the endpoints if the token expires without manual intervention? I can see we can use authorizationLink but that requires manual intervention. Thanks,
How to apply sort on the data that we get from executestoredprocedure() while displaying on read only Grid?
i want to add the three fields into like eg firstname, middlename, lastname into one field as full name
Hi everyone, I have an interface which displays a list of documents (UI_ListOfDocument), and originally user need to choose one document in the list to preview it (UI_Preview will be displayed accordingly showing that chosen document's content), then click back to the list to choose another document for preview. The request is to create a pagination in the existing interface, so that user just needs to click the pagination buttons to see the next/ previous document preview. I already built the interface for the pagination, but was having trouble in linking the document to it to make it work. Currently, all related document from the data table are queried using a!queryEntity(), and are saved in a local variable, including it's content. If anyone has done this before, please leave an advise if possible. Thanks for your helps [emoticon:6d505171faa4497c85c5ca27290c555d]
Hi, Can anyone let me know the following regarding rdbms logs? I can see multiple rdbms logs created for a day, will these files merged before they are converted to .gz at 11:59 PM when exactly does the merging happen?
Hi there! We are looking for a plugin for QR Scan, We need scan and detect a QR from appian interface. Have we any way to do that? without take or upload photos? Usually we have seen this in many apps and Appian should have a way to do that. Thanks in advance!!
In the editable grid I want to add 2 rows on click of add row link, please help me out how to add dt ?
In an interface intially we didnt use this field for file upload and it displayed like below , all the upload buttons are greyed out. Later we used Disabled : false() for the same fileUpload and the out come is as below, upload button is enabled By default as it should be false and the upload should be enabled,but it was grayed out. Can anyone explain why it was like this
I have this stored procedure output where the column names are dynamic and may vary according to date range and the column names also have to be printed in the interface in Appian So can anyone help me with the way to print the field names in a dynamic way?
while trying to generate excel through smart node - EXPORT SQL to EXCEL, i am getting the below error in process - The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk. And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"}
Hi, I made changes to the View (added a column to the view with datatype = text). Added the same definition to the CDT by adding new column with datatype=text. When i try to verify the datastore, it is giving me the below error The data source schema does not match the type mappings: Wrong column type in Appian.p_my_view for column fs_structure. Found: text, expected: VARCHAR(341) (APNX-2-4056-000). see below for CDT definition and view definition. There are other column exists in the view with text and it doesnt complain. any help is appreciated.
Hi Everyone, I have a read only grid which is connected to Pie chart. When I open the report it should show all the rows with the selected filter but it is empty as below. When I click on any slice in pie chart, the grid is displaying the respective rows These are filter options I have used in my grid configuration Please help me how to all the rows with selected filter (isresigned) in the read-only grid when opening the report.
Hi, I want to have a ri!startDate, I will use the a!isNotNull function to display some warning message if the ri!startDate is null else will retrieve the weekday(ri!startDate) but I keep encountering the error message such as Cannot sub incompatible operands of type Date and type Text. below here is my code for the interface a!localVariables( local!weeknum:if(a!isNotNullOrEmpty(ri!startDate),weeknum(ri!startDate),{}), local!day:if(a!isNotNullOrEmpty(ri!startDate),day(ri!startDate),{}), local!month:if(a!isNotNullOrEmpty(ri!startDate),month(ri!startDate),{}), local!year:if(a!isNotNullOrEmpty(ri!startDate),year(ri!startDate),{}), local!dayofWeek:if(ri!startDate=null(),"Please Select a Date ", weekday(ri!startDate)-1), local!startWeekDay:if(local!dayofWeek1,ri!startDate-local!dayofWeek+1,{}), local!endWeekDay:local!startWeekDay+4, local!monday:local!startWeekDay, local!tuesday:local!startWeekDay+1, local!wednesday:local!startWeekDay+2, local!thursday:local!
How can i get the data from the api into the interface ? like in my scenario i want the movie details once i enter my movie name , and the thing as i had created the intergration using the link and it's working .now i just want to know how can get the values in my interface once i click the movie and submit button.
We have a solution based on record centric approach, hence all the database tables are mapped to Records, which have relationships too that vary from 3-4 per record to 10-11 on some of the records. All the interfaces are using records to display the data, recently an issue has been occurring while retrieving the data from records has become dead slow, causing time-out errors, or sometimes the interface takes forever to load. I have looked into the performance logs and server logs for any related cause and made certain performance improvement changes too but the issue still persists. The issue occurs intermittently, hence it is hard to figure out the exact cause of the issue. I'm looking out for what could be causing this and the best solution for this problem. Thanks in advance, your help is highly appreciated.
We have what is effectively an API broker or proxy tool between our Appian instance and an API we consume. The broker/proxy requires API Authentication to properly identify our system and allow access to the API's that it brokers. It does not however leverage it's own API keys to the services it represents. As a result, we have to pass a second API key through as a header.However, I have security concerns about the storage and security of this second key. Has anyone had experience and advice to secure this secondary key? It appears as clear text in the request headers, must be available in the integration or connected system (unlike the primary API key - which is masked and unreadable in the Connected System), and I cannot use the secure credential store to secure it. Even if I store it in a constant, I'm concerned about the potential security. Advice greatly appreciated.
Hi, I have a decimal field on my interface that I want to colour based on its value..something like if =8: then green if <>8: then blue How do I do that?? I know how to colour a text field. Please help thanks jaideep
Hi, Is there a way I can see on Appian logs as to who has made changes to the data.. for eg.. who created a certain record, who updated it, who deleted it and so on.. i tried looking for this info in tomcat-stdOut.log but cudn't get.. or do I need to create/code my own history table where I should track these user actions? thanks in advance jaideep
I have implemented service backed record with daily sync enabled. But the data at the source(service) gets added frequently(in minutes) and the customer want to see the updated data in Appian once its get added at the source. I have gone through documentation where I saw "Sync Changed Data". Could someone help in achieving "Sync Changed Data"? Additional Information: 1) Identifiers of the data being returned by the service are not sequential but random in ascending. (Identifier's are unknown if I need to use "Sync Record" smart service) 2) Full Data Sync takes around seven minutes. (for now there are around 180K records being returned by service, in prod it will be around 490k and will increase)
how can we achive pagination in layout grid without using foreach?.
Hi On my process modeller, whenever I debug the process model, the Process Start Form does not display, the process continues to the next steps without the option to populate the form. Is there a setting for enabling and disabling the Process start form or is this just in my environment? Thanks in advance
I ran into small copy and paste typo in Appian 22.3 docs. Don't know where to submit this, I know it's not really a question. Hope someone can route this to right team correct it. https://docs.appian.com/suite/help/22.3/Oauth_connected_system.html https://docs.appian.com/suite/help/22.3/oauth_client_credentials.htmlIn this case it think it should mention Client Credentials Grant instead of Authorization Code grant.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.