Databases
StackOverflow2013
Postsdbo
POGoogle Drive SDK feature request for > and < operators on title field
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGoogle Drive SDK feature request for > and < operators on title field
    primarykey
    data
    text
    <p>The documentation at <a href="https://developers.google.com/drive/search-parameters" rel="nofollow">https://developers.google.com/drive/search-parameters</a> indicates that the less than and the greater than operators do not apply to the file title field, which seems to prevent searching according to an alphabetical range. Below is my particular use case for alphabetical search.</p> <p>I'm writing an Android application called <a href="https://play.google.com/store/apps/details?id=com.eduneer.ftnote" rel="nofollow">ftNote</a> that provides gait analysis for runners wearing the application strapped to their calf as they run. The application provides some real-time feedback to the runner (e.g., high impact alarm and stride rate announcements) and also provides the option to log the sensor data that then gets uploaded to Google Drive for further analysis. The sensor data log files are saved in a queue of user specified length N (e.g., 5) of most recent logs and are named with a non-standard timestamp (e.g., 2013_04_25T13_25_40.bmp) to avoid the '-' and ':' characters that would possibly cause problems in Windows filenames. Although the accelerometer, magnetometer, and gyroscope sensors are sampled at 50 Hz, the resulting data is stored in less than 5 Mbytes per hour. Therefore it is conceivable that avid runners could save thousands of sensor data logs in their Google Drive account.</p> <p>When uploading a local set of data sensor logs, ftNote first checks to see if the files already exist on Google Drive. It would be convenient if Google Drive could be queried for just the files with titles in the alphabetical range between the names of the first logged file and the last logged file in the queue of N files. </p> <p>That's my particular use case at the moment, but it seems there are many others (e.g., an alphabetically indexed ListView). I hope my feature request makes sense. If not, please let me know what needs clarification.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USgregS
    1. USgregS
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGoogle Drive SDK feature request for > and < operators on title field
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POGoogle Drive SDK feature request for > and < operators on title field
      1. This table or related slice is empty.
      1. VTUpMod
    1. COare you saying you want to convert the title into a date and search by date created?
      singulars
      1. POGoogle Drive SDK feature request for > and < operators on title field
      1. USEluvatar
    2. CODirectly searching through an alphabetical range of titles is the feature I'd like. But you are right that in my particular case I currently take the intermediate step of converting the title to a time stamp and search with that. Of course that approach wouldn't work for general titles.
      singulars
      1. POGoogle Drive SDK feature request for > and < operators on title field
      1. USgregS
    3. COYou're right that we don't support range queries on the title field and it looks like there is no great workaround I can suggest. We're going to consider your feature request for the future releases. Btw, our community would be a better place for your feature requests: https://plus.google.com/communities/107264319205603895037 All development related questions are welcomed on Stackoverflow.
      singulars
      1. POGoogle Drive SDK feature request for > and < operators on title field
      1. USBurcu Dogan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload