Unable to see Navigation properties nor expand then

[Brice FROMENTIN]

Hi,

I have a query builder like this :

                <EjsQueryBuilder>

                    <EjsDataManager Url="http://localhost:7121/api/odata/Utilisateurs" Adaptor="Adaptors.ODataV4Adaptor"></EjsDataManager>

                </EjsQueryBuilder>

My "Utlisateurs" is as follow :

 public partial class Utilisateur

    {

        public Utilisateur()

        {

            UtilisateurGroupes = new HashSet<UtilisateurGroupe>();

        }

        [Key]

        public Guid Id { get; set; }

        [Column(TypeName = "datetime")]

        public DateTime DateCreation { get; set; }

        public Guid? UtilisateurCreation { get; set; }

        [Column(TypeName = "datetime")]

        public DateTime? Modification { get; set; }

        public Guid? UtilisateurModification { get; set; }

        [Required]

        [StringLength(256)]

        public string Login { get; set; }

        [Required]

        [MaxLength(32)]

        public byte[] MotDePasse { get; set; }

        public bool EstBloque { get; set; }

        public bool DoitReinitialiser { get; set; }

        [Column(TypeName = "datetime")]

        public DateTime? DateDebutMotDePasse { get; set; }

        public short? DureeMotDePasse { get; set; }

        [Required]

        [StringLength(32)]

        public string Prenom { get; set; }

        [StringLength(32)]

        public string Prenom2 { get; set; }

        [StringLength(32)]

        public string Prenom3 { get; set; }

        [Required]

        [StringLength(64)]

        public string Nom { get; set; }

        [Required]

        [StringLength(256)]

        public string Mel { get; set; }

        [StringLength(20)]

        public string Telephone { get; set; }

        [StringLength(20)]

        public string Fax { get; set; }

        [Column(TypeName = "datetime")]

        public DateTime? DateDebutValidite { get; set; }

        public short? DureeValidite { get; set; }

        public Guid? IdService { get; set; }

        [ForeignKey(nameof(IdService))]

        [InverseProperty("Utilisateurs")]

        public virtual Service Service { get; set; }

        [InverseProperty(nameof(UtilisateurGroupe.Utilisateur))]

        public virtual ICollection<UtilisateurGroupe> UtilisateurGroupes { get; set; }

    }

my question is how can I see and follow navigation properties to make some join filter.

Thx

Brice

[Madhan Venkateshan]

Hi Brice, 

 

Good day to you. 

 

We have checked your requirement. You can achieve your requirement using complex data binding support, currently complex data binding support is not available in the Querybuilder control, we have logged this as improvement which will be available in Volume 2 release 2020 and appreciate your patience until then. You can track the same through the below feedback link. 

 

https://www.syncfusion.com/feedback/4875/need-to-provide-support-for-complex-data-binding-in-query-builder 

 

Regards, 

Madhan V 

[Pon Geetha A J]

Thanks, any idea of the release period ? 😊 

[Saranya Dhayalan]

Hi Brice, 

  

Most welcome…. 

  

As mentioned earlier this improvement will be included in Volume 2, 2020 release, which is expected to be available by end of June 2020. We appreciate your patience. 

  

Regards, 

Saranya D 

[YuvanShankar Arunagiri]

Hi Brice,

We are glad to announce that our Essential Studio 2022 Volume 1 SP release v20.1.0.55 is rolled out and is available for download under the following link.

https://www.syncfusion.com/forums/174993/essential-studio-2022-volume-1-service-pack-release-v20-1-0-55-is-available-for-download

Feedback Link: https://www.syncfusion.com/feedback/19288/need-to-provide-support-for-complex-data-binding  

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards,

YuvanShankar A