boon

You could accomplish this using an inner join with the same table. In the proposed solution, I aliased one voter to represent those who casted votes and the other nominated for those who votes were cast for. The inner join was done on the athletePosition on both table aliases and voter.votesForId= nominated.athleteId before finding the total records.

It was difficult to replicate with the shared schema and data however, I believe the StackOverflow community has shared some valuable insights on how to proceed with these in the comments.

I have shared a db-fiddle that replicates your problem and the proposed solution.

Split it on linefeeds as you're doing, then go through it line by line and determine whether each line is a "title" or "content." Use a dictionary to access the content by title.

Combine Matching Rows

The problem is that the you are using Java 9+ and the boon dependency hasn't been updated for Java 9+. The FastStringUtils class within this library does some reflective hackery to access internal fields of the String class, but the internal fields of String changed in Java 9.

This GitHub issue was opened in November 2015 for this problem and is still open almost five years later.

The workarounds are either to run your application in Java 8, or to run your project with the system property io.advantageous.boon.faststringutils.disable set to true. You can do this by adding the command-line argument -Dio.advantageous.boon.faststringutils.disable=true, or by adding the line

Replace your config groovy script with the below code and it will work. The JSON Parameter feature for the Extended Choice Parameter is based on the https://github.com/json-editor/json-editor

The groovy script should return a JSON object that corresponds to the "options" object referred to in json-editor.

UPDATE

Ensure that your Extended name choice parameter "Name" doesnt have space. So in your case change the name from "Testing Json" to "testing_json" or Json (string without space) and it will work.

The solution was to stop using FirebaseClient, because it was not wrapping the name-value pairs in double quotation marks. Just use normal http instead.

You need to change the return type of getCartItem() function to Future>. Also need to return an empty List when prefs.getStringList("cartkey") is null.

How about something like this?

You will find this fairly difficult to do by directly manipulating text files; it's better to just read in the entire data structure into a native Python data structure (e.g. list of lists), modify the data in-memory, then rewrite the entire file.

This will be even easier if you use a library specialized for this like Pandas. For example, first instead of including the card number directly in the Card column, make a separate column for it like this: