Starling Forum

1. 

   Shaun Max
   

   Expert Bird
   Joined: Nov '13
   Posts: 311

   

   Shaun Max

   Expert Bird
   Joined: Nov '13
   Posts: 311

   I am not sure, if this is possible or not. For the following query :-

   var query: Query = new Query(TopPlayers, "wonDate == ?", "06292017");
   query.limit = 3;
   query.orderBy = "highScore DESC";

   Query returned - 1 Top player = [Entity type="TopPlayers" id="uGUb73UHE1r3mekf" createdAt="2017-06-29T10:52:38.787Z" updatedAt="2017-06-29T10:55:59.504Z" ownerId="uGUb73UHE1r3mekf"]

   Its not returning the highScore of the player.

   Am I missing something or used the wrong query?
   What should be the approach for such a requirement.

   Thanks
   Shaun

   Posted 1 year ago #
2. 

   Daniel
   

   Primary Feather
   Joined: Jan '10
   Posts: 5,877

   

   Daniel

   Primary Feather
   Joined: Jan '10
   Posts: 5,877

   Does the "TopPlayers" entity — that is, the respective AS3 class — contain a "highscore" property? And is that property R/W? In that case, the instance that's returned should contain the appropriate value!

   Posted 1 year ago #
3. 

   Shaun Max
   

   Expert Bird
   Joined: Nov '13
   Posts: 311

   

   Shaun Max

   Expert Bird
   Joined: Nov '13
   Posts: 311

   package {
   	import com.gamua.flox.Entity;
    
   	public class TopPlayers extends Entity {
    
   		private var _highScore: Number = 0;
   		private var _wonDate: String;
    
   		public function TopPlayers() {
   			// constructor code
   		}
    
   		public function get highScore(): Number {
   			return _highScore;
   		}
    
   		public function set highScore(value: Number): void {
   			_highScore = value;
   		}
    
   		public function get wonDate(): String {
   			return _wonDate;
   		}
    
   		public function set wonDate(value: String): void {
   			_wonDate = value;
   		}
    
   	}
    
   }

   Above is the class! & Below is the function that saves value!

   public function saveScore(val: Number, time: Date): void {
    
   			myScore.id = currentPlayer.id ;
   			myScore.highScore = val;
   			myScore.wonDate = getTheDate(time);
    
   			//save it to Flox using the instance method
   			myScore.saveQueued();
   		}

   Posted 1 year ago #
4. 

   Shaun Max
   

   Expert Bird
   Joined: Nov '13
   Posts: 311

   

   Shaun Max

   Expert Bird
   Joined: Nov '13
   Posts: 311

   hw to change the variables R/W property ?

   Posted 1 year ago #
5. 

   Daniel
   

   Primary Feather
   Joined: Jan '10
   Posts: 5,877

   

   Daniel

   Primary Feather
   Joined: Jan '10
   Posts: 5,877

   Hmmmm — that does look correct to my eyes; the highscore *should* be stored correctly. Maybe the code you use as the query callback is wrong? Could you post the code you use for "query.find()"?

   Posted 1 year ago #
6. 

   Shaun Max
   

   Expert Bird
   Joined: Nov '13
   Posts: 311

   

   Shaun Max

   Expert Bird
   Joined: Nov '13
   Posts: 311

   here is it!

   query.find(
   function onComplete(topPlayers: Array): void {
   if (topPlayers.length > 0) {
    trace("Query returned - Top players = ", topPlayers);
   } else if (topPlayers.length == 0) {
    trace("Query returned Empty Array");
   }
   },
   function onError(error: String): void {
   //Something went wrong during the execution of the query.
   //The player's device may be offline.
   trace("The player's device may be offline", error);
   });

   Also i wanted know can flox do queries like sql ???

   eg :-

   Select SUM(ammo) FROM Player WHERE team = "WildFoxes";

   Player will be an entity with a variables 'ammo' and 'team'.

   ammo will be a integer variable and team will string.

   Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.