Discussion Categories

Hello. I currently have a database table with thousands of news from different dates. I would like to create a query that brings me the news by days and by month, but not by year. For example, the news of July 4 from different years. Thank you for your help.

5 54 543 5432 54321

Hi 1 or more paths can exit an OR gateway. If more than 1 paths exit an OR gateway, how can I make the paths back to one path? Thank you

Not able to fetch the top 3 most visited spots for a repective month with below mentioned code. Kinldy suggest { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VP

I am not able to fetch the top 5 most visiting spots for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-

I want to show only top 5 secondary grouping categories for respective month. {rule!VPA_CMPT_CardDisplayHeader(title: "Most Visited Parking Spot By Month",icon: "parking"),a!columnChartField(data: a!recordData(recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey'),config: a!columnChartConfig(primaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated',alias: "dateCreated_primaryGrouping",interval: "MONTH_SHORT_TEXT"),secondaryGrouping: a!grouping(field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName',alias: "parkingLocationName_secondaryGrouping"),measures: {a!measure(function: "DISTINCT_COUNT",field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-45ca-a0e1-25c645fcb9d3

I want to show only top 5 secondary grouping categories for respective month. { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{628f5a50-0f39-

I need to show only top 5 most visited places for a month but i am stucked at this point. below mentioned is the code that i used to work out till now: { rule!VPA_CMPT_CardDisplayHeader( title: "Most Visited Parking Spot By Month", icon: "parking" ), a!columnChartField( data: a!recordData( recordType: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey' ), config: a!columnChartConfig( primaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{2a9520d6-8de2-413f-ad99-7e1ed16d8291}dateCreated', alias: "dateCreated_primaryGrouping", interval: "MONTH_SHORT_TEXT" ), secondaryGrouping: a!grouping( field: 'recordType!{2807e918-8a87-4696-913f-2cec0198b9bc}VPA Journey.fields.{08a08942-2bd1-4dc1-902d-6d434e17bbef}parkingLocationName', alias: "parkingLocationName_secondaryGrouping" ), measures: { a!measure( function: "DISTINCT_COUNT", field: 'recordType

Hello All,  I am seeing below error when I am querying data from database. in the database nonInvoicePayments is defined as Tinyint(4) and in the rule input for this variable is defined as Boolean.   Please suggest me the solution. Error message: expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [EQUALS] to field [nonInvoicePayments] when comparing to value [TypedValue[it=26,v=1]]. Thanks in advance.

Hello, I have forgot my username for deveoper portal and unable to login. Could you please help in resetting my username and password? My email is: swathik0312@gmail.com

hii all, i have a requirement to store a request in draft , usually if i filled a form and given submit then only one request id will generate , before submit the form i want to save the form in draft mode , how would i achieve this please help me im new to appian. thanks in advance  b ramesh

How do I go about saving a file?I have the followingWhat do I need in the process model?I would have thought that this would automatically come when I press the submit button just like any other input.Is there any documentation on how to save this?I found this https://docs.appian.com/suite/help/22.4/File_Upload_Component.html, but it does not explain what you need in your process model or how to set up your database table(s)/field(s).

Hi, I have a rule input with multiple rows of data and I also have a local variable with few rows of data. Now I want to find the difference rows of data into a another local variable. Is it possible in appian.  Any inputs please.

Can we have regexmatch code for this scenario : I have   4 digits in text format but last  2 digits should be fixed EX:"XX30" here "30" is fixed "XX" can be any numbers in text format

Hi, Any idea how to find the third largest value using a!queryentity?

Team, We have a start process which gets data from third party and process is scheduled to execute in every 5 minutes. If Appian is down during that period , we observed that when Appian comes online it start n numbers of same process for the time it was down. So let say Appian was down for 25 minutes , once appian comes online we see 5 process instances are getting triggered for the same process and leads to data duplication. We want to make sure that at any time only one process executing and not multiple. We thought of using timer to wait next to start process and assign random seconds to each instance but that fails if instances are more 25. Any other solution?

I have completed Appian Developer Course, how can I improve my skills as an Appian Developer. Which course or other thing I can do now to achieve my goal ?

Hi All, i want to replicate the below section in another interface manually.  Which SAIL component can i use? 

I have a question regarding the visibility of UIT in tasks. I have tried assigning the task using process variable, individual users and also through groups. All the users and groups are part of the application and have viewer permissions. Also, I made sure to run multiple instances(one for each assignee). All the assignees are receiving the tasks but when they open it, they get a blank interface. But the same task, when opened by me is working fine.   I tried the troubleshooting mentioned in the documentation: https://docs.appian.com/suite/help/22.4/Testing_and_Debugging_Problems_with_Process_Models.html and nothing worked. The user input task in not been configured as quick task and the assigned users are part of the application and has basic user permissions(viewer). (I am new to Appian. I hope I was doing it correctly. Any help is appreciated.) Thank You. 

So I have a read-only grid displayed on a site through an interface. The summary is also displayed through an interface, and the summary of a record is pictured below. What I want to do is add a button, going to the next or previous record so that the user doesn't have to click the home button in the top-left. I found this thread but wasn't sure how to apply it to my situation (not completely sure how to apply a!query): community.appian.com/.../access-to-previous-and-next-records

I want to do this get value from multiple select as newRefs;insert into table1 ('name') values ('pete');SELECT LAST_INSERT_ID() as newUserId;for each (currentRef in newRef) {     insert into lookupTable1 (userId,ref) values (newUserId,currentRef);} Actually there is a quicker way to do this with MySQL/MariaDB as noted here https://dev.mysql.com/doc/refman/8.0/en/insert.html What do I need to do this?Do I use Data Store Entities, Record Types, etc.?I can't be the first one that want to do something like this.

Hi  Expression i used is: if(todate(ri!vehicle.vehicleNextMaintenanceDate) <todate(ri!vehicle.vehicleLastMaintenanceDate), “The nextmaintenance date must be after the last maintenance date.”,null) Below message is the error i got while working on interface. Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'if' [line 59]: Invalid number of parameters, function 'if' a minimum of 3 parameters (condition,true,false), passed 1.

Hi All, I scheduled my L1 certification on a wrong time zone (Indiana) by mistake where as I live in India which follows IST. I was blocked from taking the exam since the Indian Standard Time(IST) is 10 hours and 30 minutes ahead of Indiana. Is there anything I could do to retake the same exam or Is there any other alternative for the same? Thanks in Advance!

I am facing an issue with my RPA code. I have automated a process for data entry into an internal database, but it seems that the bots are not able to handle exceptions or errors that may occur during the process. This is causing the automation to fail and manual intervention is required, defeating the purpose of using RPA in the first place. I read this article to get more understanding and tried debugging the code, but I am not able to identify the root cause of the issue. Here's a sample of the code that's causing the problem: bot.click("submit_button") result = bot.get_text("status_message") if result == "Success": bot.click("continue_button") else: # What should I do here to handle exceptions or errors? ```"

Good morning everyone I am trying to filter the day from a recordtype that has the whole date time in the db. When I put this expression in it shows 3/19/2014 800pm edt. I just need it to show the day. How do I accomplish that? contents: { a!richTextDisplayField( value: a!richTextItem( text: fv!item [rcordtype], color: local!textcolor, size: "MEDIUM_PLUS" ) ) },