« first day (1364 days earlier)      last day (3339 days later) » 

4:39 AM
posted on November 26, 2014 by holly.ross.drupal

It is hard to believe, but we just finished our second-to-last board meeting of the year. The Association has grown and changed so much in 2014 and the November meeting was a great chance to talk about some of those changes and what we are planning for 2015. It was a somewhat short public meeting as we spent the bulk of our time in Executive Session to review the financial statements from the

 
 
5 hours later…
9:42 AM
Hellloooo?
echo...echo...echo...
@Letharion Hello>
 
10:12 AM
@Pureferret Hey :)
 
10:22 AM
How's tricks?
 
@Pureferret Pretty good. :) Stressed work day though >_< I accidentally force pushed a git branch I shouldn't have. Sorted it out now though, no damage done.
@Pureferret How are you getting on?
 
@Letharion not great
finding drupal very frustrating to work with, but I guess it's a learning process
 
@Pureferret Would that have something to do with your view not working? ;)
@Pureferret Yeah, Drupal's learning curve has been described as... difficult.
D8 is making a big effort to be less "Drupaly", FWIW.
@Pureferret I've got a lot of things on my plate ATM, so I didn't think through your question in any great level of detail, but my assessment to begin with is the same as J Reynolds. You have a filter which you don't need, and you should probably remove it.
If you have a one <-> one relationship between two entities, there's no need to apply additional filters (WHERE) as the relationship will do it for you (INNER JOIN).
@Pureferret And it probably is causing you trouble, as your page won't have the appropriate argument to pass to that filter, so the view probably doesn't even get called.
 
@Letharion got it
 
@Pureferret So I don't think you answered my comment: "Nothing comes up on the preview", which preview?
Let's make sure the View works on it's before trying to integrate it into a page.
 
10:41 AM
@Letharion So if I put my nid for an item with an endorsement, into the 'Preview with contextual filters' field, I get a 'view' with a label ("endorsement") but no content...Not even form the endorsement object!
 
@Pureferret Ok, so at least we can rule out Panels/Page manager then.
How much do you know about SQL?
 
@Letharion probably enough
In my head I can imagine the SQL query for my view
 
Check views "advanced settings" or whatever they are called, you can turn on SQL display there, which, if you know SQL, can be helpful in determining what's happening.
@Pureferret Note that there's advanced setting for individual views, and global settings. You're looking for the advanced settings. Probably reachable from the list of all views.
 
Gotcha
 
@Pureferret I wish I remembered.
There's a drush command for turning on "developer mode" as well which will flick a couple of switches for you.
"drush views-dev" or something.
 
10:47 AM
@Letharion I've looked into drush it seemed more hassle for what it's worth....
Query
SELECT node.nid AS nid, users_field_data_field_endorser.name AS users_field_data_field_endorser_name, users_field_data_field_endorser.uid AS users_field_data_field_endorser_uid, users_field_data_field_endorser.picture AS users_field_data_field_endorser_picture, users_field_data_field_endorser.mail AS users_field_data_field_endorser_mail, node.created AS node_created, 'node' AS field_data_body_node_entity_type
FROM
{node} node
LEFT JOIN {field_data_field_tech_endorsement} field_data_field_tech_endorsement ON node.nid = field_data_field_tech_endorsement.entity_id AND (field_data_field_t
And this is why I'm allergic to Code Generaters
 
@Pureferret I suppose that depends on what you are doing, but I wouldn't want to spend much time with Drupal without drush. Though if you're not used to the CLI, it's a bit of a hurdle.
 
@Letharion I'm happy with CLI but I'm on windows on a locked down machine
 
@Pureferret Ah, yeah that might be problematic.
@Pureferret So I've been following along with your question, which was about views. But has anyone told you that you _need_ to use Views?

If you're a developer, and know your way around php, you could pull the data out with an entity field query instead. (Or just straight SQL, but that kills most db agnosticism and isn't really recommended unless you need it)
@Pureferret Views, and similar tools are great because they empower non-developers to do a ton of stuff, but if you don't need the UI, skip it.
 
@Letharion I don't have the first clue about PHP. Java, Python, C etc., not a problem. PHP is a mystery to me.
Plus don't I need to 'compile' (for lack of a better word) it, and then install it like a module?
I'm using views as the people who introduced/mandated Drupal recommended it.
 
@Pureferret Ah, well then I can't really say what would suit you the best.
Python would probably be the closest, though I'm not terribly familiar with it.
PHP code would need to be a module, but a Drupal module, not a PHP extension. Not compilation step or similar needed.
 
10:56 AM
I mean, is PHP easy to learn? It sounds a but like bash/pythony type but with lots of esoteric names and stuff
 
@Pureferret I'd say PHP is as big as it is specifically because it is easy to learn. For better or worse.
 
@Letharion Yeah I was calling PHP code -> Drupal Module 'compilation' even though know thats a 'reserved keyword' :p
 
If you know Python, I doubt you'll have problems with PHP.
@Pureferret Sorry, really need to focus on other stuff for a bit.
 
@Letharion My first thought would be Python + Django
Okies
thanks for your help
 
@Pureferret If you do want to get started with PHP, here's a skeleton module: drupal.stackexchange.com/questions/62471/…
 
11:03 AM
@Letharion Thanks
 
@Pureferret Your welcome. :)
 
 
5 hours later…
3:54 PM
@Pureferret Hey :) Any progress?
 

« first day (1364 days earlier)      last day (3339 days later) »