searchbuilder gives wrong warning if column contains datetime

[tomnobelsAM]

When there is a datetime column (even after conversion to datetime with pandas) the searchbuilder always gives a warning that he needs a datetime and refuses to show the searchbuilder.

as object or datetime , I always get the warning

so datetime in dataframe means no searchbuilder

Has someone a solution for this ?

Thanks a lot in advance

[mwouts]

Hello @tomnobelsAM , the issue description ressembles #288, which was fixed in version 2.1.5. Can you confirm that you are using the latest version of ITables?

[sidviny]

Hi,

I work together with Tom.

The version of iTables is 2.2.2

from our conda export: itables=2.2.2=pyh80e38bb_0

Yves VINDEVOGEL – Python Developer DFE - ArcelorMittal JF Kennedylaan 51, 9042 Gent, Belgiumhttps://urldefense.com/v3/__https:/www.google.com/maps/search/Kennedylaan*51,*9042*Gent,*Belgium?entry=gmail&source=g__;KysrKw!!AB_04_y_3-SRqw!9Q-LQ-y9853dsSluV7kw_x_jAO5vxBSX-ZAP3Vei0lLYzoWkCjnknsp7FGVb_TbaaxdGg49MqgW_SVYyVsHQ9CADxJh9Q8YJrW52nw$ (Office 1111-1215) Mob +32 497 570896

From: Marc Wouts @.> Sent: Tuesday, October 22, 2024 9:46 PM To: mwouts/itables @.> Cc: Subscribed @.***> Subject: Re: [mwouts/itables] searchbuilder gives wrong warning if column contains datetime (Issue #329)

External email warning: This email originated outside the company. Please do not click links or open attachments unless you were expecting this communication.

Hello @tomnobelsAMhttps://urldefense.com/v3/__https:/github.com/tomnobelsAM__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6sMGN3N8$ , the issue description ressembles #288https://urldefense.com/v3/__https:/github.com/mwouts/itables/issues/288__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6gIFUksc$, which was fixed in version 2.1.5. Can you confirm that you are using the latest version of ITables?

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/mwouts/itables/issues/329*issuecomment-2430113407__;Iw!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6mmDY8rA$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AZRYYXBJQQTLLBRHKJ62VPLZ42TQXAVCNFSM6AAAAABQMBKZ32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMZQGEYTGNBQG4__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6OjpcMBk$. You are receiving this because you are subscribed to this thread.Message ID: @.**@.>>

[tomnobelsAM]

Hi, The version where is went wrong is 2.0.0. With the version 2.2.2 it works fine.

Thanks a lot for your answer, Marc

Best regards Tom

Van: Yves Vindevogel @.> Verzonden: woensdag 23 oktober 2024 9:28 Aan: mwouts/itables @.> CC: Nobels, Tom @.>; Mention @.> Onderwerp: Re: [mwouts/itables] searchbuilder gives wrong warning if column contains datetime (Issue #329)

External email warning: This email originated outside the company. Please do not click links or open attachments unless you were expecting this communication.

Hi,

I work together with Tom.

The version of iTables is 2.2.2

from our conda export: itables=2.2.2=pyh80e38bb_0

Yves VINDEVOGEL – Python Developer DFE - ArcelorMittal JF Kennedylaan 51, 9042 Gent, Belgiumhttps://urldefense.com/v3/__https:/www.google.com/maps/search/Kennedylaan*51,*9042*Gent,*Belgium?entry=gmail&source=g__;KysrKw!!AB_04_y_3-SRqw!9Q-LQ-y9853dsSluV7kw_x_jAO5vxBSX-ZAP3Vei0lLYzoWkCjnknsp7FGVb_TbaaxdGg49MqgW_SVYyVsHQ9CADxJh9Q8YJrW52nw$ (Office 1111-1215) Mob +32 497 570896

From: Marc Wouts @.<mailto:@.>> Sent: Tuesday, October 22, 2024 9:46 PM To: mwouts/itables @.<mailto:@.>> Cc: Subscribed @.<mailto:@.>> Subject: Re: [mwouts/itables] searchbuilder gives wrong warning if column contains datetime (Issue #329)

External email warning: This email originated outside the company. Please do not click links or open attachments unless you were expecting this communication.

Hello @tomnobelsAMhttps://urldefense.com/v3/__https:/github.com/tomnobelsAM__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6sMGN3N8$ , the issue description ressembles #288https://urldefense.com/v3/__https:/github.com/mwouts/itables/issues/288__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6gIFUksc$, which was fixed in version 2.1.5. Can you confirm that you are using the latest version of ITables?

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/mwouts/itables/issues/329*issuecomment-2430113407__;Iw!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6mmDY8rA$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AZRYYXBJQQTLLBRHKJ62VPLZ42TQXAVCNFSM6AAAAABQMBKZ32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMZQGEYTGNBQG4__;!!AB_04_y_3-SRqw!5gz3Y0Gfwr71MluVyagWTPPuGMTPjuyUpMM7SJYerKq-Ik04Zy0Va8GKt5NnZcHEQwcWkenc7XopKLh6u8q9K7tFXV4sZEdYhtZ6OjpcMBk$. You are receiving this because you are subscribed to this thread.Message ID: @.**@.mailto:***@***.******@***.***>>

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/mwouts/itables/issues/329*issuecomment-2431137896__;Iw!!AB_04_y_3-SRqw!-jYkLb_DcRiHYMil6BE1Z3bnKGXKgKjxkXN8IcW00ROYIIFWnIutDmwS0U39BbqsFsX-eyKi5gO9Yl9sSZ-9Bg86FghZqFs$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/BMA5VTXIMUWHNJKMLFRTSPTZ45FWNAVCNFSM6AAAAABQMBKZ32VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMZRGEZTOOBZGY__;!!AB_04_y_3-SRqw!-jYkLb_DcRiHYMil6BE1Z3bnKGXKgKjxkXN8IcW00ROYIIFWnIutDmwS0U39BbqsFsX-eyKi5gO9Yl9sSZ-9Bg864VFXtj0$. You are receiving this because you were mentioned.Message ID: @.**@.>>