Discussion Categories

{1,2,3}, {56,76,54,32}, {12,23,45,54,32,54}, {1,2,3,4,5,6,7}, {8,9,10,11,12,13,14,15} Please suggest how do this using foreach function get output like this,  "length of array 1 is 3" "length of array 2 is 4" "length of array 3 is 6" "length of array 4 is 7" "length of array 5 is 8"

Hi all, we've been confronted to a strange case. For a better understanding we've reproduced the behavior in a expression rule : if({ 1 } = 1, { 2, 3, 4 }, {}) returns 2. Obviously, comparing a list with an integer is the error here. But, then, the result should be either the empty list or null or an error message. For more fun, you can test : if({true, false, true},{2,4,6},{3,5,7}) In our mind, a type error should be returned. Regards.

Hi Everyone, I have a requirement where i can reuse local variable array. For Example a!localvariable( local!iterations:{1,2,3}, local!value, a!foreach( items:local!iterations, expression{ append( local!value, fv!index )})) The output i need is 1st Iteration 1 2nd Iteration 1 2 3rd Iteration 1 2 3 But the output the code is generating is 1st Iteration 1 2nd Iteration 2 3rd Iteration 3. I thought that local variable should be append with the value and  can use for next iteration but it is initializing every time with null value rather than appendvalue. Could you please help me to get the output i need Thanks In Advance!!!

Hi, first of all: Best greetings to everybody here. I like to add an additional 2 factor authentication to use the community not only on my smartphone but wirh my PC also. Where can I add eg email or sms or do I need to start from scratch? Thanks in advance Matthias

Hi There, We have a requirement to show each detail on new line in Hierarchy Tree Component. Fo example in the below attachement when we hover the cursor each detail coming on new line since we used char(10).  However, we would need to show the same way on the node itself without hovering the cursor. Please let me know your thoughts on this. Thank you.

I have an array or string, I am trying to split it into multiple arrays. Input Array : {"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten"} Output Array: { {"One","Two","Three","Four"},{"Five","Six","Seven","Eight"},{"Nine","Ten"} }

Hi All, I have  "Accounts" record(database is the source) in below structure, Account ID Account Name Account Status 28 Test InProgress   I added a "One to Many" relationship with the "Contract" Record,which is in below structure.  Cont Primary Key Account ID Contracts 1 28 A1100 2 28 A2000   Now I want the "Accounts" record list to be displayed in below structure,where the "contracts" column will be my new custom record field,and it should be concatenated like below. Please help me how to make this work. Account ID Account Name Account Status Contracts 28 Test InProgress A1100,A2000  Thanks in Advance!!

Good Evening Great People, I keep having a problem with the Import Excel to Database Plug-in Smart Service. I import the Data, the are no errors on all the notes, however the information is not written to database. The first time, I encountered the problem, I just deleted the plug-in and re-deployed it and it worked. The second time I encountered the problem, I reverified the Entity mappings on my Datastore. Then the third time, I resolved it by removing the delete  Today, I encounter a similar problem and I have tried the previous tricks non of them work. What are the possible reasons that this plug-in could fail to write to DB even though there are no process note errors Your assistance would be highly appreciated thank you

Hi there, I have an array local variable here, using a!save(local!array[1], true) does not work. any idea what's the problem? regards, Lin

i'm trying to create a process report report type task , context tasks assigned to group inside the report i set the required group as a context but i wasn't able to see list of tasks of that group, so please guide me what is missing

My process models were developed and tested when Primary (and the only) Locale was English (US) by default. I now need to change the Primary Locale to English (UK) - to get the dates appearing in correct format (as I am in New Zealand, and here we use date format as dd/mm/yyyy; and not the American mm/dd/yyyy format). When I change my Primary Locale to "English (UK)" - the date formats work well; but my Process Model names are showing as "???".  I do understand that somehow I need to redefine Process Model names in the new English (UK) language (which BTW seems strange, as the process model names would be exactly same in these two "languages" :-) ). However, I don't know how to do it. Are there any other properties that I need to update for the new locale? Any thoughts, for a proper solution to this?  Thank you in advance.

  this is my cdt  i dont know how can i delete a username for the usernames field  in the db.

Hi Everyone, I have two interfaces, interface 1 and Interface 2. The interface 2 is inside interface 1, interface 1 is having a button which is calling exp rule to call web service to update DB. Now when I click on button the interface 2 is not refreshing latest data. Could you please suggest how to achieve this?

Hi everyone,  One of the process models that I'm working on is using a Timer Event node, which is having a scheduled delay setting as shown below: (the constant returns 2 (integer)) I think the node supposes to delay for 2 minutes, then will activate the next node (Merge document) to run.  However, this Delay node has stuck there for much longer than 2 minutes, and when I check Process History, the node is Cancel.  The Merge Document node does not have any setting for Scheduling either I haven't worked with Timer Event before, and couldn't find the reason for this behaviour from documentation. Could anyone help me with this? Thanks a lot,

Hi All, I have a requirement where i have to add  validation on a text field and the validation is like + and three integer. please help me out with this. thanks. 

Hi All, While running the Query entity. Facing this issue.  a!queryEntity( entity: cons!ABC_DSE, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10 ) ), fetchTotalCount: false) Exception: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DECOMITSMNetworkDT11134], query: [queryentity expression], order by: [[Sort[computer_id asc]]], filters:[null]) Is there any log file where i can get more details? Note: Retrieving data from Oracle. Regards, Nishtha Bhatnagar

Hi, I have an interface and I would like to change the Parent folder for the interface to a different folder. Any idea how I can do this.

I have a grid (in SAIL) that displays a number of rows.  When one row is selected, the details for that row are displayed below.  Any edits the user makes to the details need to flow back to the grid and be displayed.  This grid is not tied to a record set, but CDT data obtained from other parts of my application.  NOTE:  An editable grid will not work for my scenario. A greatly simplified version of my need is.... a!localVariables( local!data: { { name: "Springs", qty: 4, unitCost: 1.27 }, { name: "Sprockets", qty: 1, unitCost: 2.50 }, { name: "Gears", qty: 7, unitCost: 1.98 } }, local!selection: null, { a!sectionLayout( label: "Order Summary", contents: a!gridField( data: local!data, columns: { a!gridColumn(label: "Qty", value: fv!row.qty), a!gridColumn(label: "Item Name", value: fv!row.name), a!gridColumn(label: "Unit Cost", value: fv!row.unitCost), a!gridColumn(labe

Hi All, I got a read only view from Oracle where no primary key column exist but In Appian we have to make some column primary key how can I solve this problem. Appreciate your help! Regards Nishtha

Hi, I want to use the API of JavaScript in Appian, but I dont found a lot of information about it. Anyone has use it or have more details about it? This is the link that I found: https://docs.appian.com/suite/help/22.4/reference-js-api.html#api-reference Thanks in advance and regards.

hii guys, I have a requirement of design a record action called DELETE For this i have followed documentation and approached process model method to delete record action using DELETE RECORD SMART service but im getting following error plz help me thanks in advance

Hi all.. What is the best way to show more than a few record types? For example, lets say an application has below record types and related record types. Organization Customer Address Product Flyer Point Programs Point Credits Discounts Orders Order Items etc. etc. I'm just making up record types that may be related to each other in some imaginary business Now, given that Appian has 5 tab limit on a Site, how do we expose these many entities in a site if I have to?

Hi All,  I am facing an issue regarding process report. I have crated one process report to fetch process history with last seven days and using that process report in a interface, But as per my requirement i need to fetch process history with only two specific process model, not for all processes which i was performed in last seven days, for achieving this i have created one filter in Process report where I am using  Process= GPA Task Loader by using this i am able to fetch process history but it showing only today history. So there is any other way to fetch process history for  two process model with last seven days data. a!localVariables( local!statusFilter, local!processTask: { "GPA Activity Task Loader Excel", "GPA Activity Task Loader Excel Validation" }, local!taskReportData: a!queryProcessAnalytics( report: cons!POC_GPA_USER_REPORT, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 500,

Hello All, We are having 1 record which is having relationship with others record also. We are getting the data from the record by the function a!recordData( ) and displaying on the interface. We are having different buttons for child interface on the selection we filter on the basis of the different status related to the button clicked by the user we are fetching the data from the record. The requirement is to show the number of records with the button label. Anyone who have used some function by which we can directly fetch the number of filtered record and can display. Thanks in advance

Hi Everyone, I am quering the data from table and stroing it into local variable. On button click I am refreshing the data using refresh varibale parameter refreshonvariablechange , but the variable gets changed and data is not refreshing. Could you please help me out?