Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 4.0
-
Fix Version/s: 4.0
-
Component/s: None
-
Labels:None
Description
The findBySql method working not properly.
1. customer retrieved User records from the db
[Bindable]
private var usersActiveCollection:ActiveCollection;
findOptions.LoadRelations = [ "RelatedUser_role" ];
findOptions.Monitored = true;
usersActiveCollection = ActiveRecords.User.findBySql("SELECT user.* FROM user INNER JOIN user_role ON (user.id = user_role.user_id) WHERE user_role.role_id = 2" , findOptions);
2. customer create a new User record and save in to db as shown below:
private var adminRole:Role;
private function createUser():void {
var u:User = new User();
u.username = "username";
u.password = "passwd";
u.addEventListener(ActiveRecordEvent.CREATE, handleCreated);
var token:AsyncToken = u.save();
token.addResponder(new mx.rpc.Responder(handleCreated, fault));
}
private function handleCreated(u:User):void {
var ur:User_role = new User_role();
ur.relatedRole = adminRole;
ur.relatedUser = u;
ur.save();
}
3. The saved User record is not automatically added to the usersActiveCollection.
Ticket reference: http://support.themidnightcoders.com/admin/ticket_detail.php?ticket_id=MC00000677
1. customer retrieved User records from the db
[Bindable]
private var usersActiveCollection:ActiveCollection;
findOptions.LoadRelations = [ "RelatedUser_role" ];
findOptions.Monitored = true;
usersActiveCollection = ActiveRecords.User.findBySql("SELECT user.* FROM user INNER JOIN user_role ON (user.id = user_role.user_id) WHERE user_role.role_id = 2" , findOptions);
2. customer create a new User record and save in to db as shown below:
private var adminRole:Role;
private function createUser():void {
var u:User = new User();
u.username = "username";
u.password = "passwd";
u.addEventListener(ActiveRecordEvent.CREATE, handleCreated);
var token:AsyncToken = u.save();
token.addResponder(new mx.rpc.Responder(handleCreated, fault));
}
private function handleCreated(u:User):void {
var ur:User_role = new User_role();
ur.relatedRole = adminRole;
ur.relatedUser = u;
ur.save();
}
3. The saved User record is not automatically added to the usersActiveCollection.
Ticket reference: http://support.themidnightcoders.com/admin/ticket_detail.php?ticket_id=MC00000677