Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/en_AU/units/?format=api&page=22
{ "count": 4173, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/units/?format=api&page=23", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/units/?format=api&page=21", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Properties" ], "previous_source": "", "target": [ "" ], "id_hash": 2558618142951932495, "content_hash": 2558618142951932495, "location": "sf_database.xhp", "context": "sf_database.xhp\nhd_id841587913266618\nhelp.text", "note": "EF9Lc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315175/?format=api", "priority": 100, "id": 110755461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=a38209a51685024f", "url": "https://translations.documentfoundation.org/api/units/110755461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.376247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Name" ], "previous_source": "", "target": [ "" ], "id_hash": -1024355172897684507, "content_hash": -1024355172897684507, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id521587913266568\nhelp.text", "note": "x4Z5A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315184/?format=api", "priority": 100, "id": 110755464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=71c8c265c39983e5", "url": "https://translations.documentfoundation.org/api/units/110755464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.378068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Readonly" ], "previous_source": "", "target": [ "" ], "id_hash": 6382439573515894090, "content_hash": 6382439573515894090, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id421587913266368\nhelp.text", "note": "QUrYT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315196/?format=api", "priority": 100, "id": 110755467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=d892faf9fbcf7d4a", "url": "https://translations.documentfoundation.org/api/units/110755467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.379822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "" ], "id_hash": 6988644218996800360, "content_hash": 6988644218996800360, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id631587914939732\nhelp.text", "note": "3kQCm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315209/?format=api", "priority": 100, "id": 110755468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=e0fca6e3c6e43b68", "url": "https://translations.documentfoundation.org/api/units/110755468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.381370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "" ], "id_hash": -7463737517843404268, "content_hash": -7463737517843404268, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id951587913266220\nhelp.text", "note": "RYuuo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315220/?format=api", "priority": 100, "id": 110755470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=186b7a45a8302a14", "url": "https://translations.documentfoundation.org/api/units/110755470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.382845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": 3707804006823966376, "content_hash": 3707804006823966376, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id651587913266754\nhelp.text", "note": "BzLQb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315239/?format=api", "priority": 100, "id": 110755474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=b374c419738336a8", "url": "https://translations.documentfoundation.org/api/units/110755474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.383901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Array of strings" ], "previous_source": "", "target": [ "" ], "id_hash": 6874446550414247422, "content_hash": 6874446550414247422, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id421587914989890\nhelp.text", "note": "up8WT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110315250/?format=api", "priority": 100, "id": 110755475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=df66f0b718d9c5fe", "url": "https://translations.documentfoundation.org/api/units/110755475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.384791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The list of stored queries." ], "previous_source": "", "target": [ "" ], "id_hash": -6029170855003679066, "content_hash": -6029170855003679066, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id351587913266349\nhelp.text", "note": "dGoYp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315255/?format=api", "priority": 100, "id": 110755476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=2c54150d215e16a6", "url": "https://translations.documentfoundation.org/api/units/110755476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.385647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": -4787512321686226205, "content_hash": -4787512321686226205, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id931599409717463\nhelp.text", "note": "bfdLR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315257/?format=api", "priority": 100, "id": 110755479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=3d8f56e8a4163ae3", "url": "https://translations.documentfoundation.org/api/units/110755479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.392965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Array of strings" ], "previous_source": "", "target": [ "" ], "id_hash": 3167374122562056857, "content_hash": 3167374122562056857, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id71599409717945\nhelp.text", "note": "2DDTs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110315263/?format=api", "priority": 100, "id": 110755482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=abf4c5fba6137299", "url": "https://translations.documentfoundation.org/api/units/110755482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.397988Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The list of stored tables." ], "previous_source": "", "target": [ "" ], "id_hash": -2746091359252635800, "content_hash": -2746091359252635800, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id341599409717612\nhelp.text", "note": "rGTvw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315301/?format=api", "priority": 100, "id": 110755489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=59e3ec754afa1f68", "url": "https://translations.documentfoundation.org/api/units/110755489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.403847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": -8639237245016546306, "content_hash": -8639237245016546306, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id741599409777967\nhelp.text", "note": "u5YE4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315332/?format=api", "priority": 100, "id": 110755493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=081b437f9076e3fe", "url": "https://translations.documentfoundation.org/api/units/110755493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.405918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The UNO object representing the current database connection." ], "previous_source": "", "target": [ "" ], "id_hash": 2178779382469130927, "content_hash": 2178779382469130927, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id551599409777759\nhelp.text", "note": "evuSw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315342/?format=api", "priority": 100, "id": 110755498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=9e3c944e00047aaf", "url": "https://translations.documentfoundation.org/api/units/110755498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.407771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": 7242074428110287102, "content_hash": 7242074428110287102, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599409887585\nhelp.text", "note": "w9YZG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110315353/?format=api", "priority": 100, "id": 110755502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=e48104527c7430fe", "url": "https://translations.documentfoundation.org/api/units/110755502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.409439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The UNO object representing the metadata describing the database system attributes." ], "previous_source": "", "target": [ "" ], "id_hash": 4706871438869749646, "content_hash": 4706871438869749646, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id861599409887284\nhelp.text", "note": "NeTGg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315364/?format=api", "priority": 100, "id": 110755506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=c1522aa2b5435f8e", "url": "https://translations.documentfoundation.org/api/units/110755506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.411050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "List of Methods in the Database Service" ], "previous_source": "", "target": [ "" ], "id_hash": 4015322983893273180, "content_hash": 4015322983893273180, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id231614360519973\nhelp.text", "note": "ApsdK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315375/?format=api", "priority": 100, "id": 110755509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=b7b94afad16b8a5c", "url": "https://translations.documentfoundation.org/api/units/110755509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.412653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Closes the current database connection." ], "previous_source": "", "target": [ "" ], "id_hash": 7042633241067681510, "content_hash": 7042633241067681510, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id201587913266596\nhelp.text", "note": "emrA2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110315377/?format=api", "priority": 100, "id": 110755512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=e1bc759e893276e6", "url": "https://translations.documentfoundation.org/api/units/110755512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.414145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Commits all updates done since the previous <literal>Commit</literal> or <literal>Rollback</literal> call." ], "previous_source": "", "target": [ "" ], "id_hash": 5244603176257451156, "content_hash": 5244603176257451156, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id201587913264308\nhelp.text", "note": "xhv9F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315379/?format=api", "priority": 100, "id": 110755514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=c8c892cd3cb5f494", "url": "https://translations.documentfoundation.org/api/units/110755514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.415409Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "This method is ignored if commits are done automatically after each SQL statement, i.e. the database is set to the default auto-commit mode." ], "previous_source": "", "target": [ "" ], "id_hash": 3622277481549208839, "content_hash": 3622277481549208839, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id391701355293522\nhelp.text", "note": "P4TEF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110315396/?format=api", "priority": 100, "id": 110755516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=b244ea2d85a31d07", "url": "https://translations.documentfoundation.org/api/units/110755516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.416650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Set the REPEATABLE_READ transaction level" ], "previous_source": "", "target": [ "" ], "id_hash": -5545983312272246502, "content_hash": -5545983312272246502, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id141701355821478\nhelp.text", "note": "DHATj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110315423/?format=api", "priority": 100, "id": 110755518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=3308b58fb5c4b91a", "url": "https://translations.documentfoundation.org/api/units/110755518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.417869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Test some condition before committing" ], "previous_source": "", "target": [ "" ], "id_hash": -3122915307201618239, "content_hash": -3122915307201618239, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id311701355662993\nhelp.text", "note": "2mfAJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110315446/?format=api", "priority": 100, "id": 110755519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=54a92d12f29e1ec1", "url": "https://translations.documentfoundation.org/api/units/110755519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.419046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Restore auto-commit mode" ], "previous_source": "", "target": [ "" ], "id_hash": -7027345816749945171, "content_hash": -7027345816749945171, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id711701355663208\nhelp.text", "note": "xNjdS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110315459/?format=api", "priority": 100, "id": 110755520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=1e79da364ecacead", "url": "https://translations.documentfoundation.org/api/units/110755520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.420218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Creates a <literal>Dataset</literal> service instance based on a table, query or SQL <literal>SELECT</literal> statement." ], "previous_source": "", "target": [ "" ], "id_hash": 2164841578841432693, "content_hash": 2164841578841432693, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id41599488113502\nhelp.text", "note": "XigYX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315477/?format=api", "priority": 100, "id": 110755521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=9e0b0ff235d6e275", "url": "https://translations.documentfoundation.org/api/units/110755521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.421384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>sqlcommand</emph>: A table name, a query name or a valid SQL <literal>SELECT</literal> statement. Identifiers may be enclosed with square brackets. This argument is case-sensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -2276020279883234172, "content_hash": -2276020279883234172, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id591701267115505\nhelp.text", "note": "MX6BM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110315492/?format=api", "priority": 100, "id": 110755525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=6069f39d43f98484", "url": "https://translations.documentfoundation.org/api/units/110755525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.427137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>directsql</emph>: Set this argument to <literal>True</literal> to send the statement directly to the database engine without preprocessing by %PRODUCTNAME (Default = <literal>False</literal>)." ], "previous_source": "", "target": [ "" ], "id_hash": 3028658484650172843, "content_hash": 3028658484650172843, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id841701267114060\nhelp.text", "note": "HSKm4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110315665/?format=api", "priority": 100, "id": 110755527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=aa07f4d8638be1ab", "url": "https://translations.documentfoundation.org/api/units/110755527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.429645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>filter</emph>: Specifies the condition that records must match to be included in the returned dataset. This argument is expressed as a SQL <literal>WHERE</literal> statement without the \"WHERE\" keyword." ], "previous_source": "", "target": [ "" ], "id_hash": -5336237315516567488, "content_hash": -5336237315516567488, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id241701267114527\nhelp.text", "note": "ZoWu5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110315678/?format=api", "priority": 100, "id": 110755530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=35f1e06f23737040", "url": "https://translations.documentfoundation.org/api/units/110755530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.431985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>orderby</emph>: Specifies the ordering of the dataset as a SQL <literal>ORDER BY</literal> statement without the \"ORDER BY\" keyword." ], "previous_source": "", "target": [ "" ], "id_hash": 5643025730111777603, "content_hash": 5643025730111777603, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id471701267115093\nhelp.text", "note": "SGBKv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315688/?format=api", "priority": 100, "id": 110755532, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=ce500e00e5b3ab43", "url": "https://translations.documentfoundation.org/api/units/110755532/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.434077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The following examples in Basic and Python return a dataset with the records of a table named \"Customers\"." ], "previous_source": "", "target": [ "" ], "id_hash": 4064104474469736385, "content_hash": 4064104474469736385, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id941701267748877\nhelp.text", "note": "V8pDK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315698/?format=api", "priority": 100, "id": 110755538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=b866997caad81fc1", "url": "https://translations.documentfoundation.org/api/units/110755538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.437907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "oDataset = myDatabase.CreateDataset(\"Customers\", Filter := \"[Name] LIKE 'A'\")" ], "previous_source": "", "target": [ "" ], "id_hash": 7571557130954659453, "content_hash": 7571557130954659453, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id241701267631273\nhelp.text", "note": "Ebnho", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315709/?format=api", "priority": 100, "id": 110755541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=e91393184320d67d", "url": "https://translations.documentfoundation.org/api/units/110755541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.439850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "dataset = myDatabase.CreateDataset(\"Customers\", Filter = \"[Name] LIKE 'A'\")" ], "previous_source": "", "target": [ "" ], "id_hash": -5451003037203448873, "content_hash": -5451003037203448873, "location": "sf_database.xhp", "context": "sf_database.xhp\npyc_id931701267696812\nhelp.text", "note": "h2NSq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110315711/?format=api", "priority": 100, "id": 110755545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=345a259e49e9bbd7", "url": "https://translations.documentfoundation.org/api/units/110755545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.441132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Computes the given aggregate function on a field or expression belonging to a table." ], "previous_source": "", "target": [ "" ], "id_hash": -394164150598057819, "content_hash": -394164150598057819, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id13159655484952\nhelp.text", "note": "nwbSh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1081, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315713/?format=api", "priority": 100, "id": 110755547, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=7a87a5cb1c68c0a5", "url": "https://translations.documentfoundation.org/api/units/110755547/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.442064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Optionally, a SQL <literal>WHERE</literal> clause can be specified as a filter that will be applied prior to the aggregate function." ], "previous_source": "", "target": [ "" ], "id_hash": -6735777180227982965, "content_hash": -6735777180227982965, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id101615148468548\nhelp.text", "note": "E9LsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110315714/?format=api", "priority": 100, "id": 110755549, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=2285b6579e54298b", "url": "https://translations.documentfoundation.org/api/units/110755549/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.443689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 1472519472863268151, "content_hash": 1472519472863268151, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id441596554849949\nhelp.text", "note": "AKqei", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315732/?format=api", "priority": 100, "id": 110755558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=946f70a8a8dc4d37", "url": "https://translations.documentfoundation.org/api/units/110755558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.451080Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>tablename</emph>: A table name (without square brackets)." ], "previous_source": "", "target": [ "" ], "id_hash": 4289925557642658672, "content_hash": 4289925557642658672, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id381596554849698\nhelp.text", "note": "c2Rzq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315753/?format=api", "priority": 100, "id": 110755563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=bb88e090d0290370", "url": "https://translations.documentfoundation.org/api/units/110755563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.454027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 5542733523592601938, "content_hash": 5542733523592601938, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id521596554849185\nhelp.text", "note": "cjGPp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110315768/?format=api", "priority": 100, "id": 110755566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=ccebbec5e662e152", "url": "https://translations.documentfoundation.org/api/units/110755566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.455661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The example below assumes the file <literal>Employees.odb</literal> has a table named <literal>EmployeeData</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -6188979905976865405, "content_hash": -6188979905976865405, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id781615150306678\nhelp.text", "note": "AGBFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110315790/?format=api", "priority": 100, "id": 110755569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=2a1c5390ee37ed83", "url": "https://translations.documentfoundation.org/api/units/110755569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.457387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Counts the number of employees in the table" ], "previous_source": "", "target": [ "" ], "id_hash": -8447375229691205009, "content_hash": -8447375229691205009, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id871615150277916\nhelp.text", "note": "KAqZB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110315817/?format=api", "priority": 100, "id": 110755573, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=0ac4e4fc15d26a6f", "url": "https://translations.documentfoundation.org/api/units/110755573/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.458858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Returns the sum of all salaries in the table" ], "previous_source": "", "target": [ "" ], "id_hash": 410635201929468043, "content_hash": 410635201929468043, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id291615150373387\nhelp.text", "note": "AVstM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110315824/?format=api", "priority": 100, "id": 110755576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=85b2de8a5f46d88b", "url": "https://translations.documentfoundation.org/api/units/110755576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.460448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "' Below are some examples of how tables can be filtered" ], "previous_source": "", "target": [ "" ], "id_hash": 216717035045705298, "content_hash": 216717035045705298, "location": "sf_database.xhp", "context": "sf_database.xhp\nbas_id931615150423062\nhelp.text", "note": "cMiVJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110315826/?format=api", "priority": 100, "id": 110755580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=8301eefec2acd652", "url": "https://translations.documentfoundation.org/api/units/110755580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.462196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Computes a SQL expression on a single record returned by a <literal>WHERE</literal> clause defined by the <literal>Criteria</literal> parameter." ], "previous_source": "", "target": [ "" ], "id_hash": -296676254251143446, "content_hash": -296676254251143446, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id41599488113961\nhelp.text", "note": "kCmmv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315828/?format=api", "priority": 100, "id": 110755584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=7be1fe84c4112eea", "url": "https://translations.documentfoundation.org/api/units/110755584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.464059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "If the query returns multiple records, only the first one is considered. Use the <literal>OrderClause</literal> parameter to determine how query results are sorted." ], "previous_source": "", "target": [ "" ], "id_hash": -2636970318474075453, "content_hash": -2636970318474075453, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id601615381471954\nhelp.text", "note": "8yUaz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110315831/?format=api", "priority": 100, "id": 110755587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=5b679977741aa2c3", "url": "https://translations.documentfoundation.org/api/units/110755587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.466121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 8452656534688239251, "content_hash": 8452656534688239251, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id671599488113986\nhelp.text", "note": "tNnSe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1092, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315833/?format=api", "priority": 100, "id": 110755589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=f54dde558e7a0e93", "url": "https://translations.documentfoundation.org/api/units/110755589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.468745Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>tablename</emph>: A table name (without square brackets)." ], "previous_source": "", "target": [ "" ], "id_hash": 353889189712419124, "content_hash": 353889189712419124, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id441599488113247\nhelp.text", "note": "eGbAr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110315835/?format=api", "priority": 100, "id": 110755594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=84e94457d2a8d934", "url": "https://translations.documentfoundation.org/api/units/110755594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.471165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": -8457723585346991710, "content_hash": -8457723585346991710, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id40159948811316\nhelp.text", "note": "F9xaH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110315837/?format=api", "priority": 100, "id": 110755600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=0aa02135c6f309a2", "url": "https://translations.documentfoundation.org/api/units/110755600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.476730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>orderclause</emph>: An <literal>ORDER BY</literal> clause without the \"ORDER BY\" keywords. Field names should be surrounded with square brackets." ], "previous_source": "", "target": [ "" ], "id_hash": 1763450666600376156, "content_hash": 1763450666600376156, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id71599488689029\nhelp.text", "note": "SusUk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315863/?format=api", "priority": 100, "id": 110755603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=98790909c1a4275c", "url": "https://translations.documentfoundation.org/api/units/110755603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.479011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "Stores the contents of a table or the results of a <literal>SELECT</literal> query or of an SQL statement in a two-dimensional array. The first index in the array corresponds to the rows and the second index refers to the columns." ], "previous_source": "", "target": [ "" ], "id_hash": -8010518287784202902, "content_hash": -8010518287784202902, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id481599489278579\nhelp.text", "note": "CPoBx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110315907/?format=api", "priority": 100, "id": 110755614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=10d4ec0f0dda2d6a", "url": "https://translations.documentfoundation.org/api/units/110755614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.485100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "An upper limit can be specified to the number of returned rows. Optionally column names may be inserted in the first row of the array." ], "previous_source": "", "target": [ "" ], "id_hash": 7955536931485659761, "content_hash": 7955536931485659761, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id821615384762425\nhelp.text", "note": "GXji8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1097, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110315929/?format=api", "priority": 100, "id": 110755618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=ee67beb05eb43271", "url": "https://translations.documentfoundation.org/api/units/110755618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.490294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "The returned array will be empty if no rows are returned and the column headers are not required." ], "previous_source": "", "target": [ "" ], "id_hash": 1551240638000359276, "content_hash": 1551240638000359276, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599490209915\nhelp.text", "note": "gX7AY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110315939/?format=api", "priority": 100, "id": 110755623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=95871d243529676c", "url": "https://translations.documentfoundation.org/api/units/110755623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.493421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>sqlcommand</emph>: A table or query name (without square brackets) or a <literal>SELECT</literal> SQL statement." ], "previous_source": "", "target": [ "" ], "id_hash": 9076569138327269887, "content_hash": 9076569138327269887, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id451599489278429\nhelp.text", "note": "y5u8i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110315949/?format=api", "priority": 100, "id": 110755625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=fdf6738aa54531ff", "url": "https://translations.documentfoundation.org/api/units/110755625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.496209Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_AU/?format=api", "source": [ "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. This argument is ignored for tables. For queries, the applied option is the one set when the query was defined." ], "previous_source": "", "target": [ "" ], "id_hash": 8814331015989700384, "content_hash": 8814331015989700384, "location": "sf_database.xhp", "context": "sf_database.xhp\npar_id271599489278141\nhelp.text", "note": "xAbDx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110315963/?format=api", "priority": 100, "id": 110755632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_AU/?checksum=fa52cb5bd4c62720", "url": "https://translations.documentfoundation.org/api/units/110755632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:23:36.503814Z" } ] }