how do i query with the AND keyword using the sql selectfrom

Question

how do i query with the AND keyword using the sql selectfrom function all of the examples i found didn t include an AND keyword to the constraint expression

theopolis · Answer

Are you developing an extension If you re developing a table in core I would suggest against using the `SQL ` APIs they are fairly expensive Is there another way to get the data you want But to answer your question I d recommend using `SQL SQL` with a query and then going from there

AoS · Answer

yes i am developing an extension and i am trying to grab the local ip of the machine which is rather hard when not using the sql apis

AoS · Answer

and i would prefer not to send a dns query to google for resolving my main ip

theopolis · Answer

That makes sense I don t have a good answer off the top of my head I d recommend investigating the implementation of ` selectAllFrom` or using the default `select from interface addresses` then applying some filtering logic in the extension code

AoS · Answer

currently my query looks like this

AoS · Answer

select address from interface addresses where address like and friendly name like local and type= manual or type= dhcp

AoS · Answer

works pretty well from kolide and now trying to implement it into the extension

AoS · Answer

would be really glad for any insight or help on how to use SQL SQL correctly

AoS · Answer

and in general if you need help with writing the core code api documentation ill be glad to help as i think it could get a slight revamp

theopolis · Answer

gt core code api documentation I agree I think improving both the API and the documentation should be a prioritized goal for the next release could use help with it as usual