Viking | Build Tool library

Scenario: Just created a simple book List app, which can accept some inputs and display it on the UI and has other functionalities such as the use of localStorage.

Just as I added more custom alerts (e.g. show alert - on adding a book, - if author name contain numbers etc.) The whole alert stuff has gone AWOL. (Previously defined alerts worked fine before)

Also none of the questions that showed similarity proved useful to me

Method which handles all the alerts in the page

I am sure this is a simple fix, but can not figure it out. I have a COUNT function that needs to count the total number of Rentals. Alone, the function works just fine. I have tried using DISTINCT, tweaking the GROUP BY, and ORDER BY, but to not avail.

When I add the DATEDIFF function to get the NumberofDays rented, the COUNT function does not work the way as intended. I should be getting some results with "2" instead of "1". Note that I need to order by the Rentals.Boat_ID. Here is my code and table results. Thanks

Main

The output from a scatter-gather is two variables with identically formatted XML files. I now need to merge the two files into one. Experimentation and searching has not turned up any example code in combining two XML files.

Input 1 comes from one reporting process and Input 2 comes from a different report. The format will always be the same except for the "TYPE" parameter. I want to drop the "DATE" line and merge all of the records.

Input 1:

I am trying to compare two list of words in separate columns in a dataframe and print the common words. After that I want to calculate a column common_count which is the count of common words divided by total words in the first list. The final output would appear like this:

Snippet to create the dataframe:

I have a fetch that is getting about 12 SharePoint list column values. The one column value that I am having issues with is the column with the ID of "WeekOf" which is a date and time column.

The InfoPath form that users fill out that stores the items in the SharePoint list uses a "date" type input for the Week Of value, and that is stored in the form and the SharePoint list as MM/DD/YYYY.

When it is pulled through the fetch and stored in the network results tab of developer tools, it is then formatted as YYYY-MM-DDT05:00:00Z.

My application takes this SharePoint list data, and posts it to a HTML List on a printable page for records keeping. I have it so no data shows up on page load, and then users search for information based on the date that is associated with. When I set the input type to "date" and search for the appropriate date, nothing appears even if the date is the same. It seems like the input date is searching for a date with the format MM/DD/YYYY.

I have code that reads from a SharePoint list, stores the data in an array, then posts it to an HTML list to be printed. For the most part, it works and prints the page.

I have excluded the Print button and Search bar from the div container I am choosing to print, and it is still appearing in the print preview? Can I remove these elements from the print view/also move the margin of the Weekly Report header and everything closer to the top of the page?

Here is my snippet where it works:

I am creating an HTML Document through JSON data collected from a SharePoint list. Currently, I have about 80% of my expected result done.

Right now I am not including my fetch to pull the information, because JSON cannot be collected cross-sites due to CORS, so I have included a hard coded version of the JSON collected from the fetch.

As of now, all of my HTML is appending as it should. These are the issues I am currently facing:

• Hide everything(except for the search bar) so it only appears from an onClick or onSearch event.
• Be able to filter through all the JSON objects in the array and only show the Objects with the corresponding date and hide the others (i.e. Raiders & Eagles both have the WeekOf value of 2021-01-31 & the Vikings has the WeekOf value of 2021-03-30. So if I were to search 2021-01-31, only two of the teams will appear).
• Underneath the header "Weekly Team Report", there is a paragraph tag containing the text

  Week Of ____

  . Where the ____ is, I want the Week Of that is used to search and sort the material to appear (i.e. if I search 2021-01-31, obviously only the Raiders and Eagles reports would show up, but also under the main Weekly Team Report header, the paragraph tag would read Week of 2021-01-31.

Here are some documents/articles I have used for research:

• https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/filter
• https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/search
• https://developer.mozilla.org/en-US/docs/Web/API/GlobalEventHandlers/onclick

UPDATE I have implemented a Search Bar and Button, which I intend to use for the query/filter as well as hide/show the data which I was searching for. In this case based on the date(WeekOf) data which I entered through the search bar.

• I tried to implement an onClick() & onSearch() function with the button, and the onSearch() failed with Uncaught TypeError: $(...).search is not a function and when I implemented the onClick() function, the page loads blank, which is good. But as soon as I click within the search box, the page loads, and when I click search, I get an error 404. I am assuming the search isn't working because I do not have my query/filter set up yet which I need and is essential.

I'm trying to make an small terminal search engine (python 3.9, VS Code) and I wrote this function as the key function for sort. When I don't write the list parameter, list.index is meaningless and when I write it, it returns an error, could you check it out?