square-fall-50066
04/12/2024, 7:16 PMgray-hair-34494
04/13/2024, 4:04 PMbest-exabyte-32706
04/15/2024, 11:45 AMcalm-country-40626
04/15/2024, 12:05 PMdazzling-telephone-99947
04/15/2024, 12:13 PMdazzling-telephone-99947
04/15/2024, 12:20 PMcalm-country-40626
04/15/2024, 6:24 PMbumpy-refrigerator-38902
04/16/2024, 8:21 AMgray-cat-4891
04/16/2024, 9:53 AMgray-cat-4891
04/16/2024, 9:55 AMechoing-guitar-56191
04/16/2024, 4:19 PMshy-library-18941
04/16/2024, 11:52 PMprehistoric-toddler-2858
04/17/2024, 3:57 PMpages/
|-- folder/
|-- customers/
|-- [customer].md
`-- index.md
bumpy-refrigerator-38902
04/18/2024, 5:12 AMstocky-waitress-984
04/18/2024, 5:19 AMstocky-waitress-984
04/18/2024, 6:45 AMswift-dinner-24920
04/18/2024, 11:58 AM{inputs.<ButtonGroupName>}
be used in the components? I guess not because I tried but I might miss something, so I ask it here 🙂. I want a grid with 6 datatables (with max 10 rows per page) that could be created from 1 SQL query. The query is a simple select for the 6 fields I want to show and a count(*) grouped an all 6 dimensions.
What I would like to do is in the datatable with columns
component point to one of the dimension fields and the count column and have a total per dimension. Then I make a copy of the component and change the dimension field to one of the other 6 dimensions, and so on …
That did not work and I somewhat managed to get something like that using a ButtonGroup with 6 hardcoded values and in the query for the dimension field I point to ${inputs.ButtonGroupName}
and the count and then it works for me.
But I would like to have the user not click on a button (already better than a dropdown in this regard) but I want to show a grid of 2 rows with each row having 3 columns with a datatable. I understand I then have to create the 6 separate components but I would like to keep the query limited to only 1.
My buttongroup is like
<ButtonGroup name=test>
<ButtonGroupItem valueLabel="Reporter" value="reporter" default />
<ButtonGroupItem valueLabel="Assignee" value="assignee" />
<ButtonGroupItem valueLabel="Project name" value="project_name" />
</ButtonGroup>
My query is …
```sql reporter_count
select "${inputs.test}", count(*) as aantal
from issues
group by 1
order by 2 desc
```
and by datatable component is
<DataTable data={reporter_count}
search=true
rows=10
/>
and I would prefer my query to be something like
```sql reporter_count
select project_key, reporter, assignee, count(*) as count
from issues
group by 1,2,3
order by 4 desc
```
and my component code to be like
<DataTable data={reporter_count}>
<Column id=${inputs.test.value.PROJECT_KEY} />
<Column id=count />
</DataTable>
<DataTable data={reporter_count}>
<Column id=${inputs.test.value.REPORTER} />
<Column id=count />
</DataTable>
<DataTable data={reporter_count}>
<Column id=${inputs.test.value.ASSIGNEE} />
<Column id=count />
</DataTable>
I can realize this using 6 different queries but I have other scenario’s where that would be very impractical.
I got some inspiration from this thread … https://evidencedev.slack.com/archives/C023MMFSWKU/p1713274549080409?thread_ts=1713274509.266989&cid=C023MMFSWKUprehistoric-toddler-2858
04/18/2024, 3:11 PMorange-table-18300
04/18/2024, 4:25 PMraw ◥ Expected row count is ~1,967,034 WARNING: Estimated output size is 251.372mb uncompressed. This may cause client-side performance issues.this is true. browser cpu consumption of ~75% and memory usage of ~1.75GB issue 2: from "raw" within my reports i'm creating filters for displaying different resourcenames using a dropdown
<Dropdown
name=resource_names
data={distinct_resources}
value=resourcename
defaultValue="auvprrdsq99"
/>
```sql distinct_resources
select distinct resourcename
from raw
order by resourcename
```
not all resourcenames are populating the dropdown list (admittedly, there are 210 of them)
this all seems extremely excessive and i'd like to find better ways to make this a bit better. i wish i could filter the source query for the raw
data source based on some url parameter to make the initial load on the client easier because i'm not sure i want to create 210 data sources and create new ones when a new resource comes available. unless that's something dbt can do (i have no experience with dbt). does anyone have any thoughts on how to address these issues?great-boots-39022
lemon-cricket-39335
04/21/2024, 5:46 PMechoing-guitar-56191
04/22/2024, 2:15 PM`sql pick_list`
select
order_date,
item,
email,
address,
state
from orders
where item like '${$page.params.item}'
order by order_date
I'm assuming this is not recommended bec of SQL Injection?delightful-application-94642
04/22/2024, 11:59 PMechoing-guitar-56191
04/23/2024, 1:29 AMswift-dinner-24920
04/23/2024, 4:56 PM{each}
component? The following does not work, but I am not sure if my reference in the SQL query reporter_count
is just wrong.
```sql status_select
select distinct status from issues order by status
{#each status_select as category}
## {category.status} --THIS WORKS CORRECTLY!!
sql reporter_count
select projectname, count(*) as "# Issues"
from issues
where status = '<Value data={category} column=status/>'
group by 1
order by 2 desc
<DataTable
data={reporter_count}
search=true
rowShading=true
totalRow=true
rows=15
/>
{/each}```
The error is that the referenced column "<Value data={category.status}>"
is not found in FROM clause.
When I use single quotes around the <Value data={category.status}>
evidence says “Dataset is empty: query ran successfully, but no data was returned from the database”. And I know for a fact it is not empty.
UPDATE: I also tried with {category.status}
and ${category.status}
but both result in a white screen with nothing.able-yak-3257
04/23/2024, 7:48 PMfull-carpenter-99365
04/24/2024, 3:51 AMechoing-printer-11394
04/25/2024, 1:23 PM/pagename
instead of pagename
, manifests and api are expected at /api/...
and /data/manifest.json
. Is there a way to generate relative paths instead, or to provide the build process with a root path that the content should be relative to?enough-motorcycle-39926
04/25/2024, 7:38 PMbumpy-refrigerator-38902
04/26/2024, 7:34 AM