Skip to main content

I have created a LINQ Operator Discovery Resource for all Devo users to learn about what operators are available to use for your Data Search Queries.

I created two custom pages to contain all this wonderfulness.

 

This resource will let you quickly filter and search for the right operator to fit your needs.  Members of Devo Connect only.

 

The full list of operators and code examples.  I also have it in PDF format attached.

 

Please leave a comment and let me know what you think!

To my LINQ Bible group,  thank you for all your help, here is the results!

 

PDF LINK
Ping me here if you need me to send it to you!

Hello @juan.delrio , This is very good. I like grouping by category and also the choice of color :-)

I couldn’t find following topics on other day, you could add if these are not explicitly explained elsewhere:

  1. Is it AND or OR condition here: 
    from abc
    where category=1, qty=10 (implicit AND or OR ?)

     

  2. Is it AND or OR condition here: 
    from abc
    where category=1
    where qty=10
    (implicit AND or OR? How it differs from previous one?)
  3. Devo keyword equivalent to ANSI SQL like top, having etc., maybe in separate page  

Hello Ifekxpd!

example 1:
This is an implicit AND 

It could also be written as “where category=1 AND qty=10

 

Example 2:

This is also a implicit AND

 

For 3,  maybe this article will help?
 

 


@ifekxpd the linqs

from T
where pred1
where pred2
where pred3

---

from T
where pred1, pred2, pred3

---

from T
where pred1 and pred2 and pred3

are logically equivalent. Juxtaposition of where filters acts as conjuntion of different predicates (and). All three variants are valid 👍


Thanks @juan.delrio for creating this awesome reference


Is the pdf download link working? Its not working for me. Spinning all the way


I just tested it, and it works.  I will email it to you!


I just tested it, and it works.  I will email it to you!

Thanks @juan.delrio. Looks like my VPN was an issue, i have downloaded it now. Will check and share my feedbacks. 


I just tested it, and it works.  I will email it to you!

i cannot download file too, kindly email back to me.


Sent!