About Rares_Lungu

Rares_Lungu · 11-01-2023

Hello everyone! Some context first:I have a BigQuery data source (around repair jobs on properties) with about half a million rows that I would like to bring to AppSheet to allow for easier searching by non-technical users. I've been trying to design...

Rares_Lungu · 11-02-2023

Hello @AleksiAlkio! I have seen this before as well. I thought that the way I was using the security filters should allow me to filter through the entire data (i.e., more than 100k rows).

Rares_Lungu · 11-02-2023

Sure thing! Because the base table is so big, I have instead created a couple of auxiliary tables with all the possible distinct values. Because of that, I can use something like this for the suggested values: All the other fields have similar formul...

Rares_Lungu · 11-02-2023

Hello @Aurelien, and thank you for pitching in! Regarding the size limit, I was under the impression that the source data size is not as important as AppSheet will initially load the data on their servers, apply any filtering, and then cap the result...

Rares_Lungu · 11-02-2023

I have used the Analyzer as you suggested, and this is what I saw when using my original Security Filter (with a three-clause OR statement): Interestingly enough, the filter didn't appear at all.This was the log for the same table when I used a singl...

Rares_Lungu · 11-02-2023

Hello @Suvrutt_Gurjar, and thank you for your suggestions!Regarding your points:1. I was aware of this, but thank you for the reminder. I have been keeping this in mind while testing.2. I hoped that was the problem, but I have tested this as well, an...

My Stats

Rares_Lungu's Bio

Badges Rares_Lungu Earned

Recent Activity

Missing records on large BigQuery data with Security Filters

Re: Missing records on large BigQuery data with Security Filters

Re: Missing records on large BigQuery data with Security Filters

Re: Missing records on large BigQuery data with Security Filters

Re: Missing records on large BigQuery data with Security Filters

Re: Missing records on large BigQuery data with Security Filters