Filter areas in powertools generated code #11815

8 Answer(s)

• 

  0

  ismcagdas created 4 months ago

  Support Team

  Hi,

  Is ProduitLibelle a special field ? I'm asking because it's value is either * or ENTERED_VALUE*. Could you also share a databas value for ProduitLibelle and value of input.ProduitLibelleFilter when you debug the source code.

  Thanks,

  Save Cancel
• 

  0

  alliance225 created 4 months ago

  Hello, sorry was away for a while.

  No ProduitLibelle is a regular model propertie.

  public class Produit : AuditedEntity, IMayHaveTenant { public int? TenantId { get; set; }

   [Required]
   public virtual string Libelle { get; set; }
  
   [Required]
   public virtual string Code { get; set; }
  
   public virtual bool Sommeil { get; set; }=false;
  
   public virtual double PrixAchat { get; set; }
  
   public virtual int? MoleculeId { get; set; }
  
   [ForeignKey("MoleculeId")]
   public Molecule MoleculeFk { get; set; }
  
   public virtual int? ClasseTherapeutiqueId { get; set; }
  
   [ForeignKey("ClasseTherapeutiqueId")]
   public ClasseTherapeutique ClasseTherapeutiqueFk { get; set; }
  
   public virtual int? CategoryId { get; set; }
  
   [ForeignKey("CategoryId")]
   public Category CategoryFk { get; set; }
  

  }

  public class Pays : AuditedEntity, IMayHaveTenant
  {
      public int? TenantId { get; set; }
  
      [Required]
      public virtual string Libelle { get; set; }
  
      public virtual int ReseauId { get; set; }
  
      [ForeignKey("ReseauId")]
      public Reseau ReseauFk { get; set; }
  
  }
  

  public class Visa : FullAuditedEntity, IMayHaveTenant { public int? TenantId { get; set; }

    [Required]
    public virtual string Numero { get; set; }
  
    public virtual DateTime DateObtention { get; set; }
  
    public virtual DateTime DateValidite { get; set; }
    //File
  
    public virtual Guid? Fichier { get; set; } //File, (BinaryObjectId)
  
    public virtual int ProduitId { get; set; }
  
    [ForeignKey("ProduitId")]
    public Produit ProduitFk { get; set; }
  
    public virtual int PaysId { get; set; }
  
    [ForeignKey("PaysId")]
    public Pays PaysFk { get; set; }
  

  }

  Sample Produit values:

  361 1 ARTEDIAM 400MG CPR B/12 ARTE154 False 40761 NULL NULL 2023-10-28 20:37:48.9148423 NULL NULL NULL 1,82 363 1 ARTEDIAM 75MG/5ML SP F/30ML ARTE156 False 40761 NULL NULL 2023-10-28 20:37:48.9148426 NULL NULL NULL 1,35 364 1 CEVIT VIT C 100MG CPR B/10 CEVI102 False 40766 NULL NULL 2023-10-28 20:37:48.9148427 NULL NULL NULL 0,53 367 1 OXAPEN 500MG CPR B/12 OXAP105 False 42041 NULL NULL 2023-10-28 20:37:48.9148428 NULL NULL NULL 1,6

  Save Cancel
• 

  0

  ismcagdas created 4 months ago

  Support Team

  Hi @alliance225

  Is it possible to share your solution via email witn [email protected] ? It will be easier to check this by running your app.

  Thanks,

  Save Cancel
• 

  0

  alliance225 created 4 months ago

  Hi, there

  I have sent the project via email.

  The issue is with https://localhost:44302/App/Visas

  Save Cancel
• 

  0

  alliance225 created 4 months ago

  Hello, sorry I am sending again the project because I had some lines commented out while debugging.

  Save Cancel
• 

  0

  ismcagdas created 4 months ago

  Support Team

  Hi,

  Thanks, we received the project. I had a problem for data creation and disabled some of the migrations to run the app. After that, I created sample records to test this case. As you can see in the screenshot below, filtering by "(Produit) Libelle" worked for me. Could you tell me if I'm testing this in a wrong way ?

  

  Save Cancel
• 

  0

  alliance225 created 4 months ago

  

  Weird, as you can see, it is not filtering. Maybe because of some migrations?

  I have also sent you the packpac.

  Maybe you can also send me the application with the migrations that were disabled.

  Save Cancel
• 

  0

  ismcagdas created 3 months ago

  Support Team

  Hi,

  If you mean you have sent the database, I haven't received it. Could you send it again ?

  Thanks,

  Save Cancel