I'm working with laravel, and I need to make a report for an inventory control … until now I have achieved this result …
I want to add that the data in the column description is a column that was expanded (That is another one of the same type) for example we see that I have 2 phones that become one and that if another phone appears, it is also attached and than in the amount of being possible as a total that in this case should be 2.
In my view I have the following code.
N °
DESCRIPTION
CANTD.
CODE
GROUP
No. INDENTIF.
SERIAL
MODEL
BRAND
COLOUR
INCORPORATION Bs.
DISINCORPORATION Bs.
OBSERVATION
@foreach ($ inventories as $ inventory)
{{$ inventory-> id}}
{{$ inventory-> article-> dsc}}
{{$ inventory-> amount}}
{{$ inventory-> code}}
{{$ inventory-> group-> code}}
{{$ inventory-> independent}}
{{$ inventory-> serial}}
{{$ inventory-> model}}
{{$ inventory-> brand-> name}}
{{$ inventory-> color-> name}}
{{$ inventory-> incorp}} Bs
{{$ inventory-> desincorp}} Bs
{{$ inventory-> observation}}
@endforeach
My driver
get ();
$ pdf = PDF :: loadView ('documents.pdf', compact ('inventories'))
-> setPaper ('letter', 'portrait');
return $ pdf-> stream ();
}
public function download ()
{
$ inventories = Inventory :: orderBy ('articulo_id', 'ASC') -> get ();
$ pdf = PDF :: loadView ('documents.pdf', compact ('inventories'))
-> setPaper ('letter', 'portrait');
return $ pdf-> download ();
}
}
SELECT (SELECT *
FROM the messages
WHERE m.threadId = mtu.threadId
LIMIT 1) AS A
FROM messages_thread_user mtu
WHERE mtu.userId = 1;
I want to get everything Rows of the subqueries AHow can it be possible? It works fine if I choose only 1 Rows. Or is there another way to write this query?
You can use an energy query function called "Extract values" to do this.
In my example, I changed the name of the Title column in each list to Project_ID and Tasks_Title. When these are incorporated into Power BI, they are displayed with the name of the original title and must be renamed.
Steps:
In your Project Task list, update the project ID search to also show the project title.
In a new Power BI project, click Get data and choose your SharePoint
Project_Tasks lists. (The list of projects is not necessary.)
Click Edit, not Load. You are now in Power Query.
Delete the columns without writing. (Many of them!) Now you should see the identification
(Optional). Title (or Tasks_Title) and project ID
If you changed the name of the Title column in SharePoint, change the title name
column here for Tasks_Title.
Click on the Group By button on the Start or Transform ribbon.
Click on the double header arrow at the top of the Project_ID column,
deselect all columns and select Project_Title and Title (or Title
Project ID). Uncheck "User's original column name as prefix" and click
IN AGREEMENT.
If you changed the name of the Title column in SharePoint, change the title name
column here for Project_ID.
Click on the Group By button on the Start or Transform ribbon.
Click on Advanced.
Select Project_ID from the drop-down list.
Click Add grouping and select Project_Title from the drop-down menu.
Click on the Operation drop-down menu and select Add rows.
Change the "New column name" to TaskInfo.
Click on OK
In the Add column ribbon, click Custom Column.
Enter this formula: = Table.Column ([TaskInfo], "Tasks_Title") (This is the "magic" part 1)
Change the name of the column to "Tasks".
Click on OK
Click on the double header arrow at the top of the TaskInfo column and
click on "Extract values …". (This is the "magic" part 2).
Select a delimiter from the drop-down list, or a custom value such as ",
"Click on OK.
Now you can delete the TaskInfo column.
Click Close and apply and continue with your report.
The result
My "M" code from the Power Query Advanced Editor (Your URL and GUIDs will be different)
Dear ones,
I have written below the internal union query to get the data from my database tables. But the output of this data comes with almost 3k lines. The output is below. I just need data in recent and unique "TimeSampled" rows
select DISTINCT DisplayName, ObjectName, CounterName, InstanceName, SampleValue, max (TimeSampled) as TimeSampled
of PerformanceDataAllView pdv with (NOLOCK)
internal combination PerformanceCounterView pcv in pdv.performancesourceinternalid = pcv.performancesourceinternalid
internal union BaseManagedEntity bme in pcv.ManagedEntityId = bme.BaseManagedEntityId
where ObjectName = & # 39; Processor & # 39; AND TimeSampled> = DATEADD (MINUTE, -5, GETDATE ())
And DisplayName as & # 39;% & # 39;
group by [PATH], [DisplayName], [ObjectName], [CounterName], [InstanceName], [SampleValue]
How can I retrieve results only with the last rows of Time Sampled with respect to DisplayName. I have almost 5k servers (DisplayName) like this to recover the data.
In a spreadsheet of 40,000 rows, I want to select the first 2,500 rows to copy them to another sheet. The only way I've seen is
Select the first row and tediously move the
"point" down to include all 2,500 rows. On a computer, this would be a breeze with the
Shift key. How to achieve something similar in the Android sheets? The keyboard does not open unless you are editing a cell, so any keyboard-based solution seems to have no start. Thank you.
I have created an Excel file that creates a furniture order list. The list can have from 100 rows up to 3000 rows in length, depending on the size of the order.
My problem is that the data that creates the order list includes many duplicates as shown in the image.
What you would need help with is to create a macro that takes all the matching identification numbers and combines it into a row where the quantity is combined. The list price will be the same and the total price is a function taken from the quantity * list price.
I am aware that there are several messages related to problems like mine, but I have not been able to find a solution. I do not have much experience with coding, so I would appreciate all the help I can get!
I have a script to save an individual Google sheet as a pdf document inside a certain folder.
Since the content of the sheet is dynamic and sometimes has a load of empty grid rows at the bottom, I have included a method to hide rows without content before exporting the file.
This has worked as required until very recently. Now the function hides the rows but the created file shows the rows as not hidden.
Any idea if this is due to a recent change to the Google Sheets API and is there anything I can do to get back to the previous functionality?
Here is my block of code that previously worked:
// API function to save a single sheet without hiding sheets
// ********************************************** *******************************
function singleSheetAPIExport () {
// Get the URL of the active spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet ();
var sheetName = & # 39; Example & # 39 ;;
var main = ss.getSheetByName (sheetName)
var folderID = & # 39; 1wsxxxxxxblah blah & # 39; // Google Drive folder ID
Logger.log (& # 39; maxrows: & # 39; + main.getMaxRows ());
Logger.log (& # 39; last row: & # 39; + main.getLastRow ());
// Base URL
var url = "https://docs.google.com/spreadsheets/d/SS_ID/export?".replace("SS_ID", ss.getId ());
/ * Specify PDF export parameters
From: https://code.google.com/p/google-apps-script-issues/issues/detail?id=3579
* /
var url_ext = & # 39; exportFormat = pdf & format = pdf & # 39; // export as pdf / csv / xls / xlsx
+ & # 39; & size = letter & # 39; // legal paper size / letter / A4
+ & # 39; & portrait = true & # 39; // orientation, false for the landscape
+ & # 39; & fitw = true & source = labnol & # 39; // fit the width of the page, false for the actual size
+ & # 39; & sheetnames = false & printtitle = false & # 39; // hides optional headers and footers
+ & # 39; & pagenumbers = false & gridlines = false & # 39; // hide page numbers and grids
+ & # 39; & fzr = false & # 39; & fzr = false & # 39; // do not repeat row headers (frozen rows) on each page
+ & # 39; & gid = & # 39 ;; // the identification of the sheet
var token = ScriptApp.getOAuthToken ();
// Hide all empty rows in the print sheet
var maxRows = main.getMaxRows ();
var lastRow = main.getLastRow ();
yes (maxRows-lastRow! = 0) {
main.hideRows (lastRow + 1, maxRows-lastRow);
}
// Get the answer for your specific sheet that can later be blobbed
var response = UrlFetchApp.fetch (url + url_ext + main.getSheetId (), {
headers: {
& # 39; Authorization & # 39 ;: & # 39; Carrier & # 39; + file
}
});
// Save the pdf version
var saveFolder = & # 39; PDF & # 39 ;;
var parentFolder = DriveApp.getFolderById (folderID);
var folder, folders = DriveApp.getFoldersByName (saveFolder);
yes (folders.hasNext ()) {
folder = folders.next ();
} else {
folder = parentFolder.createFolder (saveFolder);
}
name var = main.getRange ("B8"). getValue ();
var cleanName = name.replace (/ ([^a-zA-Z0-9() #%~-]) / g, "-");
folder.createFile (response.getBlob (). setName (cleanName));
// hide the rows again
var fullSheetRange = main.getRange (1,1, main.getMaxRows (), main.getMaxColumns ());
main.unhideRow (fullSheetRange);
}
