Discussion Categories

Hello team, I am not able to find out if it is possible to use multiple delimiters in Import CSV to Database object. Some of our users create csv with comma some of them with semicolon and I need to ensure it will work with both options. Based on the object configuration it seems like it is not possible, as Multiple option is disabled. Any suggestion please? Thanks

Hi all, I have a nice process model, let's call it ProcessModel_A The process model has a PV, of a CDT type. Let's call it CDT_A. This CDT has some text and number attributes and also contains an attribute which type is a second CDT, let's call it CDT_B: CDT_A:    name - text - no multiple    age - number - no multiple ...    moreData - CDT_B - multiple There is no database here, just the process models, and no Records, just CDTs. Please, bear in mind that the moreData is a list. I've created a Process backed record, RecordPM_A, of type ProcessModel_A. When I run a query on the process, like: a!queryRecordType (   recordType: RecordPM_A,   fields: {      [RecordPM_A.fields.moreData.CDT_B] ... when I query it like this, in the attribute moreData it keeps telling me that this is a list of text and is retrieving only the first element of CDT_B. Any idea on how to FORCE it to understand that the list of element

I'm having an issue currently where a single column, very occasionally, will revert back to null soon after it is updated. I set up a trigger that tracks when alterations are made to this column. I then checked all process instances that were running at that time and finally narrowing it down further by searching for PMs that were a depended of the database constant. I find that the only PM that fits the bill is the one that updated from null to 0 in the first place. I was wondering if anyone had experienced an issue like this before. Below are some pictures showing time stamps for when updates occurred.  In both instances it is updated back to null very quickly. The first 11 seconds later the second one within the same second. Anyone have an idea of what this could be?

I am generating multiple pdfs from html asynchronously. After all pdf are generated I am merging them using the merge pdf plugin. Is there a way to provide the page number after merging or while merging pdfs?

Hi Team, I'm facing a cascading problem when performing manual deployment. The processModel [id= uuid=...] was not imported because a required precedent is missing: content [uuid=_... location=Process Model Expressions (Rules)] cannot be found. (APNX-1-4070-001) (APNX-1-4071-006) The linkage is like, processmodel has a process start form interface and that interface calls other interface. All the precedents were added to the package, still facing this issue.

I know self doable feature to select time zone or internationalization setting accros all profile. But if we have many users and do not want to communicate users to do setting on their own. Is there a way to accomplish to do this. May be LDAP sync kind of?

Millions of data in query entity is possible to query for fetching data

When I am logged in as a member of Admin group the following returns a count that is different from,  when i am logged in as member of some group that is also a group member of cons!ALL_USERS Any idea why those count could be different  ? count(  a!groupmemers(     group: cons!ALL_USERS,     direct: false,     memberType: "USER" ))

Hi All,  last part of Developer course is optional. I wonder how it may affect final exam?

Hi all , Can we update view by adding functionality of group_concat to a field .If yes, Can you please instruct me how to do? CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `ISR_v_MeetingProposals` AS SELECT `mjs`.`meetingId` AS `MeetingId`, `mjs`.`studyRequestId` AS `StudyRequestId`, `mjs`.`sortOrder` AS `SortOrder`, `sr`.`referenceNumber` AS `ReferenceNumber`, `sr`.`studyTitle` AS `StudyTitle`, (select group_concat(distinct `ta`.`name` separator ';') from `ISR_TherapeuticArea` `ta` where `ta`.`therapeuticAreaId` in (select `srt`.`taId` from `ISR_j_StudyRequest_TherapeuticArea` `srt` where `srt`.`studyRequestId` = `sr`.`studyRequestId`)) AS `TherapeuticArea`, `c`.`name` AS `countryName`, `c`.`code` AS `countryCode`, `cc`.`code` AS `currencyCode`, `ss`.`totalAmountRequested` AS `totalAmountRequested`, `ss`.`convertedTotalAmtRqsted` AS `convertedTotalAmtRqsted`, concat(`srp`.`firstName`,' ',`srp`.`lastName`) AS `PrimaryInvestigator`, `sr`.`medicalScientist` AS `medicalScient

Hi All, I am using  stored procedures for my grid.If I update the values in the task those updated values are not coming in the stored procedures still it is showing old values.How can I get updated values of task in store procedures

Setting up a new dev app on Appian Community Edition. Connecting to MySQL cloud database. Receiving "Test Failed" error while trying to create MySQL Data Source as Connected System. Able to connect to the database in question via phpMyAdmin over browser. Thoughts? Thanks.

Hi Team, Im Facing the issue data was not updateing automatically. I have used like below 1) Parent interface -> contains 2 interfaces - grid and cloumns layout one after another in order 2) if data changed in grid coloumn and data(im querieing from db and stored in local variable with refresh) not changing in columns layout automatically but if i moved to next page and came back to current page then its working 3) for the point 2- i tried a!refreshVariable() and a!save() but its not working Any idea to overcome this problem, please let me know. Thanks & Regards, Vigneshkumar Radhakrishnan

Receiving the following error on the Interface I am working on.: "Expression evaluation error: Syntax error. Details: Expression evaluation error at function a!columnsLayout parameter 1 [line 285]: Keyword and non-keyword arguments must not be mixed. Used in: columnlayout." Code mentioned is as follows:

My site is not working and it shows this below message. what should I do for reactivate my site. Message:---------- My Community Edition Site:- "When your environment is available, you will receive an email with your credentials. Return here to check on your request status."

Hi Everyone, what is the limit on number of rows in export to sql smart service. I had an requirement to export around one to two lakh rows in an excel. Any other way that i can acheive it if export to sql smart service had limit? Thanks in Advance!!!

How to add column in cloud database

What should be the best practices in terms of Record Type or Entity  if requirement is as per below- 1- Data structures has to have more then 100+ columns 2- Many attributes are of 4000 Char length Is it safe to use query entity instead of query record with above cases with the perspective that every thing is driven thru record type in future and most of the new featres will be based on record type.

I am using a record type to back some read-only grids via a!recordData. The grids both use the same record type, but with different queryFilters passed into a!recordData. Both instances need to show the OOTB search box, but I need to disable the "My Filters" view and the "Save Filters As..." feature to avoid users getting confused. Furthermore, the application of a saved filter as default will be applied to both instances of the gridField, which is something we must avoid. Is there a way to disable My Filters / "Save Filters As" while retaining the OOTB search box? Else I would need to build a custom search.

Hi All, FYI, This is my first POC to develop the bot tasks in the Appian RPA. And I have other experiences in the RPA tools also Appian BPM.  I need to know some details about to pick the particular element via windows automation or browser automation. Questions: How to identify the element via windows application(example:Calculator) or web application? I tried via recording and save it. But after open the calculator application, click 8 in the calculator getting element not found exception If we are not using recording to do each node of process there is any ways in the custom. Like one click drag and used in middle of process in this how to pick the particular element as like as recording. Thanks, Pradeep Sridharan

Hi everyone,  I have a list of values as given below:  local!1: {a,b,c,d,e,f,g,h,i,k,l,m,n}, I want to do a loop to index a batch of value each time, for example the first batch is having index 1,2,3 (a,b,c), the next batch with index 4,5,6 (d,e,f),etc (batchsize = 3, start index +3 for each loop) I tried Enumerate() to determine the exact index of the data I want to get, but this function returns all values from 0 -> batchsize value. Is there anyway that I can get only the index I want, for example 1,2,3 of local!1 for the first loop, then 4,5,6 of local!1 for the second loop and so on?  Thanks a lot!

Hi All, Please help me out of this Error, Error message : Training failed because there are too few files that meet the requirements. Collect and upload more files that meet the requirements to train a model. Which type of templates Should be Upload in  AI skills - Email smart Services 

Hello, I have a constant of type application and I need to retrieve all of the application groups from it. Is there any way to achieve this? Thank you!

Hello.  I am trying to implement MSGraph Email Poller plugin and we are receiving the following message when the poller runs:(conn=7686054) Unknown column 'BODY_SWAPPED_IMAGES' in 'field list' Any info around the cause and resolution of this error ?  MSGraph Email Poller

I'm trying to create Image Recognition Bot using Low Code module but it is unable to search the image. I have tried with multiple images and with different configurations. Has anyone successfully searched the image?