~recent-questions-st | Bookmarks (1350)

My tables are: projects -> tasks -> commands Trying to calculate average on field duration Project::with('tasks.commands')->withAvg('commands', 'duration') It can't work because Eloquent expects database field duration here. But in my case duration is custom attribute in Command model. How to use aggregates with custom attributes?

After changing the password for an external database user, I am no longer able to access the Wordpress site. The WP site has a code snippet with the database credentials and a connection to the external db. I changed the password via the Cpanel list of database users and then also changed the database user password in the code snippets. Can you please help...

I installed the SAGANG plugin in QGIS 3.42. I can see it in the preferences but not in the processing tools. Additionally, I am unable to set the path in the SAGA folder within the preferences. I am working on a Mac. Thanks for helping me Francesca

I am using MUI autocomplete to allow user to add multiple emails. All valid emails are shown as MUI Chip components using tags and invalid emails are shown as comma separated list. I want to limit the height of content (tags + input value) to 300px. What is the best way to achieve this? Currently, I have implemented this by overriding MUI form control...

In DolphinDB streaming calculations, I am trying to synthesize data for all periods (data sources can be ticks or minute-level data). I want to achieve functionality similar to the dailyAlignedBar function in batch processing. However, I encountered issues when testing createDailyTimeSeriesEngine and createTimeBucketEngine. Issues with createDailyTimeSeriesEngine When using createDailyTimeSeriesEngine, I noticed that the calculation results are affected by the initial data. For example, if...

XCode Version: 16.0 IOS Version: IOS18 cordova-appsflyer Version: 6.15.3 cordova-ios version: 7.1.0 We have an existing app that is published but is limited to countries outside our area. I am trying to integrate Appsflyer to the app and test it on a build installed from XCode on my local phone IOS18. Associated domains has also been added to XCode After clicking the Appsflyer link,...

I want to create a button which has rounded corners and uses a wood texture as its style, something similar to this I have tried with ImageButtons, LayerLists and nothing has worked so far. The current implementation that doesn't break everything is this piece of code, where the '@drawable/wood' is the texture file. <FrameLayout android:layout_width="0dp" android:layout_height="80dp" android:layout_margin="16dp" android:layout_rowWeight="1" android:layout_columnWeight="1"> <ImageButton android:id="@+id/button25" android:layout_width="match_parent" android:layout_height="match_parent" android:background="@drawable/wood"...

My current setup is in Bitbucket, with repos, pipelines and branches configured in bitbucket. Now the requirement is to move pipelines from bitbucket to aws codebuild for autodeployment. Can anyone guide me on the same and the process needed to be followed. i have bitbucket-pipeline.yaml configured in bitbucket for pipeline.

I am learning JOOQ. I have a parent-child table with a simple 1-to-many relation via foreign key. Each table contains about 15+ columns. I have 3 related questions. Not sure if I need to create a separate questions for each. How can I write a multiset select similar to a SELECT * on both parent & child ? Is there a way to convert...

I’m developing an offline turn-based game with a complex skill system where each skill has unique behaviors, such as: Damage (e.g., Fireball, Slash). Buffs & Debuffs (e.g., Attack Boost, Poison). Healing & Shields (e.g., Regeneration, Lifesteal). Since skills can have many variations, using inheritance (e.g., FireballSkill, HealingSkill) quickly becomes unmanageable. Instead, I’m considering a component-based system, where each skill is made of modular effects....

Here's a task. We need a custom popup menu for our JTree extension. Right click should trigger not only the popup, but also selection of the tree's appropriate node. The analyst was explicit: clicking a node and then right-clicking to trigger a popup won't do, it should all happen on a single right click. Important: selection should beat the popup as the menu composition...

My point is that my page has some inline scripts which has response from the api,, which doesnt contain the absolute url but attributes like slug which is the part of url and google is trying to access those urls. I want to know whether it reads the url from any avaible script randomly considers them url? Have added sample script below <script>self.__next_f.push([1,"2b:[[\"$\",\"$L2d\",null,{\"brand\":\"BEML\",\"model\":\"D50 A15\",\"title\":\"BEML...

I have a background service in C# that I want to check the health of the background service. Whether it is running or in error or stopped, then I want to see the status of the background service health via a Web API GET method. In the background service process, when the service starts status is set to running, if stops it is set...

scala2.12 l have a list of different scodec.codecs ig. List(int(8),floatL,uint,...) and this list is very long. How can i get a Codec[int(8)::floatL::uint::...::HNIL]? I know i can do it mannualy but it cost a lot. i tried foldLeft using codec.deriveHNil as the first param,but it turns out to be the wrong type

I have the following JSON and my snowflake query is below. I am getting empty rows. What is wrong with my query? IAECARBONBASELINESBREAKDOWN is the column in ESG_ACCOUNTS_DATA. Json may or may not have level2breakdown SELECT ROUND(ZEROIFNULL(LEVEL1ARRAY.VALUE:weightedAverage),1) as weightedAverage, REPLACE(LEVEL2ARRAY.VALUE:name,'"','') as name, LEVEL2ARRAY.VALUE:percent as percent, LEVEL2ARRAY.VALUE:total as total, COALESCE(LEVEL2ARRAY.VALUE:breakdownBy,'') as level2Breakdown, LEVEL3ARRAY.VALUE:name AS level2BreakdownName, LEVEL3ARRAY.VALUE:total AS level2BreakdownTotal, LEVEL3ARRAY.VALUE:percent AS level2BreakdownPercent FROM ESG_ACCOUNTS_DATA, LATERAL FLATTEN...

I want to sign a document with using an external API. You can send an hash of your document to that service and get a signed hash back. This is how I send the document hash to the API: private String generateHash(byte[] content) throws NoSuchAlgorithmException { MessageDigest digest = MessageDigest.getInstance("SHA256"); byte[] hash = digest.digest(content); return Base64.getEncoder().encodeToString(hash); } This is how I handle the response...

I cannot redirect my next.js application to my domain address with nginx. I am running: nginx, next.js application in Docker. I added VPS ip address to my domain address using A record. I redirect my domain address to the next.js container in docker using nginx but unfortunately it doesn't work. docker-compose.yml version: '3.8' services: next: build: ./frontend container_name: nextjs_app environment: - NODE_ENV=production networks: -...

i have my function: Function gettotalsandvat(str As String) As Variant Dim path As String path = str .... i do some stuff.... Dim arr(2) As Variant invdate = wkBook.Sheets("Sheet1").Cells(16, "O") arr(0) = invdate .... i do some more stuff... Total = wkBook.Sheets("Sheet1").Cells(row, "P").Value arr(1) = Total MsgBox arr gettotalsandvat = arr End Function can some one please help? arr is empty i want to...

apologise for the very basic question but I am trying to calculate relative frequencies (%) of variables within a column grouped by another column. Example data: df <- data.frame(Case = c("A","B","B","B","A","B","A","A","B","B","B"), Status = c("Y","Y","Y","N","Y","ND","ND","N","Y","N","ND")) I know how to calculate the absolute frequencies, so that the data will look like this Case N ND Y 1 A 1 1 2 2 B 2 2 3...

In this example, am I using NextJS's (14.2.24) server-side extension to WebAPI's fetch or the standard WebAPI fetch, specifically relating to the use of the cache property? Am I referring to NextJS's cache or the browser's http cache? // actions.ts "use_server" export const callApi = async ( endpoint: string, method: Method = Method.GET, body?: any ) => { const url = `${process.env.API_BASE_URL}${process.env.API_LIB}${endpoint}`; let token...

We are targeting to keep a counter in Cosmos NoSQL container in single logical partition. (Single region write account) { "version": <int> } If we use patch increment operation to increment version value, will it be ACID compliant, means if two application servers, in parallel, hits increment operation, can they get conflict error or they will both be in isolation totally and execute sequentially....

I am currently trying to create an ipydatagrid.Datagridthat opens up a graph when I select a row. For testing purposes I am currently just trying to use a ipywidgets.Text widget to randomly fill text. I tried to use an EventHandler with datagrid.observer(...) but for some reason it does not seem to work. I know that the EventHandler works for other elements like Buttons, but...

how to select a few edges from a loop without to select each one or to draw a select area ? for instance, in the photo i would only select edeges inside red area ? loop selection but how to select only edges inside red area ps : don't consider the next text, i wrote it only because SO requieres a minimum text length)

In my Blazor server application, I want to use OAuth2 authentication instead of basic auth. Using Mailkit and .NET 8.0. private async Task<string> CreateSmtpClientAndSendMailAsync() { _smtpClient = new SmtpClient(); try { _smtpClient.Connect(MySmtpHost, MySmtpPort, SecureSocketOptions.StartTls); var confidentialClientApplicationBuilder = ConfidentialClientApplicationBuilder.Create("xx").WithClientSecret("xx").WithTenantId("xx").Build(); var scopes = new string[] { "https://outlook.office.com/.default" }; var authToken = await confidentialClientApplicationBuilder.AcquireTokenForClient(scopes).ExecuteAsync(); SaslMechanismOAuth2 oAuth2 = new SaslMechanismOAuth2("xxxxx",authToken.AccessToken); _smtpClient.Authenticate(oAuth2); _smtpClient.Send(_mailMessage); _smtpClient.Disconnect(true); return Resource.mailSentSuccessfully; } catch (Exception...