shareplum icon indicating copy to clipboard operation
shareplum copied to clipboard

Can't use IsNull option under where query

Open PinYuan opened this issue 6 years ago • 3 comments

I think for IsNull option it only needs one parameter which represents where column value is null. I have no idea ??? what I should put where your source code specify need to provide. Can you give me an example because I try left empty it will have some exceptions.

query = {'Where': ('IsNull', 'column name', '???')}

PinYuan avatar Mar 13 '19 08:03 PinYuan

It looks like I didn't account for that. I'll see if I can fix that for you real quick tonight.

On Wed, Mar 13, 2019 at 3:24 AM PinYuan [email protected] wrote:

I think for IsNull option it only needs one parameter which represents where column value is null. I have no idea ??? what I should put where your source code specify need to provide. Can you give me an example because I try left empty it will have some exceptions.

query = {'Where': ('IsNull', 'column name', '???')}

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jasonrollins/shareplum/issues/37, or mute the thread https://github.com/notifications/unsubscribe-auth/AB1Z1ucrWDXgh4w_vaVDirRM5u2x-G5rks5vWLXDgaJpZM4bspSb .

jasonrollins avatar Mar 19 '19 00:03 jasonrollins

Hi jason,

I reopen this issue since the issue exists in the newest version.

PinYuan avatar May 07 '20 01:05 PinYuan

Hey, is there any updates to this? I'm trying to use the IsNotNull query but I'm getting an error:

  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/shareplum/list.py", line 247, in get_list_items
    value.text = self._sp_type(field[1], field[2])
IndexError: tuple index out of range

Thanks!

Fredericco72 avatar Jul 16 '21 12:07 Fredericco72