+- LiveCloud Forums (https://forums.livecloud.io)
+-- Forum: General (https://forums.livecloud.io/forumdisplay.php?fid=1)
+--- Forum: General (https://forums.livecloud.io/forumdisplay.php?fid=3)
+--- Thread: Query cdbDateModified (/showthread.php?tid=264)
Query cdbDateModified - JereMiami - 12-21-2019
Hello everyone!
A few weeks back I inquired about returning the cdbDateCreated subkey value of the key "cdb" (which is measured in seconds from the beginning of the eon).
I was able to do this by unpacking the array into lines (e.g., "cdbDateCreated" is line 2 of that array):
--
put cdb_lookUpValue(table, tLine, "cdb", "cloud") into tTempHolder
combine tTempHolder using return
put line 2 of tTempHolderinto tHolder
--
Now I would like to query the "cdbDateCreated" subkey via cdb_Query to find values after a certain point in time. No clue how I would write that (i.e., x > line 2 of "cdb"). Anyone know how to do this?
cdb_Read(________,">","538198318" … )
RE: Query cdbDateModified - efrain.c - 12-28-2019
Hi JereMiami,
All "cdb" keys can be queried using cdb_query. You can find all records after a certain point in time using the following:
put cdb_query("cdbDateCreated", ">", tSeconds, tTableName, tTarget, tResultFormat) into tOutputA
where
tSeconds is the point in time in seconds
tTableName is the name of the table to query
tTarget is "local" or "cloud"
tResultFormat is "recordList" or "recordData"
tOutputA will contain all records that meet the query criteria.
RE: Query cdbDateModified - JereMiami - 01-15-2020
Thanks so much. I will give it a try!
RE: Query cdbDateModified - JereMiami - 01-24-2020
Success! Thanks so much.